Notifications
Announcements
No record found.
Followed all the procedures to apply a cash payment to invoices for our customer, however, when I run an AR aging, both the invoice and cash payment are still showing up, even though they net to $0. What do I need to do in order for these items to net to $0 and not show up on the aging report for the customer?
Thank you!
JKB
In the Receivables Trial Balance Reports screen, use the Aged Trial Balance with Options report. In the middle of the screen to pick the options for the report, there is an Exclude section. Check the box "Exclude fully applied documents" and these won't show.
Joe
Ok, but is there a way to run an AR aging by customer to net both invoice/payment to $0 for payments that have been applied to via the cash receipt process to specific invoices?
It is possible that you have partial cents that you aren't seeing. We have had this problem a few times during the years.
Below is a good link on how to check and fix these.
From <https://www.gpug.com/blogs/steve-erbach/2015/11/08/how-to-correct-a-fractional-cents-problem-in-gp-part-one?CommunityKey=4754a624-39c5-4458-8105-02b65a7e929e>
In addition to Debbie's suggestion, it's possible that your apply dates are later than you transaction dates. For example, if you applied them yesterday the system would have defaulted the apply dates to 3/12/2021. Most people that don't do this every day forget to change the apply dates, or don't even know they can. If you're printing a historical aged trial balance as of 2/28/2021, those transactions will show as unapplied, because they were truly unapplied on 2/28.
If you drill down on the Amount Remaining for either the payment or the invoice in GP you can see the Apply Date. Note this is the Document Apply Date, there is also a GL Apply Date - that is stored in tables and I don't think you can see it anywhere in the GP user interface. This is important because if you are printing your historical aged trial balance using the GL Posting Dates, it will use the GL Apply Dates.
You can change the apply dates when you're applying transactions and if they're already applied with an "incorrect" date you can unapply and re-apply with new dates.
<em>-Victoria</em>
This is very helpful and will start updating the apply dates to the same date as the payment received! Thank you, Victoria!
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 646 Most Valuable Professional
André Arnaud de Cal... 529 Super User 2025 Season 2
Sohaib Cheema 285 User Group Leader
