Error Posting Manual Payment

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (4)

Answers (0)

Nanook Software 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have already looked at these table and the Check Links did not resolve the issue either.

Anyone else?

Was this reply helpful? Yes No
Tami Farrelly 5,080 on at

Like (0)

Report

so what was the solution??

I dont follow links to site other thank MS KBs etc

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

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'

Was this reply helpful? Yes No