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

(to be confirmed!)(error)

Frequency

5. Remove the icon(s) when not applicable

 

 

 (to be filled!)(error)

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

Banco de México Portal



Previous OP << >> Next OP



1. Objective and Scope

1.1. Objective of this Operation

This procedure explains the carry out of the update and upload the Foreign Currencies for Mexico Companies using the information available in the Banco de México.

1.2. Scope

This procedure applies to Mexico Companies in PF1 ERP.


2. Definitions

See Finance Glossary:


3. Tasks description

For legal reason is necessary to update the system with the rates from Banco de México. The exchange rate defined in PF1 and WP1 cannot be used for Mexican Companies. 
This procedure describes:

  • How to get the exchange rate in the website of Banco de México

  • How to input the data in SAP - transaction ZRATE_UPLOAD

  • How to change the information if necessary - transaction ZRATEMOD

For Mexican companies have the only type of exchange rate to be managed. 

The exchanges rate LMXD should be updated in a daily should be performed every working day at 10 a.m. in Curitiba time, using the rate of the previous working day. 

These process is described in detail in the sections below. 

Obs.: If the exchange rate and/or the site is unavailable please, contact Victor Hernandez from Juarez (e-mail: victor.hernandez@solvay.com), Krystell Ardelete from Ciudad de México krystell.ardelete@solvay.com ) or Jose Armas (e-mail: jose.armas@solvay.com) in order to request the support and/or informing that the exchange rate will be update as soon as possible.

3.1. I update the exchange rate - daily

3.1.1. I retrieve the data

Go to Banco de México Portal.

If the link does not work, you must: 


  • The next screen should select the option "Tipos de cambio de otras divisas (dólar EUA, euro, yen japonês, libra esterlina) (diarios)".

The rate is retrieved for DOLLAR (USD); EURO (EUR); YUAN (CNY); CANADIAN DOLLAR (CAD) and JAPANESE YEN (JPY) in a daily basis. 

IMPORTANT: The date used to retrieve the correct exchange rate must be always the previous working day (for this reason the upload must be done at 10 a.m. Curitiba Time), for instance: 

    • 11/09/2015 – the day that must be retrieved the exchange rate;
    • 14/09/2015 – the day of the upload in SAP. 

Obs.: The daily exchange rate of Canadian Dolar (CAD) does not appear in the screen above, to get this information you should enter in the link Banco de México Portal and select again the option "MERCADO CAMBIARIO"


There you you'll find the information ready for the upload:

**The upload is done the same way as the other currency the only difference is where you extract the information.

3.1.2. I upload the exchange rate

3.1.2.1. PF1

Run the transaction ZRATEMOD (system PF1) in order to upload to SAP the Exchange Rate.
In the transaction insert the following information:

  • "Valid from" – the date that should be insert the rate
  • "From Currency" – the currency, for the Mexican companies must be updated 3 currencies:
    • USD
    • US$, this currency should be posted with the same exchange rate retrieving to USD
    • EUR

  • "Exch. Rate type" – the type of the rate to be modified
  • "Exchange Rate" – the exchange rate retrieving of Banco de México; 


Press enter.
The system will inform the actual rate. 
After that is necessary just to press  and  . The new rate will be assumed by the system: 


Repeat this process to US$ and EUR.

3.1.2.2. WP1

Run the transaction ZRATEMOD (system WP1) in order to upload to SAP the Exchange Rate. 
In the transaction insert the following information: 

  • "Valid from" – the date that should be insert the rate
  • "From Currency" – the currency, for the Mexican companies must be updated in 5 currencies:
    • USD
    • EUR
    • JPY (you need to multiply by 100 before upload in ZRATEMOD)
    • CNY
    • CAD
  • "Exch. Rate type" – the type of the rate to be modified
  • "Exchange Rate" – the exchange rate retrieving of Banco de México

 

Press enter.

The system will inform the actual rate. 
After that is necessary just to press  and  . The new rate will be assumed by the system: 

 


Repeat this process for EUR, CNY, JPY, CAD.


End of document.