web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Violation of Primary Key Constraint

(0) ShareShare
ReportReport
Posted on by 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.

SnipImage-_2800_1_2900_.JPG

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

Regards

Rosemary

Categories:
I have the same question (0)
  • rcr123 Profile Picture
    7,986 on at
    RE: Violation of Primary Key Constraint

    Thank you will give this a try.

    Regards

  • rcr123 Profile Picture
    7,986 on at
    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 Profile Picture
    855 on at
    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 Profile Picture
    2,950 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,239

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 903 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 604 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans