How do I display data in the Commission Doc Detail/Summary SmartList Builder objects when logged in with a User ID that is NOT ‘sa’?

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.