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

8. Add the link to attachments or external links



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 of each material, when changing month, in the Secretaria da Fazenda website and also update the registration of the material in SAP.

1.2. Scope

This document applies to companies 7523 and 7580.


2. Definitions

See Finance Glossary:


3. Tasks description

Reminder: log in SAP in Portuguese

3.1. I run the SAP transaction ZWPP40A (confirm title)(error)

Go to transaction ZWPP40A. Use the variant RES 13_XXXX (XXXX is the plant) execute for all plants.

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

Execute .


Always for the previous month.


Execute in background.

 


Use output Device LP01.

On transaction SM37 you can find the job status and its spool.

3.2. I run the SAP transaction ZWPP40B (confirm the title)(error)

Open transaction ZWPP40B.


Click in   to select each report that was defined in the previous transaction, as model:


Execute .


Select the option display in worksheet.

Then, go to tab RawData.



Then, go to tab RawData.



Insert the filter.


In the J 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.
  • Delete column A (Period/year) and D (Material Description).


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 from the cell B2.


Repeat this process for the other centers, pasting the information after the last line with values.

Complete the A2 field with the corresponding period.

 


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

3.3. I run the SAP transaction SQ00 (confirm the title)(error)

Go to transaction SQ00.

To get the material code, go to transaction SQ00 and change the Query areas para 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.4. I run the SAP transaction ZWOC30 (confirm the title)(error)

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.5. I collect the 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.6. 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 .


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


End of document.