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

SAP Knowledge Base Article - Public

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

Symptom

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

  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

Cause

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.

Resolution

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.

Keywords

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

Product

SAP BUSINESS BYDESIGN 1705 ; SAP BUSINESS BYDESIGN 1708

Attachments

Ordered_Qtd_HowTo.docx