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

Inventory age report

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

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

Attachments

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