3677717 - Inventory ageing data source displaying incorrect original document id for serialized product

• 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 Documents).

SAP Business ByDesign

1. Navigate to Business Analytics WorkCenter.
2. Go to Design Datasources view.
3. Search for Inventory Ageing for Pre-delivered Stock data source.
4. Click Preview.
5. Enter Custodian as "DEF" and material as "GHI" (where DEF is custodian id and GHI is material id).
6. Click apply and enable all row fields.
7. Observe that the Original Document ID is displayed as XXX (where XXX is Consignment Fill-up Outbound Delivery Document).

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

• The system considers the current pre-delivered stock available in the stock overview with the relevant custodian and material.
  
  
• For eg. if the product GHI has quantity( 1 EA ) with relevant custodian DEF in consignment stock overview, it will be considered as snapshot quantity. 
  
  
• Then system checks for the Outbound delivery with consignment fill up for the relevant custodian and material.
  
  
• Go to Outbound deliveries view and filter using relevant material and custodian. The Outbound Deliveries will be displayed.
  
  
• Now system will start considering the Outbound delivery with consignment fill up in the Descending order of the business transaction date.
  
  
• It means the recent one is picked first.
  
  
• Then it starts reducing the snapshot quantity (1 EA) till it becomes zero for calculating the ageing of the stock.
  
  
• If the first recent confirmation make snapshot quantity to zero then it will show the first Outbound delivery in the report.
  
  
• 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.
• For serialized products this logic will not work correct.
• Therefore system provides incorrect original document in Datasource. 
• Since there is no available report for serialized product, the requirement should be posted in Customer Influence Forum. https://influence.sap.com/sap/ino/#/campaign/886.

Refer to: 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