Actual costing account determination error when indicator Revalue material is NOT checked

[robertmcgaffic]

if the indicator "Revalue material" in the post closing step of the actual costing run is checked, SAP will not revalue individual materials, but instead will post an accrual entry to an inventory account.

What is the transaction OYBC materials management material transaction that controls which inventory account is charged?

OBYC for SAP standard chart of accounts YCOA shows the following accounts for materials transaction BSD Inventory posting (sometimes also described as B/S reval - inv posting):

13100900 Inventory revaluation Raw material
13300900 Inventory revaluation Semi-finished goods
13400900 Inventory revaluation Finished goods

When we executed our costing run, we found that SAP DID NOT post to these accounts.
Rather SAP posted to account 13100000 Inventory raw material account, which is used for stock accounting (cost * quantity = amount)

Why did S4HANA not post to a revaluation account? Where is this determined in configuration?

According to further documentation,

Supplementary entry for stock (BSD)

This account is posted when closing entries are made for a cumulation run. This account is a supplementary account to the stock account; that is, the stock account is added to it to determine the stock value that was calculated via the cumulation. In the process, the various valuation areas (for example, commercial, tax), that are used in the balance sheet are taxed separately.

According to this explanation, BSD seems to be the correct materials transaction, but the Actual costing run is ignoring it and behaving as if the individual materials were revalued and adjusting the inventory stock account accordingly.

[sumesh_gupta]

Hello Robert, Please check below

1. It is strange that both LKW & BSX hitting - test once without selecting indicator & see if it hits only LKW.

2. I am very much concerned about making these postings because these inventory accounts will not equal the materials valuation found by multiplying each SKU by its price and aggregating the result. If the individual materials are not revalued, then I would expect SAP NOT to make a revaluation entry to the account used as the "control" account for individual materials. - Individual material is also reveluated once actual costing is done PUP is updated in material master & price control is chnaged from S to V.

3. In my mind, a better solution would have been to use a separate GL account in the above postings for inventories, so that the general ledger accounts would agree to the materials management reports on stock values. - If u need seprate GL them simply use LKW & do not select revalute material option.

Regards,

Sumesh Gupta

[sumesh_gupta]

Hello Robert,

If the Revaluate material checkbox is selected, then differences are posted to the inventory accounts (Maintained in transaction key BSX in OBYC), if this is not selected the differences are posted to accrual account maintained in transaction key LKW in OBYC.

BSD will not come into play in post closing of material ledger.

Regards,

Sumesh Gupta

[robertmcgaffic]

Sumesh,

Thank you for your clarification. But I am confused because we are getting both postings to the LWK account and the BSX accounts when the Revaluate material checkbox is NOT selected.

Here is an accounting entry that was created by SAP in our actual cost closing:

The 5203100 revaluation produced is cleared to zero by the above postings to inventory and PRY and LKW accounts.

Material transacton BSX is configured to use accounts 13300000 and 13400000 respectively for inventory of semi-finished and finished goods.

I am very much concerned about making these postings because these inventory accounts will not equal the materials valuation found by multiplying each SKU by its price and aggregating the result.

If the individual materials are not revalued, then I would expect SAP NOT to make a revaluation entry to the account used as the "control" account for individual materials.

In my mind, a better solution would have been to use a separate GL account in the above postings for inventories, so that the general ledger accounts would agree to the materials management reports on stock values.