Microsoft Dynamics GP (Archived)

Manual Payment interruption

(0) Share

Report

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)

All responses (5)

Answers (1)

Sort by

Suggested answer

Richard Whaley 25,195 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Refeesh Ali 5,201 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Refeesh Ali 5,201 on at

Like
a
(0)

Report
Copy link

Link copied!

somebody can answer me plz

Was this reply helpful? Yes No
Verified answer

Mahmoud Saadi 32,738 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No

Community site session details

Manual Payment interruption

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the May Top 10 Community Leaders

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates

Community site session details

Manual Payment interruption

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the May Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates