Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Apply Manual Payment t...
Finance | Project Operations, Human Resources, ...
Suggested answer

Apply Manual Payment to Open AP Transactions

(0) ShareShare
ReportReport
Posted on by Christopher Flood

When one of our team members created a manual payment, they noticed the balances of OPEN transactions appear as 0.00 when they attempted to apply this payment to the invoices being settled.  When they click the Amount Remaining, the window is empty - no document(s) are applied against the transaction the manual payment is settling.

Do you have a suggestion on the best course of action so the Amount Remaining displays the amount of the transactions being settled as there are several transactions (All except the first document in the below screenshot) this pertains to?

pastedimage1665522386492v1.png 

Categories:
Microsoft Dynamics GP
  • Suggested answer
    JanelleM Profile Picture
    JanelleM on at
    RE: Apply Manual Payment to Open AP Transactions

    Hi,

    Thank you for using Microsoft Forums.

    If you have an invoice which does not have anything applied to it, but the current transaction amount is $0.00 it could be that the invoice was at one point part of some type of either posting or apply interruption.

    What you can do is manually update the current transaction amount of this invoice to be the document amount with the script below.  Make sure to test this in a test company first to ensure you get the results you desire and do not uncover other issues with these invoices.

    --replace YYY with the correct DEX_ROW_ID for that invoice/line in the PM20000 table

    Update PM20000 set CURTRXAM = DOCAMNT where DEX_ROW_ID = YYY

    I hope this information helps.

    Janelle

    GP Support

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,436 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans