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




<< US - 7180 Royalties calculation >>



1. Objective and Scope

1.1. Objective of this Operation

Calculation for Royalties and Sales rebates performed manually by collecting sales data for period.


1.2. Scope

Composites Materials - Cytec Engineered Materials Inc., SAP company code 07180


2. Definitions


See Finance Glossary:

  • ...


3. Tasks description

Calculation for Royalties and Sales rebates performed manually by collecting sales data for period. Based on Sales data for period is calculated balance that should be paid to counterparty as per agreement.

3.1. Royalties

3.1.1. Data collection

Run KE30 - Solv00 in WP1 (make sure to run the data for both periods - the actual and the previous month as you will have to report the adjustment for the previous month)

KE30 - Operating concern: Z028

Select data for B00 - Period - Goto line items (F9)

Settings → Layout → Choose →  /7180 ROYALT

Download generated data to Excel file → List → Export → Spreadsheet


3.1.2. Calculation of monthly balance

Royalties calculation performed using Google spreadsheets, calculations stored in the folder

Create a new file every month and once it is done, make sure that formulas in tab "Calculation" are updated as per below:

Copy and paste as value the formulas for previous months in this table, tab Calculation:

Make sure you update the actual values in the fields highlighted in yellow below

Copy→ Paste values from column K to J (highlighted in green below):

Copy → Paste downloaded data from KE30 to Spreadsheet in sheet Data

Double check that net sales are correct (Total matches B00 Net sales from the print screen)

Update both pivot tables in the Total Sales sheet for necessary periods (actual month and previous month):

  • Select transactions w/o TP only (to exclude IC sales)
  • Make sure to select the right periods for both pivots
  • Double check tab Calculation - see if vlookup works properly

Update the YTD balance in Calculation tab

Send the calculation for approval to CAM Diann Shiver

After Approval from CAM received:  Update Royalties file for accrual posting


Accrual is posted by Intercompany team; Royalties invoice is issued 2 times per year (June and December)

Royalties amount calculation and Global file update must be performed no later that D-1 on monthly basis. For June and December Global file must be updated no later than D-2 in order to ensure timely Intercompany billing.


Check of monthly sales data by market

Sales amounts in KE30 - ZZZ-SOLVFCMT

  1. Add Trading Partner filer
  2. Select only 3rd parties (Not Assigned)
  3. Click on "Mountain" --> MAGNITUDE Market

Market view is ready now!

...


End of document.

 

  • No labels