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: Country Accounting

Responsibility area: N/A

Table of contents 


Scope


ERP


Frequency

 

 

References

KE30


Forms


Attachments

Novecare



Previous OP << US - D45 Cost Center Variances Report >> Next OP



1. Objective and Scope

1.1. Objective of this Operation

The aim of this procedure is to guide how to extract this information from KE30 and prepare the report. 

1.2. Scope

This procedure applies to company 7424 - Solvay USA Inc.


2. Definitions

See Finance Glossary:

3. Tasks description

Service Center needs to extract the report and upload it into the GDrive, also notify the Plant Controllers that it has been loaded for their comments.

Timing: Every D+3, at 8 am EST  (it should be done if all assessment cycles were run)

3.1. I extract the data

3.1.1. I enter transaction KE30

  • Go to transaction     KE30
  • Select the report     ZZZ-SOLV00 | Periods/Year



  • From period: Closure month
  • To period: Closure month
  • Enterprise: 
    ENTRP00020
    ENTRP00200
    ENTRP00201
    ENTRP00202
    ENTRP00203
    ENTRP00204
    ENTRP00205
    ENTRP00206

Run the Report.

3.1.2. I select D45

  • Select the line for value field D45, for column Period.


  • Then press F9, or Go to → line items
  • Exclude the zeroed lines.
  • Choose Layout /D45 NOV 



  • Go to : List → Export → Spreadsheet


  • A new excel tab will be opened. 
  • Copy the data starting from B2, and paste starting from B2 on tab "Detail by CC" on this report. 



  • P.S: Do not consider the last yellow line with the total.


  • On tab "Summary by CC", refresh the pivot table.


  • Make sure that the Total of the Value field (D45) is matching with the total in Pivot Table.

3.2. I prepare and upload the file into Google Drive

3.2.1. I enter the file

  • After everything is ok with tabs "Summary by CC" and "Detail by CC", please select both and create a copy of them in a new book.
  • Update the name of these tabs where YYYY is the fiscal year, and the MM is the month. 
  • Update the tab "Summary by CC" column A2 with the closure month.

  • Save this report as "YYYY-MM CC Variances Novecare " 
  • Go to CC V. D45 Novecare folder using the link below:
    D45 Novecare

3.2.2. I send the report

Share the spreadsheet with the CAM and the Controllers and put a brief description:

"Please add your comments to the D45 - CC Variances report."

End of document.