You’re offline. This is a read only version of the page.
5,195
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
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.
somebody can answer me plz
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
What's provided by Mr. Richard is more than enough. Although, I would recommend going for a check links and reconcile as a prerequisite.
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.
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...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (