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
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 Googled and found the following link which took only a couple of minutes to resolve the issue.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,532
Super User 2024 Season 2
#2
Martin Dráb
228,501
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (