Investigate trial balance differences between users
If two users run the same Trial Balance criteria and get different figures, the security settings for each user cause the difference. This guide explains how to identify the differences and where to change the security settings.
Excluded nominals
The excluded nominals section of the TB shows the value of the hidden details. This doesn't necessarily mean there is a nominal that the user can't access, but it could be a ledger account or a document type.
Log in as the admin user
If in doubt as to which version of the TB is correct, log in using the PSFADMIN or CUSTADMIN credentials and then run the same TB. Because this user group bypasses all security, its users can access all transactions in the system. Then compare the balance of each nominal to the user's version and identify the differences.
Missing nominal
If the nominal is missing altogether, check the security restrictions in place for that nominal.
To access the nominal, you need the security roles in the View and Post lists. Take a note of the roles and then open the Financials Administrator module to enable the role for the relevant user group. Refer to Assign Security Roles to User Groups.
You can also check that the Access level is suitable for the user.
Nominal shows a different balance
If the nominal is showing on the list but is showing a different value to the administrator TB, this indicates that although the user has access to that nominal, they don't have access to every transaction posted to it.
The ledger account (cost centre) or the document type could cause this.
On the Admin user version of the TB, right-click on the line and select 'Details'
Account access
When the transactions appear, group them by the account column to separate the subtotal for each account. Select and drag the column header into the dark grey area.
The totals for each account can help you find an account that the user does not have access to.
Account Security works on the same principle as the nominal security. Check in Accounts, select the ledger (for example, LLL_COSTCTR) and then the relevant account. Select the Security tab and note the roles in the View and Post lists.
Then assign the security role to the user group in the Financials Administrator module. The user needs to log out and log in again for the settings to update.
Document type access
The difference could also be down to the document type used. Group the details in the same way, by dragging the Type column header into the grey area.
If you find a document type that the user does not have access to, assign it through Admin, then Security.
The window lists the user groups and the document types. Select the user group and then select the boxes to give access to the different document types. The user needs to log out and log in again for the settings to update.
Security roles are correct but the user still cannot access the account or nominal
If you have confirmed that the user group has the relevant security roles assigned in Financials Administrator but the user still cannot access the data, check that the access level on the nominal or account is suitable.
In the Account maintenance menu, the access level is on the General tab.
If an account has level 3 access, users with an access level of 3 or above can open it.
You assign the user group access level in the Financials Administrator module, on the Security tab.
User can open the nominal but no transactions appear
If the nominal is shown on the TB but no transactions are listed, then as well as the account security, you may need to check the security on the ledger that the nominal is linked to - if the user doesn't have access to the ledger, they will not be able to see any accounts within that ledger at all.
Check in Ledgers, select the ledger from the list and select 'Security'. Again, the View and Post security roles give access to the ledger.