Symptom
After posted a warehouse confirmation and expected that the value gets posted to the inventory G/L Account, but instead it is posting to Gain/ Loss from Purchase Valuation Differences that is maintained under Differences tab in the inventory sub-ledger.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to General Ledger work center.
- Go to Journal Entries view and Journal Entries subview.
- Apply the advanced filter options and select Journal Entry ID XYZ (XYZ means the Journal Entry ID) for the Source Document Type: Warehouse Confirmation of Journal Entry Type: Goods Receipt from Supplier and click View.
The journal entry of an affected document could look as follows:
Finished Product account Debit: 0.00
Unbilled Payables account Credit 100.00
Gain/Loss from Purchase Valuation Differences account Debit 100.00 (Tax will affect the exact amount)
Cause
For the material
- Maintained the material cost for instance as zero.
- Used the same material in the purchase order with gross price as not zero but as 1 Quantity with 100 as price each.
So, the system behavior is Price valuation differences occur when purchase order price doesn't match inventory cost price, resulting in a different value for the goods receipt
Material | Purchase order price | Inventory cost | Differences |
M1 | 100 | 0 | 100 |
Resolution
Since these differences are not resulting from Warehouse Confirmation (Goods and Service Receipt) and Invoice, Goods Receipt/Invoice Receipt Clearing will not make a "Differences" posting than just clearing Purchase in Transit and Unbilled payables account. Now you can follow the process of posting manual entries for material to transfer the balances from "Differences" account to Inventory account you select the journal entry type 087 – Manual Entry for Materials, in the new journal entry vouchers.
Hint: In the activity Editing Chart of Accounts there should not be any G/L Account posting block for the accounts in question.
To avoid the situation in the future you should maintain the cost in the material master data for the standard perpetual cost methods.
Note: If the posted journal entry amount from warehouse confirmation is different than expected, check change log for the purchase order.
Probably the cause could be the price has been changed, and the journal entry from warehouse confirmation was posted before the change.
See Also
Help document:
Keywords
differences; inventory; warehouse confirmation; goods and services receipt , KBA , SRD-FIN-GL , General Ledger , How To