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.
Reproducing the Issue
- Go to Purchase Request and Orders WorkCenter
- Go to the View Reports
- Go to the View List
- Open the report: Purchase Order History
- 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
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:
The user can launch the report Purchase Orders per Product in order to cover this requirement mentioned.
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:
- Create a new key figure for Ordered Quantity;
- Create a new report as a copy, using the new key figure created;
- Setup the report in order to show the new key figure instead of the old one;
Export the current report: Purchase Order History to excel and use the AutoSum feature from excel.
KBA , AP-PRP , Purchase Request Processing , How To