I get the following error when trying to post a manual payment. I get No error if click on "Print" button instead of "Post" and the Edit List doesn't show any errors.
Table PM30300 and PM30600 do not have any records of these transaction but PM10200, PM20000, PM20100 do have all vouchers in it.
Error:
Unhandled database exception:
A save operation on table 'PM_Distribution_HIST' has created a duplicate key.
EXCEPTION_CLASS_DB
DB_ERR_DUPLICATE
*This post is locked for comments
delete PM30600 where VCHRNMBR = 'xxxxxx' AND VENDORID = 'zzzzzz'
delete PM30300 where VCHRNMBR = 'xxxxxx' AND VENDORID = 'zzzzzz'
update SY00500 set MKDTOPST=0, BCHSTTUS=0 where BACHNUMB = 'MyBatch'
so what was the solution??
I dont follow links to site other thank MS KBs etc
I have already looked at these table and the Check Links did not resolve the issue either.
Anyone else?
I always like to use the built-in Dynamics GP functions first.
Run Checklinks on the Purchasing module and for all Payables units.
Remember to always run reconcile after and try in test system first.
But if you want to run SQL, here is a simple code that will give you the PM History info and if it exists in the work, tax work or open tables.
If it appears in one of the other tables, it will show a 1 in the appropriate column.
SELECT * FROM (
SELECT h.VCHRNMBR, h.VENDORID, h.DOCNUMBR,
CASE WHEN o.VCHRNMBR IS NOT NULL THEN 1 ELSE 0 END as 'Open',
CASE WHEN t.VCHRNMBR IS NOT NULL THEN 1 ELSE 0 END as 'TrxWork',
CASE WHEN w.VCHRNMBR IS NOT NULL THEN 1 ELSE 0 END as 'Work'
FROM PM30200 h
LEFT OUTER JOIN PM20000 o on h.VCHRNMBR = o.VCHRNMBR AND h.DOCTYPE = o.DOCTYPE
LEFT OUTER JOIN PM10000 t on h.VCHRNMBR = o.VCHRNMBR AND h.DOCTYPE = t.DOCTYPE
LEFT OUTER JOIN PM10300 w on h.VCHRNMBR = o.VCHRNMBR AND h.DOCTYPE = w.DOCTYPE
) as z
WHERE [Open] = 1 OR [TrxWork] = 1 OR [Work] = 1
#1
André Arnaud de Cal...
292,606
Super User 2025 Season 1
#2
Martin Dráb
231,551
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
