Inventory age report

[Rachelhsu]

Hi,

Base on expert's suggestion

I combined data source including Inventory a ging and FININVU01,then get a new report

report.jpg

but there are some questions like:

1.what's the start date and end data? start date seems like the date I searched, It's not right ,it should be the warehouse changeable date?

2.the inventory age if over 180 days, the report will only show >180,not show exact days.

3.base on the introduction in help portal:https://help.sap.com/viewer/2754875d2d2a403f95e58a41a9c7d6de/2011/en-US/6ce37a5a47ce4e368c9bd1188fc4b21a.html

In ByDesign, we calculate inventory age based on FIFO:

For example the material MOA

there are 2 inventory age for MOA, days 3 with 18 kg and 53 days with 97 kg

moa-fifo.jpgdays-prove.jpg

• 100-100+100-100+100-1-1-1，1/11 to searching date (3/5) total 53 days
• 9+9，3/2 to searching date(3/5)total 3 days

Would any expert explain this for the example?

Thank you