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

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.

 SAP Business ByDesign

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.

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.

System is working as expected.

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 invoiced , total quantity received , quantity awaiting receipt , quantity awaiting invoice , SRD-FIN-ANA , Analytics Content , How To