How Currency Decimals Are Managed

The number of decimal positions that the system displays for an amount varies according to the currency code and the type of ledger used for the transaction. This table describes how the system manages decimals in a multicurrency environment:

Decimals

Description

Decimals for amounts that appear without a company number.

Controlled by the value of the Display Decimals field (CDEC) in the data dictionary for the amount fields used.

Decimals for transaction amounts in ledger type AA (domestic currency).

Controlled by the base (company) currency code. The number of decimals for a currency is defined in the Currency Codes table (F0013).

Decimals for amounts in unit ledgers (ledger types ending in U).

Controlled by the value of the Display Decimals field (CDEC) in the data dictionary for the amount fields used.

Decimals for transaction amounts in ledger type CA (foreign currency).

The Post Account Balances by Currency check box is selected.

Controlled by the transaction currency code. The number of decimals for a currency is defined in the F0013 table.

Decimals for transaction amounts in ledger type CA (foreign currency)

The Post Account Balances by Currency check box is cleared.

Controlled by a general ledger account currency code, if applicable, or the transaction currency code associated with a specific total amount.

The system obtains the currency code from these tables in the order listed:

  • Account Balances (F0902) and Asset Account Balances File (F1202).

  • Account Ledger (F0911).

  • Customer Ledger (F03B11) and Accounts Payable Ledger (F0411).

Decimals for transaction amounts or balances that are not unit, AA, or CA ledger types.

Controlled by the base (company) currency code. The number of decimals for a currency is defined in the F0013 table.

Note: An exception to this rule occurs when a currency has been assigned to a ledger type in the Ledger Type Master File table (F0025). The decimals are controlled by the currency assigned to the ledger, not the company.