Stock Ageing Analysis Using FIFO Calculation

Hi Daxer,

Thank you for your interest in assisting, I really appreciate it!  I do not have permission on the forum to upload file (not sure why Microsoft does not allow everyone to do this)

The model is fairly simple:

Lookup Tables:

Dates: simple date table with dates, months, years etc

Range: product range table with SKU and Product Name

Stores: store ID and Store Name

Fact Tables: 

Dispatches from DC:

SOH (note that this is the closing balance each day)

Sales:

Dispatches from DC

Finally, I have a table with the age buckets I would like to classify the SOH into:

The end result would look something like this:

I think the SQL query that matches my requirement the closest is http://www.kodyaz.com/sap-abap/stock-aging-using-sqlscript-on-sap-hana-database.aspx

Cheers, 

Phil