To update the nominal ledger in Dimensions from payroll, you'll need to set up a link between the databases. To do this, follow the steps below.
đNote: If you are a hosted customer, this must be carried out by a consultant. You can request this through your account manager.
SelectPay Administrator
đTip: We recommend using a user account with SA permissions.
Log in using an administrator account to the server hosting SelectPay.
Press the Windows key and search for 'SelectPay Administrator'.
Click SelectPay Administrator, and click the Database tab.
Click Access Dimensions Link Setup, and enter the required information.
Servername \ SQL instance name.
Dimensions database name.
User account, that has SA SQL permissions.
Click Ok, and repeat step 4 for each Dimensions database.
Linking specific databases
Log in using an administrator account to the server hosting SelectPay.
Press the Windows key and search for 'SelectPay Client'.
Click SelectPay Client, and log in using a payroll administrator account.
Click System, and then click Application Configuration.
Click System Configuration, and then the Account Database tab.
Enter the required information.
Servername \ SQL instance name.
Dimensions database name.
User account, that has SA SQL permissions.
Click Test Connection, and then click Save and Close.
Additional information
â ď¸Warning! Using Windows authentication will cause Dimensions to use the last created Windows user.
The User account must have the AA_DIMENSIONS_R role in SQL.
The AA_DIMENSIONS_R role has a wide range of permissions; you can create a dedicated user record for the task.
You can use a Windows Authentication login, which offers additional security, but it must belong to the AA_DIMENSIONS_R role.