Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Error Posting Manual Payment

(0) ShareShare
ReportReport
Posted on by

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

  • RE: Error Posting Manual Payment

    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'

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at
    RE: Error Posting Manual Payment

    so what was the solution??

    I dont follow links to site other thank MS KBs etc

  • RE: Error Posting Manual Payment

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

    Anyone else?

  • Nanook Software Profile Picture
    Nanook Software 2 on at
    RE: Error Posting Manual Payment

    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

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,606 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,551 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans