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
- 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)
- Labels to be used: country_accounting, france, financial_accounting
- E.g. 1: WW Operation in Financial Accounting under domain "Central Finance Processes & Compliance":
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
Responsibility area:
Table of contents
Scope
ERP
Frequency
References
Forms
Attachments
<< UK - 7771 - FERRARI REBATE >>
1. Objective and Scope
1.1. Objective of this Operation
1.2. Scope
The procedure is applied to entity Cytec Engineered Materials Limited (UK WP1) (SAP code 7771).
2. Definitions
See Finance Glossary:
- ...
3. Tasks description
3.1. I extract the data from SAP
Transaction: KE24
Operation concern: Z006
Variant: FERRAR
Layout: /FERRA
Then I extract the data to Spreadsheet.
Open the download from SAP:
3.1. I extract the file from Drive
Download the sheet Blank from Drive to Excel so I can compile the data.
https://drive.google.com/drive/folders/1smevpLH_K6wvHEj19EUXKKQJfcec_r9m
When downloaded, I will copy the information from SAP to sheet KE24.
Paste using Special Paste (Values only).
Make sure that the formulas in columns T and U are applied to all the rows.
Filter on the column T only the "YES"
Here I copy all the data from column A to S and paste to sheet Calculations.
Then return to sheet KE24, clear the filter in the column T and Select all again.
Now filter the column U only with "YES" too.
Copy all the data from column A to S and paste to sheet Calculations.
Then return to sheet KE24, clear the filter in the column U and Select all again.
Return to sheet Calculation and make sure that the formulas in columns T, U and V are applied to all the rows.
When in column U I have a "YES", I don't need to change any formulas.
When in column U I have a N/A, I need to insert the column corresponding to "Ship-To Party", column I.
Calculate SUM:
And copy the result to sheet Summary.
Open the previous month file and update Excel Summary sheet with the amounts from previous months.
Note: Material&Customer - Do not change unless I receive some communication via e-mail. Always confirm requested modifications with Gerald Perrin or Anne Perazio.
3.3. I send an email with the compile data
In the end, send an email to info@aeroteam-to.it with the file.
...