Generate Translation
You can run the translation process during a period, translating into any currency that is set up in Reporting Exchange Rate Maintenance.
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. This can be changed, but it must be a valid period end date.
Translation level
Select Balance if you want the general ledger period summary balances to be translated. Select Transaction if you want each transaction to be translated, or selected GL Account to use the translation level assigned to the general ledger account in GL Account Maintenance.
Transaction ledger
Select the option to translate for the Balance Sheet, Profit and Loss, or Both.
Currency
This is taken from Translation Module Control, but you can change it to a different rate. This is the currency into which values will be translated.
Rate Override Code
The default value is <no override> but you can select an 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.
Translation
reserve amounts will only be calculated for a rate if the Translation
Reserve indicator is selected for the rate in Customise
Reporting Exchange Rates.
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 (see above) must be set to Both;
- Translations must be finalised in date order — for example, you cannot finalise a translation for April 2018 if the March 2018 translation is not finalised;
- The GL 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 will be determined by the type assigned in General Ledger Account Maintenance. If this is set to Module default for the account, the types assigned in Translation Module Control is used based.
Unless the Use currency historical rates option is selected for the account in General Ledger Account Maintenance, the currency rate used for the translation is the rate of the rate type. The exception to this is where an change code is applied to the translation.