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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Manual payment interrupted

(0) ShareShare
ReportReport
Posted on by 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

I have the same question (0)
  • Community Member Profile Picture
    on at

    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,

  • SUPPORT-ICM Profile Picture
    695 on at
    “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
    on at

    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.

  • Community Member Profile Picture
    on at

    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,

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans