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
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
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 ?
whats the process to safely remove the records?
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,188 Super User 2024 Season 2
Martin Dráb 230,030 Most Valuable Professional
nmaenpaa 101,156