web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Manual Payment interru...
Microsoft Dynamics GP (Archived)

Manual Payment interruption

(0) ShareShare
ReportReport
Posted on by Refeesh Ali 5,201

Hi,

I would like to seek your attention that I have a problem in one of our manual payment entry.

1)      Due to some interruption one entry is not posted completely it showing the error "Unhandled database exception : A save operation of Table “PM_Distribion_Hist” has created a duplicate key”..I understood may be half of the transaction is been posted.

2)      GL entries made for complete transactions.

3)      I try to make another Manual Payment instead of above mentioned transaction due to partially posted. I try to unapplied the invoices, it’s not unapplying complete.

Kindly advice me how can I handle this situation.

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    let's clarify some things...

    1.  Reveivables or Payables?  And what version of GP?

    2   You said that the GL Entries were made.  Are they posted to GL?

    First try rebuilding the RM Key or PM Key files.  Instructions can be found on customer source.  If you don't have access to that, post back here and we will post instructions.

    Next, if the GL entries did NOT post, try voiding the payment and then deleting the GL transactions from the batch holding them.

    If the GL entries did post,  But the payment will not complete posting.....(would be strange) then void the transaction and check GL again.  If only the payment but not the void is there, do a reversing entry.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    What's provided by Mr. Richard is more than enough. Although, I would recommend going for a check links and reconcile as a prerequisite.

  • Refeesh Ali Profile Picture
    Refeesh Ali 5,201 on at

    sorry for late reply. thanks for your tips. can you advice me which is the article i can use for rebuilding PM keys. when i search i cannot find. please advice

  • Refeesh Ali Profile Picture
    Refeesh Ali 5,201 on at

    somebody can answer me plz

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Run the following queries on your company database in order to determine the status of your payment document .


    -- PM Module
    SELECT * FROM PM00400 WHERE CNTRLNUM = '#PaymentNumber' -- PM Keys Master
    SELECT * FROM PM10400 WHERE PMNTNMBR = '#PaymentNumber' -- Unposted Manual Payments
    SELECT * FROM PM20000 WHERE DOCNUMBR = '#PaymentNumber' -- Posted Transactions
    SELECT * FROM PM10100 WHERE VCHRNMBR = '#PaymentNumber' -- GL Distributions for Work and Open Transactions

    -- General Ledger
    SELECT * FROM GL10000 WHERE DTAControlNum = '#PaymentNumber'  -- Unposted GL
    SELECT * FROM GL20000 WHERE ORCTRNUM = '#PaymentNumber' -- Posted GL

    Your feedback is highly appreciated.

     

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans