Exchange rates

Optionally, you can import exchange rates to an Infor d/EPM business application from the ExchangeRates integration import table. If you leave this table empty, then exchange rates must be specified in the Infor d/EPM business application.

These two groups of exchange rates are available in the Infor d/EPM business applications:

  • Standard rates
    • F: Closing rate or period end rate. The closing method is designed for the balance sheet accounts. The exchange rate is expected to be the closing rate for the converted period. In the year-to-date period view, the data is first added up and then converted. The opening balance period is used in the closing method and the opening balance rate is entered.
    • PA: Periodic average rate. The periodic average method is designed for the profit and loss accounts. The exchange rate is expected to be the average rate for the converted period. In the year-to-date period view, the data is first converted and then added up. The opening balance period is not used in the periodic average method.
  • Historical rates
    • H: Historical rates. Historical rates focus on the closing balance of an account. That is, the correct historical rate is determined based on the closing balance of the current and the previous period. You cannot load historical rates into Financial Consolidation.

The use of business data from the ExchangeRates table is optional in Budgeting & Planning, Workforce Budgeting, and Financial Consolidation.

Caution: 
These five properties, together, make a record unique:
  • Period
  • Year
  • CompanyCurrency
  • GroupCurrency
  • ExchangeRateType

If multiple records have the same values for each of these properties, then only the first of those records is loaded.

This table shows the properties of the ExchangeRates table and uses these abbreviations:

  • BP: Budgeting & Planning
  • WB: Workforce Budgeting
  • CO: Financial Consolidation
  • R: Required
  • U: Used but optional
Field Description Type BP WB CO
Period Period number.

Business Modeling data import translates periods in this way:

  • 0 to 01
  • 13-16 to 12
  • The remaining periods are translated to two-digit periods (PP).

Business Modeling data import merges a period and year to the PP_YYYY format, for example, 01_2019.

 integer R R R
Year Translated to the YYYY format.

Business Modeling data import merges a period and year to the PP_YYYY format, for example, 01_2019.

 integer R R R
Entity Base level record from the Entities business object.

Required only with the H type of the exchange rate.

 nvarchar U U
Intercompany Base level record from the Entities business object. nvarchar U U
Account Base level record from the Accounts business object.

Required only with the H type of the exchange rate.

 nvarchar U U
CompanyCurrency A three-character ISO code of the entity currency. nvarchar R R R
GroupCurrency A three-character ISO code of the group currency. nvarchar R R R
ExchangeRateType Code of the exchange rate type.

These codes are available:

  • F: Closing rate of period end rate
  • H: Historical rate
  • PA: Periodic average rate
Note: You cannot load historical rates into Financial Consolidation.
 nvarchar R R R
Value Currency exchange rate, a multiplier to convert a company currency to a group currency.

For historical rates of H type, the rate is a movement rate for a period, entity, account, and optionally, for an intercompany.

 float R R R
Related topics