Importing Exchange Rates for a Simplified Multicurrency Application

Import exchange rates for a simplified multiple currency application using a template.

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

Note:

To view the exchange rates options, the application must have been created with the Multicurrency option enabled and the Multicurrency Type must be Simplified. A Currency dimension is then created. If you're unsure whether your multicurrency application is simplified, the existence of a Currency dimension will confirm it.

See About Simplified Multicurrency.

To import exchange rates using a template:

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

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

3. In the 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.

   Tip:

   To streamline the job creation process for subsequent Import Exchange Rates jobs, you can duplicate an existing job using the Save As option, then update it. See Duplicating Jobs.