Tasks to be completed when documenting an operation (from creation to publication)

 1. Enter the Title of the operation / page

2. Add the following Labels : 

    • Scope of applicability: ww, country_accounting 

    • Country or group of countries (if applicable): belux, china, france, italy, lam, nam, uk_ie, bulgaria, dach, netherlands, iberia, poland, latvia, australia, india, japan, south_korea, thailand, singapore, new_zealand, emea_transversal, apac_transversal

    • Unit and Domain according to the List of labels to be used in the Finance Service Line space

      • E.g. 1: WW Operation in Financial Accounting under domain "Central Finance Processes & Compliance":
        • Labels to be used: ww, financial_accounting, central_fin_proc_compliance

      • E.g. 2: France Operation in Financial Accounting:
        • Labels to be used: country_accounting, france, financial_accounting
          (for country operations, the Domain is always country_accounting)


3. Fill in all fields as described above

4. Name the title of each section using OPD methodology naming convention - Infinitive verb without the “to”, mainly action verb...something) - " I do something..."

5. Once the description of the operation is completed, ensure it is approved and published by launching the SBS-Finance approval workflow 




Domain: Costing



Responsibility area: Supervise Inventory Valuation


Table of contents 

By default the table of contents displays Heading 1 & Heading 2 (other levels can be added)



Scope

3. Remove the icon when not applicable


ERP

4. Remove the icon(s) when not applicable


Frequency

5. Remove the icon(s) when not applicable


References

6. Add the link to SAP transaction(s) (when it exists)

ZWFA100A; KE30


Forms

7. Insert the links accordingly and change the link text with the OP nam



Attachments

8. Add the link to attachments or external links




Previous OP << >> Next OP



1. Objective and Scope

1.1. Objective of this Operation

The purpose of this document is to explain how the Inventory Revaluation Reverse program will work for December closing.



December Closing:


As a regular rule, the ZWFA100A transaction is executed monthly.


At the end of the year, however, standard cost is impacted not only by master data changes, but also by the changes in fixed cost / depreciation activity type price for the New Year (updating of expenses in cost centers and their production capacity). These changes are year specific. 


Although, the program will run as usual at December closing but the postings performed will be different from a regular month:


Only the amounts related to VC (Variable Cost) Inventory Reval will be reversed in January P&L and backposted to December (D50 in KE30). 
The Reval of FC (Fixed Cost) and Dep (Depreciation) should remain in January (E50 and F50 in KE30).

1.2. Scope

Detail the scope (legal entities, etc.)

This procedure is applicable to all WP1 companies.


This Procedure is not applicable to WP1 companies using Material Ledger (Brazilianand Korean companies).

2. Definitions

Definitions should be added in the Finance Glossary - Add definition and link it to respective Letter in Finance Glossary 

See Finance Glossary:


3. Tasks description

3.1. Periodicity


December closing D2.

3.2. I run the inventory valuation reverse in test mode









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.












You can look for an existing variant by clicking on 

Select the variant and 

Enter the period to be reversed: When you enter 01/2016, the revaluation of stock on 01.01.2016 will be reversed & posted on 31.12.2015.

Execute 













The inventory valuation reverse is displayed.

Extract the report and perform the totals by VC/CP, FC/CNP and DEP/AMO.

Remember that only the amounts of VC will be posted in December (D50).

If it is confirmed that the sum of VC of the excel file retrieved is equal to the amount proposed for the posting, the transaction ZWFA100A can be executed in real mode. 






3.3. I control the result of the calculation (Once the transaction ZWFA100A is executed in real mode)









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


Run Profitability Report: initial screen












Enter

  1. Reporting Currency = 10

  2. Fiscal year (year that we are closing - 2015 for example)

  3. Company Code

  4. Select "Classic drilldown report"

 Execute 







If you have a warning message, click 











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

REMARK: Enter in the line items of the value field "D50" and make the sum or filter by the date of the posting in column "Created on".

You will find the amount on the date that you perform the posting (entry date in the system).











Enter

  1. Reporting Currency = 10

  2. Fiscal year (following year - 2016 for example)

  3. Company Code

  4. Select "Classic drilldown report"

 Execute 







If you have a warning message, click 


 




Check the amounts in the following value fields in January, that should be the same as the results of the transaction ZWFA100A. 

  • D52 -> Shows the reverse of Total costs (VC + FC + DEP)
  • D50 -> Shows the Total costs (VC + FC + DEP)
  • E50 -> Shows the FC
  • F50 -> Shows the DEP



 




The next section will explain how to to run and post Inventory valuation reverse, in case of the system is not working properly (fails).




The file downloaded is sent to the Plant Controller. Please see the example (file SBS-FRM-DRTR-03-011 – Stock Revaluation December 2011 by January.xls) of Inventory Valuation extraction file in December 2011/January 2012.

The file is used to prepare the manual postings. Only the amounts related to VC Inventory Reval will be reversed in January P&L and posted in December. The Reval of FC and Dep should remain in January.   


The amount in line D52 in January will be split into VC, FC and DEP. To perform the reclassification entries the recommended solution is to use directly the FI Accounts that impact both FI and COPA (without the need for a cost center):

  • 98154199 VC ADJUSTEMENTS - COPA- impact line D45 (Posted in December and Reversed in January next year). Reversal of E45 and F45 postings in January are also done in this line.
  • 98254199 FC ADJUSTEMENTS - COPA- impact line E45 (Posted in January next year, counterpart in line D45)
  • 98258199 FC DEPRECIATION – COPA- impact line F45 (Posted in January next year, counterpart in line D45) 

Find the Excel files with the data matrix provided to prepare the posting at the Appendix Section in the Appendix (file SBS-FRM-DRTR-03-012 – Posting Data FI-COPA .xls for COPA fields and file SBS-FRM-DRTR-03-013 – Inventory Valuation Decembre – CDC for GBU.xls for cost centers). 

For the posting in December, use account 98154199 VC ADJUSTEMENTS - COPA for such entries with counterpart in Stocks Accounts 31000109 (Raw Materials) and / or 37000109(Finished Goods, Semi-finished and Trading).

Each GBU has a Cost center for Inventory Valuation so this would be the privileged solution. But to this end, it also remains the possibility of using the cost centers used in previous years. See attached Excel file at the Appendix Section.



End of document.