In an earlier post we had a look at the inventory by item group aging report in AX2012. If you are working with AX7 then the report is available as well to use for your on-hand inventory analysis.
Here is a quick overview.
AX7 Build 7.0.4230.16130
Cheers
Lachlan