News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Does anyone have a scr...

Microsoft Dynamics GP (Archived)

Does anyone have a script that will sum the apply amounts on receivables payments and then update the amount remaining on the payment? We've got a number of payments that are fully applied but still show as if they have an open balance. The invoices that

(0) Share

Report

Report

Posted on by irishjamr2

615

Receivables payment entered for $525. Of that, $452.50 was applied to an invoice and $72.50 was applied to a debit memo, but the payment still shows an amount remaining of $72.50.

Did try running checklinks on receivables open trans and also tried rm reconcile.

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Heather Roggeveen 9,144 on at

Like (0)

Report

Re: Does anyone have a script that will sum the apply amounts on receivables payments and then update the amount remaining on the payment? We've got a number of payments that are fully applied but still show as if they have an open balance. The invoices

RM Reconcile, using the outstanding transactions amount would usually fix this issue. I haven't had a case where it didn't.

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 231,409 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans