Product: Dynamics GP Enterprise & Total Reports
Error: Error exporting file. Please check your report setup
Issue: When attempting to Export a document using the TrueCommerce vSync Module within Dynamics GP Enterprise you encounter an error when the Audit/Error Report attempts to load 'Error exporting file. Please check your report setup.'
Reason: The user processing the document does not have sufficient permissions to properly access Total Reports
Solution - Update User's Database Permissions
You will need to have your I.T Department or System Administrator update your Dynamic GP user's permission set within the SQL Server providing them with datareader and datawriter permissions for the DYNAMICS, TotalReports, and Your Company databases.
Database | Permissions |
DYNAMICS | datareader, datawriter |
TotalReports | datareader, datawriter |
Company Database | datareader, datawriter |
Solution - Add User to DYNGRP
Additionally you may need to add the Dynamics GP User to the DYNGRP within the SQL Server permission set which will expand the permissions for that particular user across all of Dynamics GP.
Solution - Switch to the System Administrator (SA) User
If you do not have access to the SQL Server Database for your Microsoft Dynamics GP system you can switch to an System Administrator (sa) user within Dynamics GP to process the order and view reports.
If switching to an administrator solves the issue - then this confirms a permission issue with the previous user
rev 6/20/2025