Inventory Aging Calculation Total Inventory and 0 to 30 days , 31 to 60 days 61 to 90 days .

[shri0025]

Hi  Team  Please help to me Inventory Aging  days   calculation.

I have Inventory  table   Product Group , Product Name wiase and date   QTY   i need  Total Inventory as on date  ,and Total Inventory aging  Days  like  as date total Invnetory 100    0 to 30 days   invnetory 40  31 to 60  invnetory 10  61 to 90 invnetory  20   91 to 120 invnetory 30  121 to 180 days   invnetory 0  180 + days invnetory 0  like this

Click download 

Inventory Sample data