When the user that has installed the Sage 50 connector does not have full permissions in Sage 50, you may see the below error when trying to sync data into Codat:
ERROR [42000] The user you are logged in as does not have sufficient permissions to run this report. Ensure all Reports access rights are set to Full for the relevant ledger
The steps below outline how to update the user permissions in Sage 50:
- Log in to an admin account, usually an admin account is a manager or company owner.
- On the menu bar, click Settings.
- The user should then click on Access Rights from the drop down menu
- Select the user account that was used to install the connector, and choose 'Edit'
- The current access rights for "User 2" will be shown on the screen. You will then need to set the Access to Full Access by clicking on the button shown below.
- The user should then click OK to save the changes.
- They may now Close the User Access Rights Menu.
- You can now Queue a new Sync for the company, and the datasets that previously failed should now be able to complete successfully.