Stock Aging report in SAP Business One

Greetings,

I don't think this issue has been raised successfully on the forums (i checked, there's no real resolution at the moment).

The end user requires some form of stock aging that their auditors deem important but there's no such feature within SAP B1.

Their basic requirements would be:

Stock Code | Description | Date of Purchase | Current Month (qty) | 30-90 Days (qty) | 91-120 Days (qty) | 120 days and above (qty)

I'm wondering if this is even possible with the end user using multiple warehouses to stock their inventory, and some items are marked as serial items and others are marked as batch.

Any ideas?