Control default currency field configuration and use in an instance
You can control how currency fields are configured and used in your instance.
These properties are available for currency fields.
Note: To open the System Properties [sys_properties] table, enter sys_properties.list in the navigation filter.
| Property | Description |
|---|---|
| glide.sys.audit_currency_value | When true, currency fields in audit records are the value entered by the user, in the format USD;1234.56. When false, the value is the numeric value in the session currency.- Type: Boolean - Default value: false - Location: System Property [sys_properties] table - Learn more: Configure default currency fields in audit records |
| glide.currency_price.use_all_fraction_digits | When true, currency fields have four decimal places. When false, two decimal places are used.- Type: Boolean - Default value: false - Location: System Property [sys_properties] table - Learn more: Change default currency decimal places |
| glide.currency_price_optimizer.enabled | When true, the optimizer is used. When false, the optimizer is not used.- Type: Boolean - Default value: true - Location: System Property [sys_properties] table - Learn more: Configure the currency optimizer |
| glide.currency_price_optimizer.min_rows | Minimum number of rows in parent table needed for the optimizer. When fewer than this number of rows are present, the optimizer is not used.- Type: Number - Default value: 4 - Location: System Property [sys_properties] table - Learn more: Configure the currency optimizer |
| glide.excel.convert_to_user_currency | When true, currency fields in a table are output in the user's session currency.- Type: Boolean - Default value: false - Location: System Property [sys_properties] table - Learn more: Exporting currency fields to Excel |
| glide.excel.fixed_currency_usd | When true, currency fields in a table are converted to US dollars.- Type: Boolean - Default value: false - Location: System Property [sys_properties] table - Learn more: Exporting currency fields to Excel |
| glide.system.locale | Value is of the format Language.Country where the language is an ISO 639 language code and the country is an ISO 3166 language code. Internally, this value is used as specified by Java. The system locale setting should be in the Java supported locales list.- Type: String - Default value: empty - Location: System Properties > System Localization - Learn more: Locale settings |
Parent Topic:Setting up defaults required for standard currency use
Related topics