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.

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.