Debtor aging by Cost Centre
We have Business requirement for Debtor aging by CostCentre
Checking seeded reports, the Receivables Aging by General Ledger Account Report provide outstanding balances by Receivables account.
The cost centre segment is always default code for Dr Receivables accounting line where as business would like the cost centre from revenue accounting line lines
Similar to the Receivables Aging by General Ledger Account Report Business would like to report the aging information for Invoice Revenue Lines by cost centre segment.
Checking the data model AR payment schedules all table holds the outstanding balance AMOUNT_DUE_REMAINING at Invoice (CUSTOMER_TRX_ID) + TERMS_SEQUENCE_NUMBER(if it is split term invoice).