This appendix contains these topics:
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.
This section discusses the effects of having multi-currency turned on.
Decimals for amounts representing associative units ledger types, such as BU and AU, are determined by the Display Decimals in the data dictionary.
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.
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.
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.
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