20
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 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>
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (