CDI error when trying to upload Transaction Details from Great Plains

When a user tries to bring in Transaction Details to Planning Maestro through CDI they receive below error"
Exception: The EXECUTE permission was denied on the object 'DYN_FUNC_GL_Ledger_Name', database 'Your Database', schema dbo
The login being used to connect to the GP SQL Server does not have Execute permission on the database.
Steps to Resolve:
1. Login to SSMS.
2. Right Click on the Company Database.
3. Click Permissions.
4. Highlight the username and scroll through permissions to Execute.
5. Check box for Grant.
0 out of 0 found this helpful



Please sign in to leave a comment.