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

    • 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. 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 

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)


Forms

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


Attachments



Previous OP << >> Next OP



1. Objective and Scope

1.1. Objective of this Operation

The purpose of this document is to describe the way to calculate the percentage of imported raw materials in the production of each product.

Monthly calculation is made of the percentage of imported raw material in each product. These data is updated FCI (Ficha de Conteúdo da Importação) of each material, when changing month, in the Secretaria da Fazenda website and also updated the registration of the material in SAP.

1.2. Scope

This procedure applies to companies :

  • 7523 Rhodia Poliamida 

Plants: 7525, 7515, 8227, 8287

  • ZBR1 Rhodia Acetow

Plant: 8598

  • 6343 Techpolymers

Plant: 8631


2. Definitions

See Finance Glossary:


3. Tasks description


Reminder: log in SAP in Portuguese


3.1. I run SAP Transaction ZWPP_MCKOST 

Go to transaction ZWPP_MCKOST .

Use the variant RES 13 NEW and run for all plants, the report is done by company.

Obs.: Plants can be added or excluded of the scope according to Solvay’s business dynamics. 

Execute .

Always for the previous month.

After you run extract the report to Excel file, as model:

Insert the filter.

In the H column, enter a filter selecting only the items that are equal to 0.

  • Delete all rows that have a value of 0 (zero), then remove the filter.

For each of the columns A, B, C and D must do the following:

  • Select the column;
  • Scroll to Date and select the option text to Columns;


  • Click in Finish.

Paste in tab of support file Extração from the cell A2.

Note that in the column C contain formulas.

Repeat the same procedure for the other centers using the lower lines variants, remembering that should put the data one below the other.

After you run extract the report for all centers, go to the Data base tab in support file, and refresh the Pivot Table with the information of MCKOST tab:


The information in the Data base tab should be included in the support file XXXX Res13 - 1ª Parte (XXXX is the company code)  .

Past the information from the C2 cell in ZWPP_MCKOST tab, note that the Pivot Table not update the information in the correct order, the Actual Quantity Column must be before the Unit of Measure.

Complete the column A field with the corresponding period.

Check the column B if are pulling formula.

3.2. I run SAP Transaction SQ00 

Go to transaction SQ00.

To get the material code, go to transaction SQ00 and change the Query areas to Standard.



Click in  and change to ZW_BR_IM.



Select query ZWBR_100 and press "Process" .



Use variant Res 13.

Execute .

 

Select the option display in worksheet , in part higher of transaction.


Go to tab RawData.

Delete column H, I e J.


For each of the columns A, B and D must do the following:

  • Select the column;
  • Scroll to Date and select the option text to Columns;
  • Clique em Finish.



Copying from the line 2 to the last cell with information.


Paste in tab  of support file from the cell B2.

The formulas from the column I will be automatically completed after the insertion of the data.

3.3. I run SAP transaction ZWOC30

Go to transaction ZWOC30.

Variant  – SALES.



Execute .


Select the option display in worksheet , in part higher of transaction.


Go to tab RawData.

For each of the columns F, G e H must do the following:

  • Select the column;
  • Scroll to Date and select the option text to Columns;
  • Click em Finish.



Copying from the line 2 to the last cell with information.


Paste in file Vendas Resolução 13, located in the T:\MERCOSUR TEAM\RCS\Resolução 13\Vendas Resolução 13. After the last line with values. This file should be cumulative of the year. The columns in green will be filled automatically, if it occurs not drag down the formulas.


Save file.

Return o support file .

Obs.: The two files should be open to perform the refresh and observe the filters.

 

3.4. I collect data in tab COMEX

This information is provided by Adriano Pereira, with all imported products of the month, the data should be collected in tab. Go to the last cell with information and paste the data provided by Adriano, noting that the data should be cumulative of the year.


Check the columns BU:CC if are pulling formula.


Go in tab, after select Options and select the option Refresh.

3.5. I analyse the data

After all data are in file, order the column C, as picture. 

Tab ZWPB40A

 


1) Check the column J has #N/A, if any information you should filter.


Then should, copy the codes of components that are in column E and repeat again the process in SQ00, point 3.3., but use the variant RES 13 COMPLE.

Go back, and check if the column J is with values.


Remove the filter.


2) Go for the column U and filter the items:

    •  2 Foreign - acquired nationally.

At this moment you should analyze the J column, if any line has information # N / A, you should change there, leaving equal to column I; this mode correcting errors.

Remove the filter.


3) Filter the column H only the unit of measure LB and the column K only with M.

In cases where the cost is medium (M) have to multiply column J by 0,45359. 


4) Check the information in footer of worksheet.


You should check the indicated fields by the arrow , look that at column E (Components) of the two fields indicated have the same material.

In this case must  sum the two fields and leave the value in the product.

Obs.: The product will always be the index 1.


When you don’t have errors, The information of tab ZWPP40A, save to a new file, and send to FtO (change FtO)(error) (Eduardo Schubert and Karen Schwartz), every 20th of the month.


On file Support Resolution 13, on tab ZWPP40A, make a filter on column Q only for percentages higher than 70%.

Once the filter is done, analyze columns X and check if there is any amount higher than 1. 


If there is, take the component number on column E and go to Historic Import tab and search for the component on column D. On column I, divide the number by 1.000 in case the Unidade de Medida is on TON .


Ensure that there is no "N/A" formula error in any column on tab ZWPP40A.

End of document.