Using Import Rates Job Type

Use the Import Rates Job Type to import currency rates based on a particular period and rate type from a CSV file in the Account Reconciliation repository and returns the success or failure status.

Import Rates job types parameters include:

Note:

For parameters that are common to all job types, see Pipeline Process Description.

Table 12-25 Import Rates Job Type Parameters and Descriptions

Import Rates Job Type Parameters Description
Period

Select the name of the period from which to import currency rates, such as July2016.

Rate Type

Select the rate type, such as Accounting when you require translation of transactions entered into the reconciliation. Configure only rate types used for period end balance translation in the source systems being reconciled..

File

Select the name of the file from which to import rates, such as rates.csv

Import Type

Select the option that indicates the action to be taken when there are existing values for one or more rates.

Available:

  • Replace—All rate values from the import file will be added to or will replace the existing rate values. Existing rate values that are not in the import file will not be changed.
  • Replace All—All values from the import file will completely replace the existing rate values. Existing rate values that are not in the import file will be deleted.