Thanks for the comments.
Yes, the balance sheet, AR, and AP figures match when the same period is chosen and type “A”.
I meant to say the “aged” AR and AP, Oops!
Here is another example:
Say there is a $5000 invoice on a receivable account outstanding as of the end of March. The payment is received in April and reconciled in April.
When I print the aged AR report dated the end of March, in April, choosing “O” for open item, this $5000 disappears.
It’s correct that the report will only shows the outstanding items because “O” is chosen.
But I am printing the report for the period end of March, logically, this $5000 should still be included as open item in March cause the payment is not received until the following month, in April.
If I print the aged reporting choosing “L”, the balance is correct. But it is a waste of paper to print the report including all the history data.
Wonder if there is an alternative to printing the report to get the correct aged numbers without printing all the histories…