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 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 and WP1 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.
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: ZRATEMOD.
How to check if exchange rates are right -transaction : ZRATE
How to 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 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 described in detail in the sections below.

Info

title	Observation

If the exchange rate and/or the site is unavailable please, contact 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.

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

4.1

5. I UPDATE THE RATE - DAILY

4.1

5.1. I retrieve the data

Go to Banco de México Portal BANXICO and SIE - Mercado cambiario.

Info

title	IMPORTANT

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

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 daily exchange rate of Canadian Dolar (CAD) does not appear in the screen above, to get this information you should enter in the 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 AddedImage Removed Image Removed Image Removed Image Removed

Save these prints in the TAXAS DIARIAS worksheet.

4.1

5.2. PF1

4.1

5.2.1.I upload the exchange rate -

daily
Daily
Run the transaction ZRATEMOD (system PF1) in order to upload to SAP the Exchange Rate.
In the transaction insert the following information:
"Valid From" – Enter the previous current day's exchange rate.
"From Currency" – 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 RemovedImage Added

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 process for CNY, EUR, JPY, USD, and US$.
4

5.
1.
2.2.

I check the exchange rate -
daily - PF1
Daily
Access the transaction: ZRATE
In the transaction, insert the following information:
"DATE" – Enter the previous 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 RemovedImage 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 RemovedImage Added

Click in SELECTION, BY CONTENTS:
Image RemovedImage Added

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

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 RemovedImage Added

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

5.3. WP1
4
5.
1.
3.1I upload the exchange rate -
daily
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 previous 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 RemovedImage Added

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 process for CAD, CNY, EUR, JPY, USD.
4

5.
1.
3.2 I check the exchange rate -
daily
Daily
Access the transaction: ZRATE
In the transaction, insert the following information:
"DATE" – Enter the previous 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 LMXD.

And check that the rates are updated correctly.
Image RemovedImage 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 RemovedImage Added

Click in SELECTION, BY CONTENTS:
Image RemovedImage Added

Select VALID FROM ( date of day) e EXCHANGE RATE TYPE (lmxd)
Image RemovedImage 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 RemovedImage Added

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

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
4.2

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

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

6.2.
2.
PF1
4.2
6.2.1. I upload the exchange rate - Monthly
Run the transaction ZRATEMOD (system PF1) 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 business day of the current month.
"From Currency" – the currency, for the Mexican companies must be updated 3 currencies: –The rate is updated for the following currencies CHF; IDR; SGD;.
"Exchange Rate Type" - LMXD.

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: CHF, IDR and , SGD.
4

6.2.2.
2. I check
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
"Exch. Rate type" – the type of 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; 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 business day of the current month.
"From Currency" – the currency, The rate is updated for the Mexican companies must be updated 5 following currencies: BRL, CLP, KRWEUR, IDR, SGD.
"Exchange Rate Type" - LMXD.

Image RemovedImage Added

Image RemovedImage Added

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, KRWEUR, IDR, and SGD.
4.2

6.3.
WP1 4.
2
.3.1
I
upload
check the exchange rate - Monthly
4.2.3.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.
"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.