Receivables Aging by General Ledger Account Report

Summary:

We are developing a custom report to show us aging 13 buckets we are not able to reconcile it with the standard we are facing issues with credit memo refund provided and some credit memo jumping buckets is there any particular table we should be picking the data from for " unaccounted transaction"

and at what point does the data show up in the standard report for e.g. After a transaction is accounted or unaccounted is there any code available that is similar to standard because we are uncertain how the credit memos are applied when there is no reference to the receipt.