Symptom
You processed two Confirmations FFF and GGG(FFF and GGG represent the ID of the Confirmation) for Production Lot DDD(DDD represents the ID of the production lot).
Confirmation FFF is the standard confirmation for raw material AAA(AAA represent the ID of the material).
Confirmation GGG is an adjustment confirmation for raw material AAA.
The quantity of the two confirmations is only different in positive and negative, and the absolute value is the same. For example, -25,846 ea and 25,846 ea.
Between these two confirmations, there is no other posting for raw material AAA.
But you find that the Capitalized Amount (posting amount) of the two confirmations are different.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Inventory Valuation work center.
- Go to Materials view.
- Search AAA.
- Click on View Cost History.
- For example, you see the following records. For positive and negative quantity 25,846 ea, Capitalized Amount are different.
Created On | Source Document ID | Business Transaction Type | Journal Entry ID | Posting Date | Capitalized Quantity | Capitalized Amount | Resulting Inventory Quantity | Resulting Inventory Value | Resulting Inventory Cost | Cost Unit |
DD.MM.YYYY 08:00:00 | EEE | BBB | DD.MM.YYYY |
|
55,769 ea
|
21,053,213 JPY
|
37,751 JPY
|
100 ea
|
||
DD.MM.YYYY 09:00:00 | FFF | Goods Issue for Production | CCC | DD.MM.YYYY | -25,846 ea |
-9,757,058 JPY
|
29,923 ea
|
11,296,155 JPY
|
37,751 JPY
|
100 ea
|
DD.MM.YYYY 10:00:00 | GGG | Goods Issue for Production | HHH | DD.MM.YYYY | 25,846 ea |
9,757,123 JPY
|
55,769 ea
|
21,053,278 JPY
|
37,751 JPY
|
100 ea
|
Cause
You have not cancelled the production confirmation FFF but instead created another production confirmation with negative quantity which is leading to the difference.
When you post the production confirmation FFF (Condition Satisfied: Inventory Quantity >=0, Capitalized Quantity <= 0, Inventory Quantity after posting > 0), the calculation formula used is: Capitalized Amount = ( Capitalized Quantity * Resulting Inventory Value ) / Resulting Inventory Quantity
In the above example, that is -9,757,058 JPY = (-25,846 ea * 21,053,213 JPY) / 55,769 ea
On adjustment confirmation scenario, it behaves as a new production confirmation GGG and does not supply the amount from the production confirmation FFF (Condition Satisfied: Inventory Quantity >0, Capitalized Quantity> 0). It will use a different calculation formula: Capitalized Amount = ( Capitalized Quantity * Inventory Cost ) / Cost Unit
That is 9,757,123 JPY = (25,846 ea * 37,751 JPY) / 100 ea
Resolution
To avoid difference, you have to reverse production confirmation FFF instead of processing adjustment confirmation GGG. On cancelling the production confirmation, the amount from the original production confirmation is supplied and equated directly to the Capitalized Amount in Inventory Cost History (Condition Satisfied: Inventory Quantity >0, Capitalized Quantity > 0).
- Go to Inventory Valuation work center.
- Go to Materials view.
- Search AAA.
- Click on View Cost History.
- Find production confirmation FFF and open it.
- Click on Edit.
- Click on Reverse Confirmation.
Keywords
Capitalized Amount, Quantity, Posting Amount , KBA , SRD-FIN-INV , Inventory , Problem