Setup > Common tables > Currency rates 

This function is used to define currency rates and to inquire the history of rates in the form of a graph or table. A currency rate is defined:

  • for a given currency,
  • for a given rate type,
  • at a given date.

A direct rate can thus be associated with each given destination currency (the inverse rate being displayed).

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

In the screen, the 3 start data (source currency, rate type and rate date) are entered.

All currencies for which a rate has been defined at this date or at a later date are then displayed. In addition, these rates can be modified (the application date being displayed).

It is possible to:

  • modify a rate for an already entered currency (the rate date corresponding to the modified rate remains unchanged)
  • enter a new line in the table, included lines with an existing currency, in order to enter a new rate at a new date.

Header

Fields

The following fields are present on this tab :

 

  • Rate date (field DATCOURS)

 

  • Rate type (field CHGTYP)

 

Close

 

Entry screen

Presentation

Currency rates are entered as lines which are identified by the rate of the destination currency and the date.

The system checks that, for a given currency there are not two rates for the same date.

Close

 

Fields

The following fields are present on this tab :

Block number 2

Grid

It concerns the currency for which a rate is expressed.

  • Rate date (field CHGSTRDAT)

It's a matter of the reference date of the exchange rate.

  • Divisor (field CHGDIV)

The rate is given for this number of currency units. Thus Amt_local_money = Amt_currency * Rate / Divisor

  • field DEVORG

 

  • = (field EGAL)

 

  • Rate (field REVCOURS)

The exchange rate indicates the value for a currency unit in the header.

For example, if the currency in the header is EUR and the line currency is USD and the exchange rate is 0.9, it signifies that :

1 EUR = 0.9 USD

  • field DEVDES

 

  • Reverse (field CHGRAT)

Used to display the inverse exchange rate calculated from the rate entered.

Close

 

Action icon

Currency Initialization

This is used to fill out the table with one line per currency that can potentially have a different rate than the header currency. The lines correspond to the last known rate at the date provided in the header.

If no rate is known at this date for a given currency, a unit rate is suggested in the table.

 

Close

 

Tab Archived

Presentation

This tab displays in a "table" and "graph" the selected currency rates. 
COURDEV_01.png This button is used to switch from graph mode to table mode.
In graph mode, dates are displayed in the abscissa and the currency rates are in the ordinate.
The wheel makes it possible for the user to choose the curve type.
Besides, the user can choose whether to display all curves or to hide some (using the expandable menu bar in the top-right corner of the table).

Close

 

Fields

The following fields are present on this tab :

Table number 1

  • Date (field ADAT)

 

  • field CUR1

 

  • field CUR2

 

  • field CUR3

 

  • field CUR4

 

  • field CUR5

 

  • field CUR6

 

  • field CUR7

 

  • field CUR8

 

  • field CUR9

 

  • field CUR10

 

  • field CUR11

 

  • field CUR12

 

  • field CUR13

 

  • field CUR14

 

  • field CUR15

 

  • field CUR16

 

Close

 

Specific Buttons

The following fields are included on the window opened through this button :

Block number 1

 

  • Rate type (field CHGTYP)

 

  • Number of history days (field HISNBD)

 

Grid Currencies for display

 

Close

This button makes it possible for the user to view the curves of the selected currency rates with respect to the number of requested history days.
With each criteria change, the system refreshes the graph automatically, adding the new entry.
The user can save the criteria entered for a given graph using the [Memo] button.
SEEINFO Selecting criteria and calling memos has no impact on the list of currencies displayed in the "To date" tab.

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

Code already exists on line:

Two lines have been entered with the same currency code and the same date.

Euro currency - fixed exchange rate:

A currency with a fixed rate as compared to the Euro has been entered.

Tables used

SEEREFERTTO Refer to documentation Implementation