Hide If

group	confluence-users

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

Panel

bgColor	#F7F7F7
titleColor	#ffffff
borderWidth	1
borderStyle	none

Domain: Country Accounting

Panel

bgColor	#F7F7F7
borderWidth	1
borderStyle	none

Responsibility area: N/A

1. Objective and Scope

1.1. Objective of this Operation

This OP 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 operating procedure (OP) applies to Mexico Companies in PF1 and WP1 ERP.

2. Definitions

See Finance Glossary:

3. Tasks description

3.1. Exchange Rate

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 LOP procedure describes:

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

;

.
How to input the data in SAP - transaction: ZRATEMOD.
How to check if exchange rates are right -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

save the report image - transaction: OB08

4. Periodicity

For companies in Mexico, you only use the LMXD exchange rate, which must be performed every business day and holidays at 10:00 am Curitiba time, using the rate of the previous

working day.

business day and/or the current day.

For the monthly closing rate, it must be carried out every first business day of the current month, at the exchange rate of the last business day of the previous month.

These processes are

These process is

described in detail in the sections below.

Obs.: If

Info

title	Observation

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)

the CAM - Country Accounting Manager in order to request the support and/or informing that the exchange rate will be update as soon as possible.

3.2. Update Exchange Rate - Daily

Consult the Legal Entity Card to get the CAM contact → https://aodocs.altirnao.com/documentViewer.html?locale=en_US&aodocs-domain=solvay.com#Menu_listDoc/LibraryId_Q5Hs3LE6NToqZiQCO6/ViewId_QcC3s0D6T8yCWGaOst/Filter_%257B%2522QcBp9HW1FgQuDsIBPQ%2522:%2522QcBm9Fa000000ifULT%2522%257D

5. I UPDATE THE RATE - DAILY

5.1. I retrieve

3.2.1. Retrieving

the data

Go to Banco de México Portal.

If the link does not work, you must:

Go to Banco de México Portal ;
Select the option"MERCADO CAMBIARIO";

Image Removed

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

BANXICO and SIE - Mercado cambiario.

Info

title	IMPORTANT

Image Removed

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

in a daily basis

.

And for USD, load on the current day the rate of the previous day from the DOF column, or the current day from the "PARA PAGOS" column."

The

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.

Image Removed

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"

link SIE - Mercado cambiario.

BANXICO you get EUR, YPY, CNY from previous day

Image Added

SIE - Mercado cambiario you get CAD and USD (US$ it is the same Exchange rate form USD)

Pesos por Divisa - CAD from the previous day

Image Added

Tipos de Cambio Peso/Dólar → Más Informacíon

Image Added

Use the column "Para pagos" of the current day (is the same of "Publicacíon DOF form the previous day).

Image Added

Save these prints in the TAXAS DIARIAS worksheet.

5.2. PF1

5.2.1.I upload the exchange rate - Daily

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

Image Removed

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

3.2.2. Uploading the Exchange Rate

3.2.2.1. PF1

Run the transaction Run the transaction ZRATEMOD (system PF1) in order to upload to SAP the Exchange Rate.

In the transaction insert the following information:

"Valid
from
From" –
the date that should be insert the rate;
Enter the current day's exchange 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.

Image Removed
The rate is updated for the following currencies: CNY, EUR, JPY (Exchange rate X 100) , USD and US$.
"Exch. Rate type" – the type of rate to be modified: LMXD.
Yuan chino - CNY
Image Added

Press enter;
The system will inform the actual rate.
After that is necessary just to press Image Added and Image Added . The new rate will be assumed by the system:
Do the same process for CNY, EUR, JPY, USD, and US$.

5.2.2. I check the exchange rate - Daily
Access the transaction: ZRATE
In the transaction, insert the following information:
"DATE" – Enter the current day's exchange rate.
"From Currency" – The rate is updated for the following currencies: CNY, EUR, JPY, USD, and US$.
"To Currency" – The currency for Mexico is MXN
"Exch. Rate type" – the type of
the
rate to be modified
;
"Exchange Rate" – the exchange rate retrieving of Banco de México;
Image Removed
: LMXD.

And check that the rates are updated correctly.
Image Added

After verifying that the exchange rates are correct, access transaction OB08, save the report image and paste it into the TAXAS DIARIAS worksheet.
Access transaction OB08
Image Added

Click in SELECTION, BY CONTENTS:
Image Added

Select VALID FROM ( date of day) e EXCHANGE RATE TYPE (lmxd)
Image Added

When the rates appear, check if they are correct based on the print of the rates extracted from the link mentioned above, if everything is ok, give a PRINT.

Image Added

Save the report image, and paste it in the TAXAS DIARIAS spreadsheet.
Image Added

5.3. WP1
5.3.1I upload the exchange rate - Daily
Run the transaction ZRATEMOD (system WP1) in order to upload to SAP the Exchange Rate.
In the transaction insert the following information:
"Valid From" – Enter the current day's exchange rate.
"From Currency" – The rate is updated for the following currencies: CAD, CNY, EUR, JPY, USD.
"Exch. Rate type" – the type of rate to be modified: LMXD.
Image Added

Press enter;
The system will inform the actual rate.
After that is necessary just to press Image Added and Image Modified and Image Removed . The new rate will be assumed by the system:
Do the same process for CAD, CNY, EUR, JPY, USD.

5.3.2 I check the exchange rate - Daily
Access the transaction:
Image Removed
Repeat this process to US$ and EUR.
3.2.2.2. WP1
ZRATE
In the transaction, insert the following information:
"DATE" – Enter the current day's exchange rate.
"From Currency" – The rate is updated for the following currencies: CNY, EUR, JPY, USD, and US$.
"To Currency" – The currency for Mexico is MXN
"Exch. Rate type" – the type of rate to be modified: LMXD.

And check that the rates are updated correctly.
Image Added

After verifying that the exchange rates are correct, access transaction OB08, save the report image and paste it into the TAXAS DIARIAS worksheet.
Access transaction OB08
Image Added

Click in SELECTION, BY CONTENTS:
Image Added

Select VALID FROM ( date of day) e EXCHANGE RATE TYPE (lmxd)
Image Added

Appearing as rates, check if the rates quoted in the link above are correct, enter the CAD currency, click on line as template and copy (CTRL+Y) line as template, click on NEW ENTRIES and paste (CTRL) +C, changing the currency for which it is missing and enter its value. If everything is ok, give a PRINT.

Image Added

Save the report image, and paste it in the TAXAS DIARIAS spreadsheet.
Image Added

Info
title Observation
Exchange rate data for MX (Mexico) is fed daily into the spreadsheet: TAXAS DIARIAS. Below is a link to access a conference if necessary:

https://docs.google.com/spreadsheets/d/1u5lr_oJBYo_uaAwSQl-2nqS2dwV3pjrQ/edit#gid=1210826692

6. I UPDATE THE RATE - MONTHLY
6.1. I retrieve the data
The same way, go to SIE - Mercado cambiario and click in "Otras cotizaciones (mensual)".
Image Added

Then, in the column "Pesos por divisa" you may find the tax rate used to update the monthly rate.
Image Added

6.2. PF1
6.2.1. I upload the exchange rate - Monthly
Run the transaction ZRATEMOD (system PF1Run 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;Post the exchange rate for the last business day of the previous month on the first day of the current month.
"From Currency" –The rate is updated for the following currencies CHF; IDR; SGD.
"Exchange Rate Type" - LMXD.

Image Added

Press enter.
The system will inform the actual rate.
After that is necessary just to press Image Added and Image Added . The new rate will be assumed by the system:.
Do the same for: CHF, IDR, SGD.

6.2.2. I check the exchange rate - Monthly
Access the transaction: ZRATE
In the transaction, insert the following information:
"DATE" – Enter the date of the first of the month/or the first business day of the month.
"From Currency" – The rate is updated for the following currencies: CHF, IDR, SGD.
"To Currency" – The currency for Mexico is MXN – 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: LMXD.

Image Added
Do the same for: CHF, IDR, SGD

After verifying that the exchange rates are correct, access transaction OB08, save the report image and paste it into the MX - EXCHANGE RATE UPDATE MONTHLY 2022 worksheet.

Access transaction OB08
Image Added

Click in SELECTION, BY CONTENTS:
Image Added

Select VALID FROM:

Image Added

When the report appears, check if the rates are correct based on the print of the rates extracted from the link mentioned above. If everything is ok, give a PRINT.

Image Added

Selecionar com o CTRL+ na coluna ExRt+ From + To + Valid From.

Image Added

Enter the information the: exchange rate type: LMXD, fron currency:CHF; CNY, EUR, IDR; JPY, SGD;
"Exchange Rate" – the exchange rate retrieving of Banco de México;
US$, USD, to-currency: MXN and valid from: the date of the first of the month/or the first business day of the month.
Image Added

Image Added
After checking the rates, save the report image, and paste it into the MX - EXCHANGE RATE UPDATE MONTHLY 2022 worksheet.

6.3. WP1
6.3.1 I upload the exchange rate - Monthly

Run the transaction ZRATEMOD (system WP1) in order to upload to SAP the Exchange Rate.
In the transaction insert the following information:
"Valid from" – Post the exchange rate for the last business day of the previous month on the first day of the current month.
"From Currency" – The rate is updated for the following currencies: BRL, CLP, EUR, IDR, SGD.
"Exchange Rate Type" - LMXD.

Image Added

Image Added

Press enter.
Image Removed
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:.
Do the same for BRL, CLP, EUR, IDR, SGD.

6.3.2 I check the exchange rate - Monthly

Access the transaction:
Image Removed
Repeat this process for EUR, CNY, JPY, CAD.
ZRATE
In the transaction, insert the following information:
"DATE" – Enter the date of the first of the month.
"From Currency" – The rate is updated for the following currencies: BRL, CLP, EUR, IDR, SGD.
"To Currency" – The currency for Mexico is MXN
"Exch. Rate type" – the type of rate to be modified: LMXD.

Image Added
Do the same for: BRL, CLP, EUR, IDR, SGD.

After verifying that the exchange rates are correct, access transaction OB08, save the report image and paste it into the MX - EXCHANGE RATE UPDATE MONTHLY 2022 worksheet.

Access transaction OB08

Image Added

Click in SELECTION, BY CONTENTS:

Image Added

Select VALID FROM:

Image Added

When the report appears, check if the rates are correct based on the print of the rates extracted from the link mentioned above. If everything is ok, give a PRINT.

Image Added

Enter the information the: exchange rate type: LMXD, fron currency: BRL, CLP, EUR, IDR, SGD to-currency: MXN.

Image Added

Image Added

After checking the rates, save the report image, and paste it into theMX - EXCHANGE RATE UPDATE MONTHLY 2022 worksheet.

Info
Exchange rate data for MX (Mexico) is fed monthly into the spreadsheet: MX - EXCHANGE RATE UPDATE MONTHLY 2022. Below is a link to access a conference if necessary:
https://docs.google.com/spreadsheets/d/1fS9BaDnLbvZGjqRByn2rL6V4tF86R9oA/edit#gid=1122532321

End of document.