Currency Rates
- [Currency Codes] Defines what currencies should be available in the installation
- [Currency Pairs] Defines what cross currency rates should be possible to define (e.g. USD<->EUR)
- [Currency Types] Defines different currency types and calculation methods
- [Map Object Values to Currency Types] Defines what currency type and calculation method should be used for object values
The user interface enables you to maintain currency rates for the client and quickly edit data for more than one period. The currency rates for each period are stored in the related table in the database (dat.curr_rates). However, you can also enter rates that can be applied across many periods in the user interface.
Access Currency Rates by selecting Client Administration > Currencies > Currency Rates.
To edit currency rates, complete the following:
First, select a planning version. Normally, ‘ACT’ Actuals.
Select which currency type you want to edit the currency rates for.
Then, select the time unit level (month, quarter, etc) you want to enter rates, and from what period to what period.
Enter the cross rates for the defined currency pairs.
Select Save. The application will automatically apply the newly updated rates to all periods within the time frame you have defined in the ‘From time value’ and ‘To time value’.
Below is a list of Currency Rate fields:
Field |
Description |
Example |
Note |
|---|---|---|---|
Version |
The ‘planning version’ for which you want to edit currency rates. |
ACT Actuals |
|
Currency Type |
The currency type for which you want to edit rates. |
BS Balance Sheet Currency Types |
|
Time Unit |
The time unit level for which you want to edit the rates. |
ISOMONTH |
If using Datastore consolidation, this should be set to ISOMONTH. If set to 'quarter', or similar, the currency rates will not be available in the dat.curr_rate table on a lower level than the selected time unit. |
From time value |
The start of the time frame for which you want to add/change the rates. |
201501 |
|
To time value |
The end of the time frame for which you want to add/change the currency rates. |
201502 |
|
Currency Rates |
In the list of defined currency pairs, enter the cross-currency rates that should be applied to all periods between the time frame. |