See different possibilities for this transaction:


STEP 1

Start the transaction KE30 (make sure you are in the right controlling area) and select the report 


Run Profitability Report: initial screen



STEP 2

Enter

  1. Reporting Currency = 10

  2. Fiscal year

  3. Company Code

  4. Select "Classic drilldown report"

 Execute 

If you have a warning message, click 



STEP 3

Check the amount in in the value field D52 that should be the same as the result of the transaction ZWFA100A. 

If it is confirmed, the transaction ZWFA100A can be executed in real mode. 



STEP 4

Once the transaction ZWFA100A is executed in real mode

In M, D50 shows both the full reversal of current month revaluation to previous month and the posting this month of the Variable Cost portion of next month’s revaluation.

NOTE: To have the correct amount of the Variable Cost, you will have to open the line items and select what was posted by the program.

In M, E50 / F50 show only Fixed Cost / Depreciation portion of next month’s revaluation.

As a rule, in M+1 the reverse D50 is the exact absolute value of D52. Some aggregate differences may occur, however:

  • Individual revaluation due to individual CK11N costing runs
  • Costing run reversals;
  • Lack of standard cost for the material in one of the periods;
  • Other manual postings in D50 line.


By principle we can make this check directly in KE30 because there are no additional postings in Value Fields D50+E50+F50 and D52.

Anyway, if there are differences between these Value Fields, it needs to be analyzed in KE24 if there are additional postings.




D50+E50+F50 vs D50 only

As you can see above, by principle, we can say that D52(M+1) = D50(M)+E50(M)+F50(M)

Although, using the concept of Semi-standard cost, the normal is to have the variation mainly in variable costs (CV), which is posted in VV D50.
If there was NO price change in activities such as MACHI, AMO and MANH neither in the quantities used, it is normal to have "0" in value fields VVE50 (CF) and VVF50 (DEP).



Non Processed documents by ZWFA100A

In case you have an error in transaction ZWFA100A and there is documents not processed by transaction.


After process transaction ZWFA100A, if you have the error below, please proceed as follows:

STEP 1

On Month M, post a FI Document (Ref. 1000009578) and reverse on the following month M+1

This posting will also impact COPA (98351010 account) in value field D52.

Please use the correct accounts, according with the type of material:

Posting KeyG/L accountDescription

40

37000109FINISHED PRODUCT ADJ
5098153010PROD STK VAR.
4037000209TRADED ADJ
5098153971VAR.ST GOOD STD
4031000109RM STOCK ADJ
5098153972VC-VAR.ST RM STD
4037000409INTERNMEDIATES ADJ
5098153110STK VAR. ST.SET


STEP 2

On Month M, post a COPA manual correction, to change the value field from D52 (step 1) to D50. 

    


Please note in this case, the amount was totally consider as VC and therefore, only posted in value field D50.

STEP 2.1

If the costs of the material needs to split into VC+FC+DEP, we need to post in value fields D50+E50+F50.

To check this split, go to CK13N at Month M+1,and see the amounts related to VC, FC and DEP:


STEP 3

On Month M+1, cancel D52 and move to D50 using the original posting as reference (in COPA only)



ZWFA100A is a transaction executed at company code level which:

  • Anticipates the revaluation from the new month to the closing month, using manual P&L and inventory adjustment accounts (two postings, one reverting the revaluation on the new month and the other posting it in the previous [closing] month), registering this in KE30 report ZZZ-SOLV04 line D50 (the original posting made by CK40N in the new month is done in line D52);
  • Splits the revaluation into VC, FC, Depreciation (using lines D50, E50, F50 in KE30 report ZZZ-SOLV04), in the closing month.
  • All postings at plant / material level, impacting their respective profit centers (and as a consequence their IECRA).

 Closing period inventory is revaluated at updated standard cost, and the P&L gets accurate contribution, gross margin and EBITDA figures.



STEP 1

Start the transaction ZWFA100A


Inventory valuation reverse: initial screen

The transaction can be launched in test as many times as required, to check the proposal before actual processing.



STEP 2

You can look for an existing variant by clicking on 

Select the variant and 

Enter the period to be reversed: When you enter 07/2015, the revaluation of stock on 01.07.2015 will be reversed & posted on 30.06.2015.

Execute 



If you don't have the variant you can make the selection : 

  1. Company code on which the reverse has to be applied

  2. Period to be reversed: When you enter 07/2015, the revaluation of stock on 01.07.2015 will be reversed & posted on 30.06.2015

  3. Valuation class in test mode only, the valuation class can be selected. In real mode, it is not necessary. All Revaluation doc. are treated.

  4. Document Type of the original Revaluation doc to be reversed (PR : issued from Costing run)

  5. Reference object: 0

  6. Costing type: 01 - Standard cost est.

  7. Costing version: 1 (same as the one of Costing run)

  8. Valuation variant: issued from Costing Run

  9. Document type: used in the postings periods M & M+1

 Execute 



STEP 3

The inventory valuation reverse is displayed

You can find the details of the report in this file Details of ZWFA100A Output Screens