Format monetary amounts

The decimal significance for monetary amounts is controlled by the Number of Decimal Places in the currency table.

Input fields

All input fields that represent monetary amounts are validated by the applicable currency mask. The Number of Decimals supplied for a monetary amount cannot exceed the Number of Decimals defined for the currency.

Validation for decimal significance for monetary amounts is performed only when the applicable decimal separator character has been specified.

Note: The decimal separator character is based on the user's locale which is derived based on the Country and Language in the user's profile. For example, a period is used as the decimal separator character in most of North America, UK, Australia and New Zealand while a comma is typically used as the decimal separator character in South America and mainland Europe.

Fields that represent per unit rates are not affected by the limitation on Number of Decimals. Even if monetary amounts are limited to a maximum of two decimals, per-unit rates expressed in that currency can be defined using more than two decimals. The following monetary values in Transportation Manager unconditionally represent rates:

Order Value and Declared Value for shipment items could refer to a rate or an amount, depending on configuration of Summarized Entry Mode flag in the shipment version table. Validation for decimals for currency will be performed only when these values refer to a monetary amount (when Summarized Entry Mode is True). Otherwise, validation for decimals will be performed based on the attributes of the data base column (up to six decimal places will be allowed).

On pages where both currency and monetary amounts can be specified (for example, Create Freight Bill and Create Miscellaneous A/P Voucher), formatting for monetary amounts will be based on the Currency of user. Once a Currency has been established for the transaction, validation will be performed to ensure that decimal utilization is consistent with the selected Currency.

Flat Amounts defined on the Customer Tariff Surcharge/Discount pages are expressed in the rating tariff for the applicable A/P tariff. Therefore, the top level page where both Tariff Number and Flat Amount can both be defined will default in create mode to the Currency format for the user. Validation will ensure that the decimal precision for the Flat Amount is legal for the Tariff's Rating Currency.

Output fields

Monetary amounts on web pages are formatted as per the Number of Decimals for the applicable Currency. If a Currency is configured with zero decimals, amounts represented in this currency will be formatted without a decimal separator or decimal characters.

See Also

Currency