Specifying historical rates

Use the Enter Exchange Rates - Historical page to specify historical exchange rates for the historical translation method. Currency exchange rates are specified for the configuration set, currency version, entity, account, year, and translation method. The rate that is specified is the rate to translate the entity currency to the target currency for a specific account and entity. The target currency defaults to the group currency and the rates between the entity currency and the group currency must be specified.

  1. Click the Home icon.
  2. Select Global Settings > Currency Exchange > Historical Rates.
  3. Specify this information:
    Version
    Select a version.
    Entity
    Select an entity.
    Target Currency
    Select a target currency.
    Translation Method
    Historical Rate is the translation method.
    Year
    Select a year in the configuration set that contains the relevant data. The default values are the years in the configuration set.
  4. In the Rate column, specify the exchange rate to translate the entity currency to the target currency. Click > to copy the rate to each month in the year to minimize manual data entry. You can provide a unique value for each month individually by specifying an amount in a month column.
  5. Optionally, select Actions > Select Years to include additional years outside of the configuration set. This option opens the Select Element dialog box where you can select from all the years that are defined in the application. The selected years replace the existing Year list.
  6. Optionally, select Actions > Reset Years to automatically set the Year list to the configuration set years after it has been changed by the Select Years option. This option is only available if the Select Years option has been used to adjust the Year list.
  7. Select Actions > Calculate Cross Rates. This option is available when the target currency is set to the group currency. This option calculates the currency exchange rates between all other currencies using the rates specified for the group currency. These rates can be examined after the Calculate Cross Rates option is executed by changing the target currency.
    For the Historical method, the cross rate is the same as the value specified for entity currency and is used when translating accounts to currencies other than group currency.
  8. Optionally, select Actions > Copy Exchange Rates From Version. This option opens the Select Version dialog box where you can select the version from which to copy the exchange rates into the selected version on the page.