Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Manual payment interru...
Microsoft Dynamics GP (Archived)

Manual payment interrupted

(0) ShareShare
ReportReport
Posted on by SUPPORT-ICM 695
We were entering a manual payment against some open invoices when our IT dept accidentally unplugged the system and the computer froze up. When a/p went back into enter the payments, they show as fully applied but they are not. If we run an aging, they still show as open. So its 1/2 completed. Is there a way to redo the process and start over? There shows nothing to void, nothing posted but when she goes to try and redo the manual payments, it tells her its been applied. It seems like its just out there floating now.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Manual payment interrupted

    Ruel's suggestion is bang on in terms of resetting the payments available to apply amount. However, you hve an issue with invoices also? Their applied amount is zero, their apply record shows up blank, they are still marked as 'open'...yet if you enter a new payment you cannot apply it against these invoices.

    There may be other data corruption. Try resetting the unapplied amount back to the original payment amount. Then try and void the payment. Then run a check links. This may resolve the invoice issues. If not you will probably need to dig into the data in the payables apply tables.

    Best regards,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Manual payment interrupted

    If you are handy with SQL, you can open table PM20000 and locate the record that was stuck and increase the CURTRXAM field by the amount that you want to unapply. That field is probably 0 right now. The PM20000.CURTRXAM field = amount available to apply.

    As always, try this first in a test environment if possible.

  • SUPPORT-ICM Profile Picture
    SUPPORT-ICM 695 on at
    Re: Re: Manual payment interrupted
    “Are you sure the payment is not available for posting?” YES “If you do an inquiry on that vendors account, is the payment in work, open, or history?” No pymnt is in inquiry that is listed as open and the invoice is showing to be open with zero in the unapplied area. “Can you void the payment?” There is no payment open to void “When you drill back on the apply record for the invoice, from within the vendor inquiry window, is the payment listed? NO Or is the apply window empty. YES Is the remaining amount of the invoice zero? YES “What is the status of the invoice – Open or history” Open “Are any of these transactions multicurrency?” NO In inquiry window the invoices in question are open, with zero available to apply towards payments If you try to start a second manual payment you can not apply a payment towards these invoices as there is nothing available to apply towards the payment. I did run a check links on the payables transactions logical files which said “File Name Error Message PM Distribution WORK OPEN The distribution records for voucher/payment number PMCHK00011478 have been deleted.” I hope this helps to figure how to fix. We are trying to close out our month.
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Manual payment interrupted

    Hi,

    Are you sure the payment is not available for posting? If you do an enquiry on that vendors account, is the payment in work, open or history?

    Have you tried running a check links on the payables transaction logical files?

    Can you void the payment?

    When you drill back on the apply record for the invoice, from within the vendor enquiry window, is the payment listed ? or is the apply window empty. Is the remaining amount of the invoice zero?

    What is the status of the invoice - Open or history?

    Are any of these transacions multicurrency?

    Best regards,

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans