FX Currency fields - Product Documentation: Xanadu

FX Currency fields

Administer the Now Platform > Configure Now Platform Core Features > Currency administration >

FX Currency fields

Use FX (Foreign Exchange) Currency fields as an alternative to the standard (default) currency fields found in most applications. They are highly configurable, support use of custom rate tables, report aggregations, and provide for improved visibility into conversion calculations.

Note: You don't have to install a plugin to use FX Currency functionality. It's activated by default.

Use considerations Use the FX Currency field type in place of the standard currency fields when you must: Support values expressed in multiple currencies, for example, EUR 100, JPY 200, USD 30, as values in a field. FX Currency fields provide better support for multi-currency applications than do standard currency fields. Control how the FX Currency field is configured, including specifying its internal behavior and currency value formatting. To learn more about currency configuration, see Configuring FX Currency field behavior .

Create custom conversion rate tables. To learn more about custom table rates, see <a class="xref" href="../task/custom-rate-table.html" title="You can create a custom rate table to ensure repeatable and consistent calculations. In a custom rate table, you control the conversion rates and the frequency of rate conversions. If you don't define custom rate tables, FX Currency fields use the System Conversion Currency Rate [fx_system_rate] table, which updates rates daily from the ECB (European Central Bank) website.">Add conversion rates using a custom rate table .

Have more control over when the actual currency conversion occurs. FX Currency values convert on demand only, making the conversion results much more transparent. To learn more about currency conversions, see Understanding how FX Currency field conversions work .

Provide greater transparency into currency conversion calculations. You can view and configure the calculation components, including conversion dates, reference currency, and number of displayed decimals. Build query conditions using FX Currency field values. For available query conditions, see Operators available for filters and queries . Access FX Currency fields through richer scriptable APIs. Aggregate currency values as entered by users, or aggregate them in selected reference currencies, for reporting purposes.

Important: You can add FX Currency fields to base and custom applications, and they work independently of existing standard currency fields. However, you can't convert or change a standard currency field to an FX Currency type field. No functions are available to convert standard currency fields to FX Currency fields, then migrate the data from one to the other.

Understanding FX Currency values in forms In forms, the FX Currency field behaves like a dot walkable field in script. It consists of an entry field, and an accompanying list for selection of a currency code. Understanding how FX Currency field conversions work You can use existing system currency rates or define a custom conversion rate table for use in FX Currency processing. Understanding FX Currency values in lists and reports By default, the currency values that appear in the FX Currency fields in lists and reports are the values that you directly enter into the FX Currency fields. For reports, the aggregations of FX Currency fields are, by default, reference currency values. FX Currency values in import and export In general, currency values crossing the boundaries of the platform represent whatever is returned by getDisplayValue . Usually this currency value is the default as entered by a user into an FX Currency field for a transaction.

Parent Topic: Exploring currency administration

Related concepts Standard currency fields

Related reference Field types