CDI error when trying to upload Transaction Details from Great Plains

We're transitioning to a new User Interface, and are in the process of updating Help Hub content to match the new interface.
When a user tries to bring in Transaction Details to Planning Maestro through CDI they receive the 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:

  • Login to SSMS.
  • Right Click on the Company Database.
  • Click Permissions.
  • Highlight the username and scroll through permissions to Execute.
  • Check box for Grant.
0 out of 0 found this helpful



Please sign in to leave a comment.