Violation of Primary Key Constraint

(0) Share

Report

Posted on by rcr123

7,986

Good day,

I was running the Reconcile to GL >> Inventory report when the attached message came up. The Excel report generates but all transactions are appearing as unmatched, ran check links and reconcile but the message is still there.

Has anyone seen this and how was it resolved, thanks.

Regards

Rosemary

Categories:

Microsoft Dynamics GP

All responses (4)

Answers (0)

rcr123 7,986 on at

Like (0)

Report

RE: Violation of Primary Key Constraint

Thank you will give this a try.

Regards
rcr123 7,986 on at

Like (0)

Report

RE: Violation of Primary Key Constraint

Thank you for your response, the document is valid and dated 2-25-2023. If I run the Reconcile to GL >> Inventory for that period is goes through and exports successfully but all transactions are unmatched.

Regards
Leng Papio 855 on at

Like (0)

Report

RE: Violation of Primary Key Constraint

The table referenced in the error starts with ##. This is a temp table.

Try clearing the Temp folder (Usually %temp%) or in C:\Windows\Temp
Hokuminaria 2,950 on at

Like (0)

Report

RE: Violation of Primary Key Constraint

Hey Rcr123,

This error states you have a data issue with Document 388596. You will need to review that transaction and determine if there is an actual duplicate.

There are a few Product issues with this process that can cause this error as well. However, to determine if the issue is a Product Issue, I would need to see the data. In order for me to review the data, you would need to create a support request for this.

I hope this helps!

Thank you!

Brandon | Microsoft Support Engineer.