Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Currency Rates

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:

  1. First, select a planning version. Normally, ‘ACT’ Actuals.

  2. Select which currency type you want to edit the currency rates for.

  3. Then, select the time unit level (month, quarter, etc) you want to enter rates, and from what period to what period.

  4. Enter the cross rates for the defined currency pairs.

  5. 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.



Published:

Currency Rates

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:

  1. First, select a planning version. Normally, ‘ACT’ Actuals.

  2. Select which currency type you want to edit the currency rates for.

  3. Then, select the time unit level (month, quarter, etc) you want to enter rates, and from what period to what period.

  4. Enter the cross rates for the defined currency pairs.

  5. 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.



For an optimal Community experience, Please view on Desktop
Powered by Zendesk