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)

ZWFA12A;, ZWFA10A; MRN1; ZWFA21A; ZWFA23A; MRN0; ZWDV11


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

Inventory Impairment

posting scheme for inventory reserve

Hard-Close instruction for inventory reserve



Previous OP << >> Next OP



1. Objective and Scope

1.1. Objective of this Operation

WHY - Describe the objective of the operation

(complete)(error)

1.2. Scope

Detail the scope (legal entities, etc.)

(complete)(error)

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. Background (confirm this section)(error)



General Rules - Depreciation


3.2. Responsibilities


In WP1 perimeter, Finance Operations Team runs the transactions and prepares the Excel files with proposal of rotation and financial depreciation.


Controllers are responsible to analyze the posting proposal sent by Finance Operations Team and provide the final validation for the depreciation amounts to be posted, indicating the changes to be done to the original posting proposal. In some cases, an additional comment on the largest variances between depreciation proposed and validated is required.


3.3. I run inventory valuation reports














3.4. I calculate inventory reserves


The process is currently processed with the support of one excel template that needs to be updated with the extractions from te transaction (mention in section 3.3



Worksheet "Read Me" in the template:

  • The excel template contains a Read Me worksheet with the details of how to extract data and fill in each worksheet.
  • Some files, might contain one Excel Macro to extract automatically the data from SAP and fill in each worksheet.

Prepare Spare Parts data (3.3.1):

  1. Go to report Z1K_spareparts
  2. Select variant /SLOWTURN-SP
  3. Update the company code
  4. Update the year and month
  5. After running, extract to excel
  6. Copy to worksheet "SP reserves", starting cell A2

Prepare Raw Materials & Packaging data (3.3.2):

  1. Go to report Z1K_spareparts
  2. Select variant /SLOWTURN-RM
  3. Update the company code
  4. Update the year and month
  5. After running, extract to excel
  6. Copy to worksheet "RMPACK reserves", starting cell A2

Prepare Finished Goods Data (3.3.3):

  1. Got to SQ00
  2. Select query/user group SXS-PRD1
  3. Run table Z1K_UPIS3
  4. Select Variant "INV RESERVES" with the complany, plant (if necessary) and period/Year
  5. After running, extract to excel
  6. Copy to worksheet "FG reserves", starting cell A2


Select query/user group SXS-PRD1


Run table Z1K_UPIS3


Select Variant "INV RESERVES" with the complany, plant (if necessary) and period/Year

Worksheet "Summary" in the template:

  • There is a table to reconcile all stock of the company and retrieve the total amount of reserves posted Vs calculated
  • Find as well the rules and assumptions for the reserves calculated

Worksheet "Full stock extraction" :

  • Extract through BW, the stock of the company for the period in analysis
  1. Refresh this worksheet through Analysis/Prompt
  2. Select date (Last day of the month in analysis)
  3. Select the company code


Go to "prompt" to perform the refresh


Select the date and company

Worksheet "Reserve accounts" :

  1. Refresh this worksheet through Analysis/Prompt
  2. Select date (Last day of the month in analysis)
  3. Select the company code

Go to "prompt" to perform the refresh


Select the date and company






3.5. I send the report to the GBUs

3.5.1. I generate the proposition files









3.5.2. I prepare the proposition files



Take the file generated by ZWFA12A:

  1. Insert 5 columns between “Depreciation” and “Reference”;
  2. Rename the columns;
  3. Copy the amounts in column “Depreciation Proposed” to column “Depreciation Validated”;
  4. Insert the formula in column Difference Depreciation Proposed and Depreciation Validated 
    (Column L – Column M);
  5. Column “Comments if Difference > 5000€, should be filled by the responsible Controller when 
    applicable. 


 







3.5.3. I send the proposition files

After the file is completed, send the depreciation proposals to the controllers.

In the message clearly indicate the deadline, which should be D-5 at the latest and request the amount validated for Rotation and Financial Depreciation. 


End of document.