Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Duplicate Primary Key ...

Duplicate Primary Key Error in Payables Trial Balance

(0) Share

Report

Posted on by Community Member Microsoft Employee

One of our users encountered an error while trying to generate the Payables Trial Balance report in GP 2013. The error message is:

[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'PK##1313941'. Cannot insert duplicate key in object 'dbo.##1313941'. The duplicate key value is (CASH, ,2011-0000000002 , 0, 2011-0

I understand that the database has a duplicated record (I really have no idea how this happened to begin with) and I would like to handle the issue. The problem is that I cannot figure out which table has that duplication from the error message. Can anybody please help me with this?

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

26P2ER 1,773 on at

Like (0)

Report

RE: Duplicate Primary Key Error in Payables Trial Balance

Hello Y2H

I would recommend the user sign all the way out of GP, sign back in and try to generate the same report again.

You error text has double hashtags and hence is referring to temporary tables.

Those usually go away when the user gets a clean GP session going.

Hope this helps