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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / User computer restarte...
Microsoft Dynamics GP (Archived)

User computer restarted while posting Purchase Manual Payment batch

(0) ShareShare
ReportReport
Posted on by sandipdjadhav 18,306

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

I have the same question (0)
  • Verified answer
    Tom Cruse Profile Picture
    Tom Cruse 1,477 on at
    RE: User computer restarted while posting Purchase Manual Payment batch

    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.

  • DinB Profile Picture
    DinB 3,944 on at
    RE: User computer restarted while posting Purchase Manual Payment batch

    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.

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at
    RE: User computer restarted while posting Purchase Manual Payment batch

    Tom and Max,

    Appreciate for your quick reply. Let me work on given solution and will update you status.

    Tks

    Sandip

  • Verified answer
    Thomas Newcomb Profile Picture
    Thomas Newcomb 1,810 on at
    RE: User computer restarted while posting Purchase Manual Payment batch

    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

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at
    RE: User computer restarted while posting Purchase Manual Payment batch

    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

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans