Currency Translation Codes for Accounts

Currency translation codes are normally specified only for detail accounts, that is, summation accounts are not normally defined with a currency translation code.

But when you, for example, use currency translation code A you need to define a currency translation code for the summation account as well.

Note: Some currency translation codes will be followed by a reference to a specific account (these are marked with an asterisk (*) in the next list).

Currency Translation Code A*

Currency translation difference that is calculated directly on a summation account. The A code calculates the difference between the value of the reference summation account in the converted currency and the corresponding value in the local currency multiplied by the closing rate, the average rate or the average period rate. It is also necessary to define a currency translation code for the summation account itself. It is this code that decides if the A code should use the closing rate, the average rate or the average period rate, as a comparison when calculating the currency translation difference. The A code should only be used in combination with summation accounts with currency translation codes B, M or D.

For intercompany accounts, the currency translation difference is calculated for each transaction, for example by counter company.

If the currency translation difference should be calculated several times, use the A2 and/or A3 currency translation codes in combination with currency translation code A. Use currency translation code A2 if you use integrated accounts, for example when you calculate a currency translation difference for a grand total on the specification. Use currency translation code A3 on the main form if the converted amounts from the specification are copied to the main form using currency translation codes U, V, X or Z.

Currency Translation Code A2*

Currency translation difference that is calculated after that currency translation code A has been calculated. Use currency translation code A2 if you use integrated accounts, for example when you calculate a currency translation difference for a grand total on the specification.

The currency translation code A2 is calculated according to the same rules as currency translation code A.

Currency Translation Code A3*

Currency translation difference that is calculated after that currency translation codes A and A2 have been calculated. The currency translation code A3 is also calculated after that the converted amounts from the specification has been copied to the main form, when you use the currency translation codes U, V, X or Z. You do not need to use currency translation codes A or A2 to be able to use currency translation code A3. If you only want to calculate the currency translation difference on the main form, it is enough to use the currency translation code A3.

The currency translation code A3 is calculated according to the same rules as currency translation code A.

Currency Translation Code B

Closing rate according to the currency rate register.

Currency Translation Code C*

Opening balance of currency translation differences. The converted value for the reference account is copied from the previous year. For intercompany accounts the value is loaded for each transaction, for example by counter company. For more information, see Currency Translation of Opening Balances.

Currency Translation Code D

Average period rate that is used to convert the change for the period using the change in local currency and the average period rate. The period can be 1, 2, 3, 4 or 6 months depending on the definition of the account. In the reference text box for the currency translation code, enter the number of months that should be the definition of the period. If nothing is defined the period is assumed to be 1 month. For more information about currency translation code D, see Currency translation Code D.

Currency Translation Code E

Historical rates can be entered in the register of historical rates for the specified account. Any amount exceeding what is entered in the register is also converted at the historical rate. If there is no amount in the register, the account is converted at the closing rate. This code can be followed by a reference to a specific account. For more information, see The Register of Historical Rates.

Currency Translation Code F

Historical rates can be entered in the register of historical rates for the specified account. Any amount exceeding what is entered in the register is also converted at the historical rate. If there is no amount in the register, the account is converted at the average rate. This code can be followed by a reference to a specific account. For more information, see The Register of Historical Rates.

Currency Translation Code G

Historical rates can be entered in the register of historical rates for the specified account. Any amount exceeding what is entered in the register is converted at the average period rate. If there is no amount in the register, the account is converted according to the rules for currency translation code D. This code can be followed by a reference to a specific account. For more information, see The Register of Historical Rates and Currency translation Code G.

Currency Translation Code I

OB rate, which is the relation between the local and converted currency for previous year’s closing balance. Normally, you define a closing balance reference account. If no reference account is specified or if no values exist in local or converted currency for the previous year, the closing rate for the previous year is used instead.

For intercompany accounts, a ratio of rates is loaded for each counter company, transaction currency and counter dimension (if applicable). If the rate is not available, the closing rate for the previous year will be used instead. For more information, see Currency Translation of Opening Balances.

In company journals, accounts with currency translation code I can be converted in detail. You can define this in the general configuration. For more information, see Detailed Currency Translation of Accounts with Currency Translation Code I.

Currency Translation Code K

OB rate, which is the closing rate of the previous year specified in the currency rate register.

Currency Translation Code L

OB rate, which is the average rate of the previous year specified in the currency rate register.

Currency Translation Code M

Average rate for the accumulated period specified in the currency rate register.

Currency Translation Code N

Number, no currency translation. Rate = 1.

Currency Translation Code O*

Currency translation differences. Calculates the difference between the value of the reference account in the converted currency and the corresponding value in the local currency multiplied by the closing rate.

Currency Translation Code P*

Currency translation differences. Calculates the difference between the value of the reference account in converted currency and the corresponding value in local currency multiplied by the average rate

Currency Translation Code U

If another account is coded to be reconciled against an account with currency translation code U, the value is copied in converted currency to the U account from the account where the reconciliation is stored. Usually a converted amount from a specification is copied to an account with currency translation code U in the main form. Several values from various accounts reconciled against the U account can be added. If amounts are missing from the specification accounts, the U account is converted at the closing rate (B) instead.

If dimensions are used, you can only define the copying of the value from the specification account, if the account is, logically speaking, more divided than the one in the main form (the account with currency translation code U). For more information, see Specifications.

Currency Translation Code V

If another account is coded to be reconciled against an account with currency translation code V, the value is copied in the converted currency to the V account from the account where the reconciliation is stored. Usually a converted amount from a specification is copied to an account with currency translation code V in the main form. Several values from various accounts reconciled against the V account can be added. If amounts are missing from the specification accounts, the V account is converted at the average rate (M) instead.

Currency Translation Code X

If another account is coded to be reconciled against an account with currency translation code X, the value is copied in the converted currency to the X account from the account where the reconciliation is stored. Usually a converted amount from a specification is copied to an account with currency translation code X in the main form. Several values from various accounts reconciled against the X account can be added. If amounts are missing from the specification account, the account is not converted at all.

Currency Translation Code Z

If another account is coded to be reconciled against an account with currency translation code Z, the value is copied in converted currency to the Z account from the account where the reconciliation is stored. Usually a converted amount from a specification is copied to an account with currency translation code Z in the main form. Several values from various accounts reconciled against the Z account can be added. If amounts are missing from the specification accounts, the Z account is converted according to the rules for currency translation code D instead.