3671140 - Incorrect Net Value in Delivery Reliability Report

In the Delivery Reliability Report (ID SRMPO_U02_Q0001), the net value for Purchase Order line items is greater or double the price in the Purchase Order.

1. Navigate to the Purchase Requests and Orders - Reports view.
2. Open the Delivery Reliability Report (ID SRMPO_U02_Q0001).
3. In the Selection section, insert the Purchase Order ID.
4. Select the view ABC in the view options.
5. Choose "Apply".
6. Observe that the net value of the line items is greater or double the price in the Purchase Order.

The Delivery Reliability Report is based on a combined data source that aggregates data from multiple basic data sources, including:

• Purchase Order Item with Goods and Service Receipts Item (SRMPO_B04)
• Purchase Order with Confirmed Inbound Delivery Items (SRMPO_B06)
• Purchase Order with Outbound Delivery Items (SRMPO_B07)
• Purchase Order Schedule Lines (SRMPO_B09)
  
  The net value in the report reflects the sum of net values of Purchase Order from these combined data sources.
  Example:
  
  if Purchase Order Line item 1 includes two inbound deliveries and one outbound delivery, sum of net value of Purchase Order from SRMPO_B09, SRMPO_B06 (twice due to two inbound deliveries), and SRMPO_B07.
  if net value of purchase order is 500, then the net value in Delivery Reliability Report will be,
   500(from SRMPO_B09) + 500 x 2 (from SRMPO_B06) +500 (SRMPO_B07) = 2000.
  
  
  

This is the Standard behavior in the Delivery Reliability Report.

delivery reliability report; net value; incorrect; purchase order report; SRMPO_U02_Q0001; line item value; inbound delivery; outbound delivery; purchase order schedule lines;
SRMPO_B09; SRMPO_B07; SRMPO_B06; SRMPO_B04  , KBA , SRD-SRM-ANA , Analytics Content , How To