Article ID: KB0051
When logged into Dynamics GP with a User ID that is NOT ‘sa’ and selecting the Commission Doc Detail or Commission Doc Summary SmartList Builder objects, no data displays.
To resolve this issue, open up SQL Management Studio, select your company database, and grant access to DYNGROUP for the Dynamics GP Views called SalesTransactions and SalesLineItems. Use the following SQL script:
- GRANT SELECT ON SalesTransactions TO DYNGRP
- GRANT SELECT ON SalesLineItems TO DYNGRP
This is necessary because the Commission Doc Detail and Commission Doc Summary SmartList Builder objects created by EthoTech uses a link to these Dynamics GP Views.