After establishing global currency defaults, you can create custom FX Currency configurations for specific table fields. Identify the table fields that use FX Currency, and define how currency conversion calculations should be performed, displayed, filtered, and aggregated.

For each selected field that uses FX Currency, you configure settings that:
  • Govern decimal precision and currency display in lists, forms, and reports.
  • Identify the reference currency code for converting currency values entered into an FX Currency field into a common currency for report aggregations.
  • Identify the rate table and data source to use for currency conversions.
  • Specify the rate and target fields to use for filtering custom conversion rates.
Note: When you create a currency configuration, it applies those settings only to the FX Currency field that you add it to. An FX Currency configuration takes precedence over global system properties that you established in System Localization > All Properties.

To learn more about global currency defaults, see Configuring FX Currency global settings.

You can change the defaults at any time. Doing so doesn't affect existing values, but it can make working with existing values difficult.
  • For example, if you modify the Reference Currency field in the Currency tab, existing instance records have the old reference currency, but new instance records have the new reference currency. You can't perform an operation such as sum aggregation because the reference values are in different currencies.
  • However, because the actual reference currency in the Currency Instance [fx_currency2_instance] table is accessible in an FX Currency field, you can use any script that performs this aggregation.