Dear Team,
We have created a Saved Search report for the Trade Receivable Register and are attempting to reconcile it with the AR Aging Detail report. However, the total amounts are not matching.
In some cases, if we select older dates or specific date ranges, the totals mismatch. But for other dates,like current date its match , there is a difference between the two reports.
Our Saved Search is based on the Amount Remaining field. In the AR Aging Detail report, we are seeing differences where some amounts appear under Total Amount and some under Amount Remaining.
Could you please help us understand:
- What could be causing the mismatch between the Saved Search and the AR Aging Detail report?
- Are there specific filters or criteria we should apply in the Saved Search to match the AR Aging report exactly?
- Does the AR Aging report calculate balances differently (for example, based on posting date, due date, or as-of date logic)?
Please let us know if you require screenshots or the Saved Search criteria for further review.
Thank you for your support.
Best regards,
