Symptom
You post invoices and receipts for a purchase order.
You later cancel some line items of the Purchase Order.
On running the GR/IR Inventories - Balance Summary report, those canceled line items are still showing under amount awaiting invoice/receipt even after the GR/IR Clearing.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Work Center: Inventory Valuation.
- Under Reports / List choose the report GR/IR Inventories - Balance Summary.
- Select the relevant parameters for your report creation including purchasing document XYZ (XYZ means the Purchasing Document Item).
Items which are canceled are showing as amount awaiting invoice / amount awaiting receipts.
Cause
Since the purchase order status still showing as partially delivered / invoiced and mark for final clearing was also not set for the canceled items, system is still assuming that goods/invoices are expected, so the same is being shown in the report.
Resolution
- Go to Inventory Valuation work center.
- Select Purchasing Document Items view.
- Select Purchasing Document Item XYZ.
- Select the canceled Purchasing Document Item line and Click Final Clearing -> Mark.
- Enter the Marked Final Clearing Date DD.MM.YYYY.
Since the previous GR/IR Clearing Run did not mark these canceled line items because it has not done any clearing for them, so you can manually mark these items and run the GR/IR Clearing Run. Upon completing the run, the entry in the report should be cleared.
Keywords
GR/IR Inventories - Balance Summary, Purchase Order, Mark for Final Clearing. , KBA , SRD-FIN-INV , Inventory , How To