SAP Knowledge Base Article - Public

3809541 - GR/IR Inventories - Balance Summary shows Residual amount in 'Amount Awaiting invoice'

Symptom

A residual amount remains under Amount Awaiting Invoice in the GR/IR Inventories - Balance Summary report for a purchase order item XYZ-1, even though the inbound warehouse process has already been completed through the corresponding warehouse order and supplier inbound delivery.

(XYZ-1 represents the Purchase Order Item)

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Analytics work center.
  2. Open the report GR/IR Inventories - Balance Summary.
  3. Enter the relevant selection criteria:
      - Company
      - Set of Books
      - Purchasing Document
  4. Execute the report.
  5. Observe that an amount remains under Amount Awaiting Invoice for the purchase order item XYZ-1.

Cause

  • The purchase order XYZ was processed through the inbound warehouse process and the corresponding warehouse confirmation was posted.
  • After the goods receipt posting, the purchase order item XYZ-1 price was changed. To reflect this price change, the system created an adjustment warehouse confirmation for the same quantity.
  • Because the adjustment posting was created using the updated purchase order price, it did not completely offset the original goods receipt posting.
  • This resulted in a residual amount remaining on the purchase order item.
  • Furthermore, the purchase order remains 'In Process' and the Final Clearing indicator has not been set. Therefore, the system continues to assume that additional goods receipts or supplier invoices may still be expected and keeps the residual amount open in the GR/IR Inventories - Balance Summary report.

Resolution

If no additional goods receipts or supplier invoices are expected for the purchase order item, mark the item for Final Clearing and execute the GR/IR Clearing Run. Follow the below steps to perform the same,

  1. Navigate to the Inventory Valuation work center.
  2. Go to the Purchasing Document Items view.
  3. Select Purchasing Document Item XYZ-1.
  4. Highlight the line item and choose Final Clearing → Mark.
  5. Enter the appropriate Final Clearing Date (DD.MM.YYYY).
  6. After marking the item for final clearing, execute the GR/IR Clearing Run.

Once the GR/IR Clearing Run is completed successfully, the residual balance should be cleared and the corresponding entry should no longer appear in the GR/IR Inventory Balance Summary Report.

Keywords

gr/ir, grir, balance summary, amount awaiting invoice, residual balance, pending balance, purchasing document, goods receipt, supplier invoice, price change, adjustment confirmation, final clearing, gr/ir clearing run, inventory valuation, clearing residuals , KBA , SRD-FIN-INV , Inventory , Problem

Product

SAP Business ByDesign all versions