Tag: GP Error
-
Case Study: GplPostBatch Error DBMS:0, Microsoft Dynamics GP 20052
Situation: I have had several clients come to me with the following error: GplPostBatch returned the following results: DBMS:0, Microsoft Dynamics GP 20052. This typically occurs when they are posting a journal entry in the GL or printing an edit list. The one thing that they all have in common is that they used the…
-
Excel Report Error: “The SELECT permission was denied on the object ‘accounts’, database ‘MLC’, schema ‘dbo.’”
With Microsoft Dynamics GP permissions come from two different types of accounts. There are local accounts and GP accounts. Local accounts are setup on a domain in Active Directory. GP accounts are setup within the GP programs. The permissions for excel reports pulls from Active Directory and not Microsoft Dynamics GP. Specifically, it is an…