Dear Experts,
I have problem in Customer Aging Report where those AR Invoices which are reconciled or closed by AR Credit Memo are still shown separately; for example
Customer Code Balance Due 0-30 31-60 61-90
C0001250 1,000 (1,250) 0 2,250
As AR Credit Memo of amount 1,250 has been reconciled with AR Invoices amount 2,250 so this should have been like:
C0001250 1,000 0 0 1,000
Regards,
Azeem