1644529 - Sum of ordered quantities in the Purchase Order History report

For the Ordered Quantity column in the Purchase Order History report, shows as results a sum figure equal to the average Ordered Quantity instead of the total sum ordered.

1. Go to Purchase Request and Orders WorkCenter
2. Go to the View Reports
3. Go to the View List
4. Open the report: Purchase Order History
5. Set these layout changes:

Move to the Rows View, these following characteristics:

• Purchase Order ID
• Purchase Order Status
• Purchase Order Item
• Document ID
• Document Type
• Document Item
• Supplier
  
  

In the very special customer’s use case, its really could make sense calculate the result as total (and not as average). Presumed that you only uses POs / PO-Items containing the same product and that only exactly one Inbound Delivery (CID) per item exists. But whenever you have more than one deliveries, the use is questionable.

For this and other reasons, the system is working as designed.

In order to achieve the sum of ordered quantities:

First option:

The user can launch the report Purchase Orders per Product in order to cover this requirement mentioned.

Second option:

The customer can creates a new key Figure for Ordered Quantity and use it in a new report, as copy from the Purchase Order History.
This involve basically three task to be performed from the customer side:

1. Create a new key figure for Ordered Quantity;
2. Create a new report as a copy, using the new key figure created;
3. Setup the report in order to show the new key figure instead of the old one;

Third Option:

  Export the current report: Purchase Order History to excel and use the AutoSum feature from excel.

KBA , AP-PRP , Purchase Request Processing , How To