Specifying historical forecast rates

Use the Enter Exchange Rates - Historical page to specify forecast historical exchange rates for the historical translation method. The forecast currency version is composed of actual exchange rates and either budget or forecast exchange rates. The currency exchange rates associated with the source actual, budget, or forecast data version are copied into the forecast currency version when the forecast version is created. You cannot change actual exchange rates using this page.

  1. Click the Home icon.
  2. Select Global Settings > Currency Exchange > Historical Forecast Rates.
  3. Specify this information:
    Version
    Select a version.
    Entity
    Select an entity.
    Target Currency
    Select a target currency to convert to the group 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. 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 the entity currency and is used when translating accounts to currencies other than the group currency.
  6. 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.
  7. 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.
  8. Optionally, select Actions > Copy Exchange Rates From Version.
    This option opens the Select Source Version dialog box where you can select the version from which to copy the exchange rates into the selected version on the page.