2625555 - GR/IR Run Increases the Inventory Cost of Material even though there were no Postings in the period

SAP Knowledge Base Article - Public

2625555 - GR/IR Run Increases the Inventory Cost of Material even though there were no Postings in the period

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

  1. Go to the Inventory Valuation Work Center.
  2. Select the Master Data View.
  3. Select Materials.
  4. Use the search option all materials and enter the material XXX.
  5. 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:

  1. Go to the Inventory Valuation Work Center.
  2. Select the Master Data View.
  3. Select Materials.
  4. Use the search option all materials and enter the material XXX.
  5. Access the purchase order items view and find purchase order YYY (where YYY stands for the purchase order).
  6. Press on Final Clearing and select mark.
  7. Set the date (note the system defaults to today's date).
  8. Press ok.

Now execute the GR/IR clearing run for the material and the period again. The difference amount is posted back.

  1. Go to the Inventory Valuation Work Center.
  2. Under Periodic Tasks choose GR/IR Clearing.
  3. Under new choose GR/IR Clearing Run.
  4. Enter a run description.
  5. Unmark the box for test run.
  6. Select the company and set of books.
  7. Enter the purchasing document ID.
  8. Enter the relevant period and year.
  9. 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

Product

SAP BUSINESS BYDESIGN 1802 ; SAP Business ByDesign 1805