Importing Exchange Rates for a Multicurrency Application

Note:

To view the exchange rates options, the application must have been created with the Multicurrency option enabled. When you select the Multicurrency option during application creation, a Currency dimension is then created. By default, the multicurrency type is simplified. If you do not have a Currency dimension in your application, the Import Exchange Rates and Export Exchange Rate Template options will not be displayed on the Actions menu. See Setting Up Currencies.

To simplify managing exchange rates for a multiple currency application, you can export the provided ExchangeRateTemplate.csv template, enter your exchange rates in a spreadsheet, and then import the rates into your application. You can import exchange rates right away or schedule an Import Exchange Rates job to run later.

To import exchange rates using a template:

1. From the Home page, select Application, and then select Overview.

2. From the Actions menu, select Export Exchange Rate Template, and then open ExchangeRateTemplate.csv or save it locally.

3. In the ExchangeRateTemplate.csv template file, enter average and ending currency exchange rates for each period and each currency, specify members for the POV, and then save the file.

   Note:

   The number 1 represents the exchange rate for the default currency in the application. Enter rates relative to the default currency.

4. From the Actions menu, select Import Exchange Rates, click Create, browse for the file, and then click Import.

   Note:

   You can schedule the import to run as a job that runs right away or at a later time. To schedule an Import Exchange Rates job, select the Inbox option, point to an import file that is located in the Inbox, and then click Save as Job. See Scheduling Jobs.