Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

PM_PAID_TRANSACTION_HIST duplicate key

Posted on by 20

DYNAMICS  GP 2010 (v11.00.1247)

One of our users reported she was suddenly unable to create a new transaction entry.  When I look up the batches -- I see a "TABLE UPDATES INTERRUPTED" under the user's login.

This is the error mesage that it returns when the user does a new transaction entry:

"payables management transaction that was interrupted during normal processing has been recovered. use the payables management transaction entry windows to continue processing the transaction. a save_operation on table 'PM_PAID_TRANSACTION_HIST' has created a duplicate key."

I've tried using the script from this page to try and find a reference to delete but doesn't look like our tables have the same ID/names.

http://dynamicsgp.wordpress.com/2009/06/03/batch-stuck-in-posting-receiving-busy-etc-etc/

 

WHEN I try to a new transaction entry under purchasing, I actually see also a error about "UNABLE TO GENERATE A VOUCHER NUMBER".

 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: PM_PAID_TRANSACTION_HIST duplicate key

    i've recently run into this error, where a a transaction in a corrupted batch sent both the invoice and payment to history. The batch is still intact in work tables and invoice still in open transactions - just duplicates in history.

    It's one invoice and one payment from what I've identified. The history tables I believe affected are PM30200, PM30300 and PM 30600.

    My wonder is that it seems inconsistent. Meaning im seeing the invoice in PM30200, but not the payment. And conversely, I see the payment distributions in PM30600 and not the invoices. Is this normal given that it was a corrupted batch? I just want to ensure I'll be cleaning up all the records necessary.

    What is the complete set of tables of interest in this scenario?

    thank you for any feedback

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: PM_PAID_TRANSACTION_HIST duplicate key

    Hi,

    Can you please elaborate on the sentence "I've tried using the script from this page to try and find a reference to delete but doesn't look like our tables have the same ID/names." ?

    In GP2010 you usually have only one system DB for GP which is DYNAMICS.. Can you post here the content of the tables SY00800 & SY00801 from the DYNAMICS DB and the table SY00500 from the company DB ?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: PM_PAID_TRANSACTION_HIST duplicate key

    whats the process to safely remove the records?

  • Re: PM_PAID_TRANSACTION_HIST duplicate key

    Hi,

    Can I suggest that you run the following scripts to see if you have any duplicate records in History and Open. Then you will need to assess whether you are keeping the history data or the open data. Once you have decided on this, remove the incorrect records.

    /* Script to find duplicates between Work,Open, and History in PM */

    Print 'Dupicates between PM history(PM30200) and PM open(PM20000)'

    Print ''

    select a.VCHRNMBR,a.VENDORID,a.DOCNUMBR from PM30200 a, PM20000 b where

    a.VCHRNMBR = b.VCHRNMBR and

    a.DOCTYPE = b.DOCTYPE

    go

    Print 'Dupicates between PM history(PM30200) and PM transaction work(PM10000)'

    Print ''

    select a.VCHRNMBR,a.VENDORID,a.DOCNUMBR from PM30200 a, PM10000 b where

    a.VCHRNMBR = b.VCHNUMWK and

    a.DOCTYPE = b.DOCTYPE

    go

    Print 'Dupicates between PM history(PM30200) and PM payment work(PM10300)'

    Print ''

    select a.VCHRNMBR,a.VENDORID,a.DOCNUMBR from PM30200 a, PM10300 b where

    a.VCHRNMBR = b.PMNTNMBR and

    a.DOCTYPE = b.DOCTYPE

    Print 'Dupicates between PM history(PM30200) and PM manual payment work(PM10400)'

    Print ''

    select a.VCHRNMBR,a.VENDORID,a.DOCNUMBR from PM30200 a, PM10400 b where

    a.VCHRNMBR = b.PMNTNMBR and

    a.DOCTYPE = b.DOCTYPE

    go

    go

    Print 'Dupicates between PM open(PM20000) and PM transaction work(PM10000)'

    Print ''

    select a.VCHRNMBR,a.VENDORID,a.DOCNUMBR from PM20000 a, PM10000 b where

    a.VCHRNMBR = b.VCHNUMWK and

    a.DOCTYPE = b.DOCTYPE

    go

    Print 'Dupicates between PM open(PM20000) and PM payment work(PM10300)'

    Print ''

    select a.VCHRNMBR,a.VENDORID,a.DOCNUMBR from PM20000 a, PM10300 b where

    a.VCHRNMBR = b.PMNTNMBR and

    a.DOCTYPE = b.DOCTYPE

    Print 'Dupicates between PM open(PM20000) and PM manual payment work(PM10400)'

    Print ''

    select a.VCHRNMBR,a.VENDORID,a.DOCNUMBR from PM20000 a, PM10400 b where

    a.VCHRNMBR = b.PMNTNMBR and

    a.DOCTYPE = b.DOCTYPE

    Hope this helps.

    Regards Tracy

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans