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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Trial balance error in...
Microsoft Dynamics GP (Archived)

Trial balance error in the purchasing module

(0) ShareShare
ReportReport
Posted on by Henry Ramsey 115
When we attempt to run a trial balance, we get the following error on this particular vendor.
 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of
PRIMARY KEY constraint ‘PK##0365755’. Cannot insert duplicate
Key in object ‘dbo.##0365755’.  The duplicate key value is
(FRONTIER – 45 ,       , 1128065MAR       ,0,112808
 
After clicking OK to continue the following dialog window appear.
 
The store procedure pmHistoricalAgedTrialBalance returned the
following results: DBMS: 2627, Microsoft Dynamics GP:0.
 
If we run a trial balance against all other vendors, everything seems to run fine.
 
What can we do to remove this duplicate key?  I don’t have a lot of experience working with SQL but if the steps are laid out, I am sure I can remove the duplicate key.  Thanks in advance for any assistance you can provide.
Thanks,
-Henry

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Did you run check links for purchasing?

  • Mark DaCar Profile Picture
    Mark DaCar 120 on at

    Downloan the Find PM Dups v10.0 from customer source. Run this against the company that has the issue. You will get several choices to find which tables have the duplicates. Just delete from the table which only has the one transaction

  • Henry Ramsey Profile Picture
    Henry Ramsey 115 on at

    Muhammad Zubair - We ran check links on the purchasing module with no problems found.   Thank you very much for responding.

    Mark DaCar- I am not familiar with customer source.  Could you paste the link to the download in a reply message please?  Thank you for replying also.

  • Mark DaCar Profile Picture
    Mark DaCar 120 on at

    mbs.microsoft.com/.../automatedsolutionsR10.htm

  • Henry Ramsey Profile Picture
    Henry Ramsey 115 on at

    Mark, I finally got a chance to install and run the Find PM Dups v10.0 and nothing showed up as duplicate records.  I am open to other suggestions if you or anyone else have any.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    check following,

    community.dynamics.com/.../34-the-stored-procedure-createsqltmptable-returned-the-following-results-58-dbms-58-12-34-exceptions.aspx

  • Henry Ramsey Profile Picture
    Henry Ramsey 115 on at

    Muhammad,

    First let me apologize for taking so long to get back to you.  I reviewed some SQL video training before attempting to run the find duplicate scripts.  The offending duplicate record was found in the PM20000 module and subsequently deleted.  After the deletion, we ran check links and we were able to run the Aged Trial balance.  Again, thank you for your help and I apologize for taking so long to respond.

    For anyone who read this post: I found my answer in the section (DBMS: 2627 refers to a duplicate key error and is covered in more detail in the article: Identifying Duplicate Transactions).  The SQL script --PM Duplicates script found the duplicate record which pointed me in the right direction to delete it.  After the deletion, we ran Check Links on the PM modules.  Check Links corrected something which allowed us to successfully run our Aged Trial Balance.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans