Specifying periodic average and closing forecast rates

Use the Enter Exchange Rates page to change the periodic average and closing rates for the forecast version. 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. Actual exchange rates cannot be changed on this page.

Currency exchange rates for these translation methods are entered for the configuration set, forecast currency version, year and translation method. The rate entered is the rate to translate the entity currency to the target currency. The target currency defaults to the group currency and the rates between the entity currency and the group currency must be present.

  1. Click the Home icon.
  2. Select Global Settings > Currency Exchange > Periodic Average and Closing Forecast Rates.
  3. Specify this information:
    Version
    Select a version.
    Target Currency
    Select a target currency.
    Translation Method
    Select the translation method.
  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 forecast 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. The actual rates cannot be changed on this page.
  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.
  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.