You are looking for a data source that shows data related to Inventory Ageing and it seems that the available one, Inventory Ageing (SCMINVAGV01) is showing incorrect data.
This report is based on assumption that the materials which came in first are consumed first i.e. inventory net off will happen based on FIFO approach.
Currently, there is a “Confirmation Journal Report” already available which gives details of the incoming/outgoing dates for stock items. The inventory Ageing Report is going to make use of this report to calculate the time elapsed in days since the time of incoming entry in the Confirmation Journal till the “TO DATE” of the report. Please check the attached screenshot which explains the report logic.
This report is based on following assumptions and this report will be helpful for the customer only if they use FIFO Logic.
1. This report is based on assumption that the materials which came I first are consumed first, i.e. inventory net off will happen based on FIFO approach
2.This report will give inventory age at site level. It will not calculate age on logistics area level.
3.It calculates age of stock from the moment it comes in a site. It disregards inventory age in source site.
Please check with the customer whether they are using FIFO logic or not . If they are not using FIFO logic then the age displayed will be wrong.
This report uses the following parameters. Please, to provide the following parameters to the report selection:
1. End Date: Date in past from which Inventory Age has to be calculated.
2. Start Date : Latest date on which Inventory Age is needed.
3. Site: Site on which inventory age is needed. This report runs on site level.
Also we have following limitations in this report:
1. Stock Transfer Scenario: When a stock transfer happens, an inbound confirmation will be created at receiving site. Since our report is based on confirmations, age of transferred stock in new site will be calculated, based on new confirmation. It does not take into consideration, age of inventory in source site.
2. Physical Inventory Adjustment: In case of annual or periodic inventory count, if inventory records don’t match with actual count, inventory adjustment is done. The point here is regarding what age to assign to delta inventory.
3. In case of excess actual inventory than in records, increased inventory will be considered to belong to latest period i.e. it will be considered as part of latest confirmation.
In case of lesser actual inventory than in records, missing inventory would be considered to belong to earliest period, i.e. it will be considered as part of earliest confirmation.
Scrap Scenario: Any stock scrap would result in reduction of inventory and this would have to be adjusted in the Inventory count.
KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To