Currency Administration

Before using and configuring an FX Currency field, you first add it an existing table, or to a new one, in System Definition Tables.

You can control what currency value is stored in audit records.

You can specify the number of decimal places stored and used in currency fields and calculations.

The standard, or default, currency fields are installed with the base system and used in most non-financial applications.

Configure defaults for standard currency and Foreign Exchange (FX) currency.

You can configure the system to use an optimizer for currency/price fields to speed up list view (reading currency/price values).

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.

The following sections show the properties associated with currency administration.

Currency values can be converted to other currencies when stored and accessed.

In general, currency values crossing the boundaries of the platform are represented in the user’s session currency and formatted in the user’s locale.

You can control how currency fields are configured and used in your instance.

In forms, currency values appear in the currency in which they were entered.

In lists, default currency values appear in the user’s session currency, formatted for display in the user’s locale. Typically, a formatted number follows the currency symbol.

Currency values in reports appear in the user’s session currency, and are formatted in the user’s locale with a currency symbol.

You can use currency fields in scripts.

Currency fields provide features for handling the calculation, conversion, and display of currency values.

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.

The ServiceNow AI Platform supports two types of currency fields: default (or standard) currency and Foreign Exchange (FX) currency.

Before setting up and using FX Currency, review the related system properties to confirm or modify its default behavior.

Identify the rate table and data source to use for currency conversions for the designated FX Currency field.

You can use existing system currency rates or define a custom conversion rate table for use in FX Currency processing.

Specify the table, and the field within the table (for example, cost), that the FX Currency configuration applies to. Then, select the decimal precision and currency display parameters for the field.

You can dot-walk certain fields in the Currency Instance [fx_currency2_instance] record, and field values stored in the database are consistent with each other. However, in script, since fields can be changed individually, and you change only some of the fields, they can be inconsistent.

Optionally specify the rate table and target table fields to use for filtering conversion rate information.

The behavior of FX Currency fields varies during the processing that occurs during the lifetime of a record containing them.

Set the reference currency for the designated FX Currency field. The ServiceNow AI Platform uses the reference currency to convert values entered into the FX Currency field into a common currency for report aggregation purposes.

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.

Updated with Claude for DOC1141697.FX Currency values that you import must include a three-letter ISO currency code, a semicolon, and an amount formatted for the user's locale, such as USD;1,234.56. In general, imported and exported values represent the display value returned by getDisplayValue.

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.

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.

There are two locale settings, system and user. The system locale determines the reference currency, and the user locale determines the session currency.

A price field is a currency field that enables control over conversions and display.

The default, or standard, currency fields in the ServiceNow AI Platform use two kinds of currency, Session and Reference.

Set up the defaults required for use of FX Currency fields in your instance.

Set up the defaults required for use of standard currency fields in your instance.

Single-currency mode enables all users of the platform to view currency values in the same currency.

Schedule the Update Currency Conversion Rates job to perform a nightly download of currency-conversion tables from the European Central Bank.

All currency conversions are based on the rates stored in the Exchange Rate table. You can turn off the regularly scheduled update from the European Central Bank (ECB), and maintain the table manually.

Review and edit the details of a currency entry in an FX Currency field.