Symptom
- You create a purchase order for material XXX (where XXX stands for the material ID).
- The full quantity is being delivered as well as invoiced.
- You mark the relevant purchase order item for final clearing.
- However, after this you create a return to supplier for a part of the delivered quantity.
- Finally, you execute the GR/IR clearing run.
- This results in an increase of the material inventory cost as you notice in the Valuation history.
Environment
SAP Business ByDesign
Reproducing the Issue
-
Go to the Inventory Valuation Work Center.
- Select the Master Data View.
- Select Materials.
- Use the search option all materials and enter the material XXX.
- Click on View Cost History.
You see that the GR/IR run realizes the amount for the material even though no changes to the pricing or amount are expected.
Cause
-
As the Purchase Order item has been marked for final clearing the system does not expect any further deliveries for this purchase order item.
- If the Purchase order item is not marked for final clearing, the quantity difference is identified and no postings are made because further deliveries are expected.
- The GR/IR clearing run identifies the quantity difference due to the supplier return as final and realizes it on the material ledger
- This means it adds the difference amount to the total inventory value and changes the inventory cost amount (increase/decrease).
Resolution
To reverse the final difference posting, you can change the final clearing date of the Purchase order item to a date after any postings on the respective material.
Afterwards execute the GR/IR clearing run again for the period in which the difference is posted.
This creates another posting offsetting the previous difference posting. As a result the inventory cost of the material is reduced/increased:
-
Go to the Inventory Valuation Work Center.
- Select the Master Data View.
- Select Materials.
- Use the search option all materials and enter the material XXX.
- Access the purchase order items view and find purchase order YYY (where YYY stands for the purchase order).
- Press on Final Clearing and select mark.
- Set the date (note the system defaults to today's date).
- Press ok.
Now execute the GR/IR clearing run for the material and the period again. The difference amount is posted back.
- Go to the Inventory Valuation Work Center.
- Under Periodic Tasks choose GR/IR Clearing.
- Under new choose GR/IR Clearing Run.
- Enter a run description.
- Unmark the box for test run.
- Select the company and set of books.
- Enter the purchasing document ID.
- Enter the relevant period and year.
- Execute the run.
Now go back to the material and check the inventory cost.
Keywords
GR/IR run, moving average, gleitender Durchschnitt, WE/RE Lauf, inventory, Bestandspreis, Warenbestand, Retoure, return, final clearing, invoice, Rechnung , KBA , SRD-FIN-INV , Inventory , Problem