B Currency Codes and Decimals

This appendix contains these topics:

B.1 Multi-Currency Option "Off"

If the multi-currency option is not activated, the decimals associated with specific amount fields are determined by the Display Decimals defined in the data dictionary by your System Administrator.

B.2 Multi-Currency Option "On"

This section discusses the effects of having multi-currency turned on.

B.2.1 "Units" Ledgers

Decimals for amounts representing associative units ledger types, such as BU and AU, are determined by the Display Decimals in the data dictionary.

B.2.2 "Amounts" Ledgers

Decimals for amounts other than units are determined as follows:

  • Any transaction entered with a currency different from the currency assigned to the company of the account being used is considered "foreign."

  • The decimal position is determined by the transaction's currency code.

  • The number of decimals for a currency is defined in the Currency Codes table (F0013).

All ledger types other than CA or any units ledger type, as mentioned above, are considered "domestic" ledgers. The currency's decimal position is determined by the currency code assigned to the company of the account used. This allows multiple companies in the same environment to have different currencies in the AA ledger.

For example, Company 00100 is a U.S. dollar (USD) base currency company, and its AA ledger represents USD. Company 00002 has euros (EUR) as its base currency, and its AA ledger then represents EUR.

An exception to this rule occurs when a currency has been assigned to a ledger type in the user defined code list (09/LT). If the special handling code of a ledger type contains a currency code, the decimals for the ledger are determined by that currency code.

For example, you have a company with a base domestic currency of euros (EUR). However, you want to establish a budget in U.S. dollars (USD). You can set up a ledger with USD in the Special Handling Code of the user defined code list (09/LT). Any entry made to that ledger is considered USD and not EUR.

The designation of a currency code for a ledger type should only be done as an exception. A currency code designation for a ledger type applies to all companies using that ledger. Therefore, you should not indicate a currency for the AA or CA ledger.

B.2.3 Totals on Reports

The decimal position for totals on reports follow the same rules as presented above. The currency code defined for the ledger type is the first determining factor. If that is blank, the currency of the company to which the last account is associated determines the decimal position. For summary amounts representing "foreign" currency in the CA ledger, the following rules apply:

  • F0902/F1202 - Balance reports use the "denominated in" Currency Code field on the record.

  • F0911 - Transaction reports use the account currency code. If it is blank, the transaction currency code of the last record is used.

  • F0311/F0411 - Customer and Supplier Ledger reports use the currency code on the last record. In some cases, reports have been changed to indicate that a total is not applicable if multiple currencies are summed. You would then see "****N/A****" used instead of a total.

B.2.4 Monetary (Currency-Specific) Accounts

If an account has been assigned a specific currency code, transactions entered to that account must be in that currency. This rule applies to the AA and CA ledgers only. If other ledger types have been established, the monetary account restrictions do not apply.


For monetary account revaluation purposes, a document type of JX overrides an edit that exists in programs so entry can be made directly to the AA ledger.

B.2.5 Technical Considerations

The Account Balances table (F0902) contains two currency codes:

  • CRCD - This code represents the original transaction currency.

  • CRCX - This code represents the denominated currency.

The following table illustrates the use of the CRCD and CRCX fields. The Account Balances table can optionally be posted in detail by the originating currency of the transaction.

For every transaction currency, you will have a corresponding balance. If this amount of detail is not required, your account balances can be summarized into one AA and one CA ledger balance for each account. (This does not consider the effect of posting by subledger to an account.)

Posting Option Ledger Type Originating Currency (CRCD) "Denominated In" Currency (CRCX)
Summarized Currency Post AA Blank Company Currency
Summarized Currency Post CA Blank Company Currency
Detailed Currency Post (and all monetary accounts) AA Transaction Currency Company Currency
Detailed Currency Post (and all monetary accounts) CA Transaction Currency Transaction Currency
Summarized Currency Post All other ledger types Blank Ledger Currency (if specified in the user defined code list (09/LT) or Company Currency

The result of posting a similar set of transactions in both summary and detail is shown below. This example shows a Belgian euro (EUR) company with sales originating in euros, U.S. dollars (USD), and British pounds (GBP). Account 401.5005 for Sales of Product A is illustrated.

CRCD = Original transaction currency

CDCX = Denominated currency

B.2.6 Detailed Posting by Currency

Account CRCD CRCX AA Ledger Amount CRCD CA CRCX CA CA Ledger Amount
401.5005 Sales Product EUR EUR 100,000      
  USD EUR 150,000 USD USD 5,000.00
  GBP EUR 45,000 GBP GBP 1,000.00

B.2.7 Summary Posting by Currency

Account CRCD AA CRCX AA AA Ledger Amount CRCD CA CRCX CA CA Ledger Amount
401.5005 Sales Product   EUR 355,000   EUR 1,600,000