Set up Exchange Rates

Security Note: You need the Allow the user to edit currency and exchange security right in the Marketing user group security rights group for this activity.

Activity Steps

Open the Currency/Exchange Editor.
Select the Exchange Rates tab.
To define an exchange rate source:
1. Right-click in the Exchange Rate Source field group and select New from the menu.
2. Complete the following fields.
  - Name
  - Source Name—Name of the rate provider.
  - Value Is Required—Whether values are mandatory for each Frequency period.
  - Frequency—Frequency of entering exchange rates. Select from Day, Week, Month, Quarter, Half Year and Year.
  - Calendars—Optional calendars to define business days. Select from the calendars defined in the Calendar Editor.
  - Default—Whether the exchange rate source is the default exchange rate source.
To enter exchange rates:
1. Select an exchange rate source.
2. Enter the following search criteria in the Exchange Rate field group.
  - Start Date
  - End Date
  - Source Currency—Source currency unit for which to show the daily exchange rate details.
3. Click Search or press F3.
  A column displays for each possible destination currency for each date in the period according to the Frequency.
4. Enter the Decimal Places to use in the conversion calculation for each destination currency.
5. Enter the Exchange Rate for each date in the period for each destination currency.
  Note: Press Ctrl+V to paste data copied from another application, such as a spreadsheet. If calendars are defined, exchange rates are not entered for work exclusion days.
To delete exchange rate data for a currency:
1. Right-click the Decimal Places for that currency and select Clear Exchange Rate Info from the menu.
  Important: This step deletes all exchange rate details for that currency for the exchange rate source, not only the data within the date range of the search.
2. Confirm the deletion.
Click Save.