3677717 - Inventory Ageing Data Source Displaying Incorrect Original Document ID

• Inventory Ageing data source displays an incorrect "Original Document ID" for serialized product ABC (where ABC is a Serialized Product).
• The Original Document ID is shown as XXX instead of YYY (where XXX and YYY are Consignment Fill-up Outbound Delivery IDs).

SAP Business ByDesign

1. Go to Business Analytics Work Center.
2. Go to Design Data Sources view.
3. Search for Inventory Ageing for Pre-delivered Stock data source.
4. Choose Preview.
5. Enter Custodian as "DEF" and material as "GHI" (where DEF is custodian ID and GHI is material ID).
6. Choose Apply.
7. Select View.
8. Choose the '+' icon near Row Fields and enable Original Document ID field.
9. Observe that the Original Document ID is displayed as XXX (where XXX is Consignment Fill-up Outbound Delivery ID).

The logic behind Inventory Ageing for Pre-Delivered Stock is as follows,

1. The system considers the current pre-delivered stock available in the stock overview with the relevant custodian and material.
2. For eg. if the product GHI has quantity( 1 EA ) with relevant custodian DEF in consignment stock overview, it is considered as snapshot quantity.
3. Then system checks for the Outbound delivery with consignment fill up for the relevant custodian and material.
4. Go to Outbound deliveries view and filter using relevant material and custodian IDs, The Outbound Deliveries will be displayed.
5. Now system starts considering the Outbound delivery with consignment fill up in the Descending order of the business transaction date.
6. It means the recent one is picked first.
7. Then it starts reducing the snapshot quantity (1 EA) till it becomes zero for calculating the ageing of the stock.
8. If the first recent confirmation make snapshot quantity to zero then it shows the first Outbound delivery in the report.
9. Since XXX is the recent document id and it makes snapshot quantity to zero when reducing, system displays XXX as Original Document in the Datasource.

• The Inventory Ageing for Pre-delivered Stock Datasource and proposed logic is only applicable for Non-Serialized products.
• This is not recommended for Serialized products.
• If a Datasource is required for Serialized products, post it in Customer Influence Forum https://influence.sap.com/sap/ino/#/campaign/886.

KBA : KB0292106 - Inventory Ageing Data Source Functionality

inventory ageing, data source issue, serialized product, outbound delivery, original document id, consignment fill-up, snapshot quantity, descending order, ageing calculation, logic , KBA , AP-IP-INV , Inventory , How To