Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

  • Henry Ramsey Profile Picture
    Henry Ramsey 115 on at
    Re: Trial balance error in the purchasing module

    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.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Trial balance error in the purchasing module

    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
    Re: Trial balance error in the purchasing module

    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.

  • Mark DaCar Profile Picture
    Mark DaCar 120 on at
    Re: Trial balance error in the purchasing module

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

  • Henry Ramsey Profile Picture
    Henry Ramsey 115 on at
    Re: Trial balance error in the purchasing module

    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
    Re: Trial balance error in the purchasing module

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Trial balance error in the purchasing module

    Did you run check links for purchasing?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans