I have a need to age credit notes just like Invoices in both the AR and AP aged Trial Balance reports. The default report places all Credit notes as current regardless of the credit note dates. There is a need to aged the credit notes just like the invoices, in other words if an invoice is dated 09.04.2015 and I run the report dated 10.05.2015, the credit not should appear in the 30 day column not the current.

Has anyone done this, if so what is the secret?