2373070 - GR/IR Clearing Run: Purchase Price Difference Amount Is Not Fully Posted to Stock (Warehouse Inventory) G/L Account

• GR/IR Clearing run that finished with a Purchase Price Difference for a specific Purchasing Document Item is executed.
• While reviewing the postings made to the Offsetting Accounts, the expectation is that the full purchase price difference amount should be posted to a stock account (G/L Account Type Warehouse Inventory).
• Basically, in the Business Configuration activity Posting Control Profiles for Procurement Processes, the payment and price difference to the original expense account have been chosen to post.
• However, the amount was split among two Offsetting Accounts. Only part of the amount was posted to a stock account. The remaining part was posted to an account of type Differences, with no clear explanation for this behavior.

SAP Business ByDesign

1. Go to the Inventory Valuation work center.
2. Go to the Periodic Tasks > GR/IR Clearing view.
3. Search for and open the respective GR/IR Clearing run.
4. Go to the Processed Successfully tab.
5. Find the respective Purchasing Document Item (notice the Purchase Price Difference amount).

Under Details section, notice that Purchase Price Difference amount was split between the stock (Warehouse Inventory) account and another account of type Differences.

For example:

Purchase Price Difference amount: 1.000,00 GBP

Amount posted to stock account: 900,00 GBP

Amount posted to Differences account: 100,00 GBP

The answer to the split posting upon execution of GR/IR Clearing run is, there should be a partial stock coverage at the time of execution, which can be found by checking the Material Cost History of the material contained in the respective Purchasing Document Item. The material cost history has to be checked for the period/year that the Goods Receipt and Invoice Receipt Clearing run has been posted. Since there's a difference in the Resulting Inventory Quantity between the beginning of the period and the date the GR/IR Clearing was posted (e.g. quantity decreased), the system will post the purchase price difference proportionally considering this decreased quantity in stock.

Continuing the example given in previous section:

Period/Year: 010/2016

1. Inventory quantity in the beginning of the period: 1000 case
2. Goods Transfer: -100 case (Resulting Inventory Quantity: 900 case)
3. GR/IR Run is executed (clearing runs change only the inventory value, never the inventory quantity): Resulting Inventory Quantity is 900 case

At this moment the system compares initial quantity (1000) with quantity at the time of GR/IR (900) and then posts 900 to stock account and the difference (100) to the Differences account.

Remark: material has Perpetual Cost Method Moving Average.

System behaves as expected.

Help Documents:

Moving Average Cost Method

GR/IR Clearing Run – Price Differences with Moving Average Cost Method

purchase price difference; moving average; gr/ir clearing; warehouse inventory , KBA , SRD-FIN-INV , Inventory , How To