AR - Balance & Overdue - 12 month view

[gleo_SRAM]

We are building a summary view of balances outstanding and amount overdues for each Month End date.

So Month End Balance for Jan - Feb - Mar - Apr - May..... Dec

And the same for Amount Overdue - Jan - Feb - Mar - Apr - May..... Dec

Currently the query keydate value is passed into SAP exits on Net Due Date and Clearing Date.

Am I correct in saying that we need to create three new Cust Exits for each month which pass the value of that month end from the Posting Date (Jan) to Net Due Date (Jan) & Clearing (Jan) and so on for each month,

It seems nuts but I cant see how else we could achieve this.

Thanks for your thoughts.

Gill