SAP Knowledge Base Article - Public

3049955 - Report GR/IR Inventories - Balance Summary Key Figures Total of Quantity Awaiting Invoice and Quantity Awaiting Invoice not as Expected

Symptom

When checking the Report GR/IR Inventories - Balance Summary you noted that the Amounts of Total of Quantity Awaiting Invoice and Quantity Awaiting Invoice are not as expected.

Environment

 SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Analytics work center.
  2. Go to the Design Reports view.
  3. Click Report GR/IR Inventories - Balance Summary.
  4. Add Selection (Company, Set of Books, Key date and relevant Purchase Order).

When adding the Total Quantity Invoiced and Total Quantity Received you have a remainder, for example:

Total Quantity Invoiced: 2000

Total Quantity Received: -1900

The expected is a -100 in Quantity Awaiting Receipt, however it shows -110 in Quantity Awaiting Receipt and -10 at Quantity Awaiting Invoice.

Cause

This happens because the Key Figure is not calculated by each Total, the system adds the information from all Journal Entries for each Key Figure separately.

For example:

Journal Entry XXX - Total Quantity Invoiced 1000 - Total Quantity Received -890 - Quantity Awaiting Receipt -110

Journal Entry YYY - Total Quantity Invoiced 1000 - Total Quantity Received -1010 - Quantity Awaiting Invoice -10

Hence the Report will show for the Purchase Order as follows:

Total Quantity Invoiced: 2000

Total Quantity Received:-1900

Quantity Awaiting Receipt: -110

Quantity Awaiting Invoice: -10

XXX and YYY represent a Journal Entry ID.

Resolution

System is working as expected.

Keywords

GR/IR Inventories - Balance Summary, Total Quantity Invoiced, Total Quantity Received, Quantity Awaiting Receipt, Quantity Awaiting Invoice , KBA , gr/ir inventories - balance summary , total quantity received , total quantity invoiced , quantity awaiting receipt , quantity awaiting invoice , SRD-FIN-ANA , Analytics Content , How To

Product

SAP Business ByDesign all versions