Skip to Content
Mar 05, 2021 at 08:17 AM

Inventory age report

50 Views Last edit Mar 06, 2021 at 02:49 AM 2 rev


Base on expert's suggestion

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


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:

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


  • 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


moa-fifo.jpg (161.9 kB)
days-prove.jpg (68.1 kB)
report.jpg (266.1 kB)