You’re offline. This is a read only version of the page.
18,265
Hello,
User was posting purchase manual payment batch and suddenly his computer got restarted. Now each payable invoice shows fully paid but no Payment Transaction is attached.
Checklink and Reconiliation didn't help at all. Is there any way to rectify data or I have delete transactions?
Thank
Sandip
*This post is locked for comments
Hello,
I have deleted transactions from applied details table PM20100 and updated document amt to current amt. Run checklink it didn't show any error.
Thanks for help.
Thanks
Sandip
Hi Sandip!
If the payables invoice does not have a payment applied to it but is in the history status you won't be able to void it out. The Void Historical Transaction will only void out payments, however, if the payables invoices are in Open you should be able to use the Void Open Transactions. Another option if the invoices are in open would be to update the PM20000 to make sure the CURTRXAM is correct. You would want to test all of this in test company though.
If the Invoices are in history the only real way to correct the situation would be to remove transaction history on the invoices and then re-create them. The only issue with removing history on the invoices is you would have to create a manual GL entry to reverse the amounts that were already entered for the invoices.
Please let us know if you have any other questions!
~Thomas Newcomb
-------------------------------------
Dynamics GP Support Engineer
-------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights
Tom and Max,
Appreciate for your quick reply. Let me work on given solution and will update you status.
Tks
Sandip
You can try in Test Company first:
If the Invoices are still in PM20000 table, then you can try to correct the "CURTRXAM" in the PM20000 table and re-apply the Payments again. "CURTRXAM" should be the remaining amount in the Invoice before the last payment was applied.
If the Invoices are already moved to History table PM30200, it may be easier to Void the Historical Invoices and re-create them again. There will be few things to consider such as GL posting, and posting dates/periods.
Reconcile should technically correct the problem but if it doesn't and the posting setup is set to Post To and the batch hasn't been posted to the GL I would first delete the created batch in Financial and then delete the transaction.
Most likely in PM20000 and PM20100 since it believes it's been applied. After that I would run Checklinks on the Payables Transaction Logical File and Vendor Master Logical File.
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 (