Currencies

Facts can include amounts in various currencies. Amounts are published in five currency types. LN stores amounts in the local currency, reporting currency 1 and reporting currency 2. These are referred to as home currencies. Because the amounts in these home currencies are table fields, they are automatically published.

Standard calculated fields have been added to publish amounts in the reference currency and in the data warehouse currency.

The three home currencies and the reference currency are part of the company setup in LN. To review the company setup, navigate to Master Data > Enterprise Model > Enterprise Structure and start the Companies (tcemm1170m000) session.

To set up the data warehouse currency, exchange rate type and currency rates so that LN can publish amounts in the data warehouse currency:

  1. In Infor Ming.le, navigate to LN.
  2. In LN, navigate to Master Data > Master Data Parameters to start the Data Warehouse Parameters (tcgen0100100) session.
  3. Open the details of the active parameters (record without effective date).
  4. Define a data warehouse currency and an exchange rate type to be used by LN to convert amounts.
  5. In LN, navigate to Master Data > Code Definitions > Financial Codes to start the Currency Rates (tcmcs0108m000) session.
  6. Define a currency rate for the data warehouse currency and exchange rate type.
  7. Repeat for each company that publishes to Data Lake. In LN, navigate to Options > Change Company to start the Change Company (ttdsk2007m000) session. Select the same data warehouse currency in each company to be able to aggregate amounts for all companies in Birst reports.

If no data warehouse currency is defined, or if no data warehouse parameters exist, zero amounts are published in the data warehouse currency. If you want to use the data warehouse currency, we recommend that you specify this at the start: it takes an initial load to send amounts in the data warehouse currency for existing data.

The amounts stored in the data warehouse end with these currency types:

  • LC = Local currency
  • RC1 = Reporting Currency 1
  • RC2 = Reporting Currency 2
  • RFC = Reference currency
  • DWC = Data warehouse currency

For example, Actual Labor Costs RFC.

The custom subject area that end users see in Birst, however, does not show five amount measures for each amount in LN. Instead, one saved expression covers all five currency types. This expression uses the Currency Type filter that users can apply to select one of the five amounts.

If users do not select a value for the currency type filter, a default currency type is used.

The default is defined in Birst variable LN_usr_ReportDefaultCurrencyType with value RFC (Reference currency). We recommend that you change to DWC if a data warehouse currency is set up. See Configuring Birst for details about changing variables in Birst.