Generate Translation

You can run the translation process during a period, translating into any currency that is set up on the Reporting Exchange Rate Maintenance form.

Options Reference

Each option and field on the form is described below. Mandatory options and fields are highlighted in red.

Reference

Enter a unique reference for the translation.

Description

Enter a description for the translation.

Translation date

The default value is the current date and is for reference only.

Period from/to

The Period from date defaults to the start date of the period subsequent to the last finalised translation run. You can change this, but it must be a valid period start date.

The Period to date defaults to the end date of the period subsequent to the last finalised translation run. You can change it, but it must be a valid period end date.

Translation level

Select:

Balance to translate the general ledger period summary balances.
Transaction to translate each transaction.
The selected GL Account to use the translation level assigned to the general ledger account on the General Ledger Account Maintenance form.

Transaction ledger

Select the option to translate for the Balance Sheet, Profit and Loss, or Both.

Currency

This is the currency into which values are translated.

This is taken from the Translation Module Control form, but you can change it to a different rate.

Rate Override Code

The default value is <no override> but you can select a change code.

Display options

Select Balances to display opening and closing balance rows. Select Movement to display summary, transaction, reserve, FCTR, and FCTV rows:

Opening row - Displays the opening balance with the same value as the closing row for the prior period.
Summary row - Displays a summary level balance.
Transaction row - Displays a transaction level balance.
Reserve row - Displays the difference between the opening row at the prior period and current period rates.
FCTR row - Displays a contra of individual reserve lines.
FCTV row - Displays any remaining foreign currency difference.

Note: Translation reserve amounts are calculated for a rate if the Translation Reserve option is selected for the rate on the Customise Reporting Exchange Rates form.

Final

This option is enabled if translations are required to support consolidations. The option defaults to false but should be selected if the current translation run is to be the final one used in the consolidation process. These rules apply to the processing of final translations:

The Translation ledger must be set to Both.
Translations must be finalised in date order — for example, you cannot finalise a translation for April 2019 if the March 2019 translation is not finalised.
The general ledger period of the translation must be closed.
There can only be one final translation for each unique period/currency combination.
The translation run becomes read-only once it is run with the Final option selected.

Run

Click this button to run the translation and return results to the table. Results may also be exported for reporting. The Translation Rate Type used to translate values for each account is determined by the type assigned on the General Ledger Account Maintenance form. If this is set to Module default for the account, the types assigned on the Translation Module Control form is used.

Unless the Use currency historical rates option is selected for the account on the General Ledger Account Maintenance form, the currency rate for the translation is the rate of the rate type. The exception to this is if a change code is applied to the translation.