2238548 - Inventory Cost for Material Valuated by Moving Average Cost Method Dropped Too Low

SAP Knowledge Base Article - Public

2238548 - Inventory Cost for Material Valuated by Moving Average Cost Method Dropped Too Low

Symptom

You have maintained the Perpetual Cost Method Moving Average for an externally procured material.

You purchase this material always for the same price of X,XX LC (X,XX represents the purchase price, LC stands for Local Currency).
The same cash discount of Y% (Y represents the percentage amount) was applied for the respective payments.

You expect that the inventory cost would never drop under the purchase price minus the cash discount: X,XX LC - Y %= lowest inventory cost.

Yet, you notice that the Goods Receipt/Invoice Receipt Clearing (GR/IR) run has caused the inventory cost to drop lower than this expected amount in period MMM.YYYY (MMM.YYYY represents the accounting period).

Environment

SAP Business ByDesign

Reproducing the Issue

  1. In the Inventory Valuation work center navigate to the Master Data view and here to the Materials subview.
  2. In the Find field type in the material ID and press Go.
  3. Select the respective material - business residence combination.
  4. Press View Cost History.
  5. Navigate to the respective period MMM.YYYY.
  6. You notice that the Business Transaction of type Goods Receipt/ Invoice Receipt Clearing caused the inventory cost to drop lower than the material purchase price minus the applied cash discount.

Cause

In general, the inventory cost of an externally procured material with the moving average cost method is being updated either by Goods Receipts from Supplier or by the GR/IR clearing run considering purchase order-related processes of goods receipt and invoice receipt.

For the GR/IR run ONLY the proportional variation still covered by the inventory quantity is calculated for the inventory.

This is intended to guarantee that the inventory cost is correct. The remainder of the variances are included in the price differences, meaning they are being directly posted to the profit and loss accounts defined for price differences.

This becomes significant when the GR/IR clearing run has to consider numerous clearings of goods receipts and invoice receipts for which price differences have been detected. For each clearing the GR/IR clearing run considers the existing stock on the day of the run.

This means that the value of this same stock is being repeatedly reduced causing the inventory cost to drop much lower than expected.

The GR/IR clearing run has not only an affect on the postings of the selected period but also on the values that were posted after this period. This way the inventory cost can drop even more.

Resolution

It is recommended to post consumptions which reduce the inventory quantity only after the GR/IR clearing run.

It should also be ensured that repeated clearings should not be performed on the same inventory quantity as this can result in a highly reduced inventory cost but also a highly inflated inventory cost (in case of positive price differences detected by the GR/IR clearing run).

This is, however, not always feasible. Then it is possible to exclude certain price differences from being capitalized on the material inventory cost:

  1. In the Business Configuration workcenter navigate to the Implementaion Projects view and open the Activity List.
  2. Open the Fine-Tune phase.
  3. Find the Generally Accepted Accounting Principles activity and open it (If your system is live you can find this activity in the Overview view of the Business Configuration workcenter. Press Change immediately to open and edit it).
  4. Press on the Posting Control Profiles for Procurement Processes link.
  5. In order to edit the settings you need to add a new Posting Control Profile by cpoying the existing profile: Press Copy.
  6. Enter a profile ID starting with Z and an approriate description.
  7. Navigate to the Procure to Stock tab.
  8. Here you can deselect all the price differeences which shall not be capitalized anymore on the inventory cost, e.g. 1- Cash Discount.
  9. Press Save and Close.
  10. Now click on on the Generally Accepted Accounting Principles link.
  11. Select your newly created Posting Control Profile for all the relevant Accounting Principles.
  12. Press Save and Close.

The price differences between goods receipt value and invoice receipt value will have to be manually posted on the respective balance sheet accounts at the end of the accounting period.

See Also

2621145- GR/IR Clearing is Posting to Purchase Price Difference Account

1911776- Using the moving average cost for material valuation

Keywords

KBA , LOD-CRM-EMP , Employee , How To

Product

SAP Business ByDesign all versions