Scenario
Fully paid invoices are still appearing on the A/R Aging report.
Cause
The A/R Aging Summary report is designed to show only unpaid invoices and statement charges grouped by customer and billing period. However, if the report is run with an "As Of" date prior to the last applied Credit Memo or Payment, the invoice may still be considered open by the system, causing it to appear in the report.
Solution
To ensure fully paid invoices do not show on the A/R Aging report:
Step 1: Review the invoice in question and go to the Related Records subtab.
Step 2: Note the date of the last Payment or Credit Memo applied to the invoice.
Step 3: When running the A/R Aging Summary report, set the "As Of" date to a date after the last Payment or Credit Memo applied.
This ensures that the invoice is recognized as fully paid as of the report's date.
Conclusion
To avoid confusion on aging reports, always run the A/R Aging Summary report with an appropriate "As Of" date that reflects the most recent payment activity. Regular training and awareness of how these reports function will help maintain accuracy in your receivables data.
-----
If you find this information useful, let us know by reacting or commenting on this post!