Translation Worksheets

Form ID: (CM304000)

You can use this form to view the details of existing translation worksheets and to edit the details of the unreleased translations, if needed. You can also release a translation worksheet on this form.

Note:

This form is available only if the Translation of Financial Statements feature is enabled on the Enable/Disable Features (CS100000) form.

Form Toolbar

The form toolbar includes standard and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands are listed in the following table.


Button	Description
Release	Releases the translation worksheet and generates the appropriate batch.
Reports	Provides the Translation Details menu command. You can click this menu command to navigate to the Translation Details (CM651500) report, which shows the details of the translation worksheet.

Summary Area

In this area, you can select and review the translation worksheet, which has been prepared on the Prepare Translation (CM501000) form.


Element	Description
Translation Number	The unique number that the system has assigned to the translation in accordance with the numbering sequence specified in the Translation Numbering Sequence box on the Currency Management Preferences (CM101000) form. To view a particular translation worksheet, you select its number in this box
Status	The status of the translation, which can be Balanced or Released.
Translation Date	The date when the translation worksheet has been prepared.
Currency Effective Date	The effective date for the currency exchange rates that were used in the translation.
Fin. Period	The period for which the translation was prepared.
Description	The description of the translation.
Translation ID	The identifier of the translation definition that was used for preparing the translation worksheet.
Branch	The branch of the company whose accounts have been translated. This box appears on the form only if the Multibranch Support feature is enabled on the Enable/Disable Features (CS100000) form.
Destination Ledger ID	The destination ledger of the Reporting type where the results of the translation have been stored.
Destination Currency	The currency of the destination ledger. This is the currency to which all the account balances have been translated.
Translation Batch Number	The number of the Currency Management batch that was generated when the translation worksheet was released. You can click the batch number to view the details of the batch on the Journal Transactions (GL301000) form.
Debit Total	The debit total for the translation, which is the sum of the Transaction Debit Amount values.
Credit Total	The credit total for the translation, which is the sum of the Transaction Credit Amount values.
Control Total	The translation control total, which is equal to both the debit total and the credit total. The translation gain or loss amount is added to balance the credit and debit totals. When the translation worksheet is saved, the system checks whether the debit total is equal to the credit total and whether they both are equal to the control total.

Table

This table displays the list of account balances that have been translated to the specified currency in accordance with the translation definition.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.


Column	Description
Branch	The branch whose account balance has been translated. This column appears on the form only if the Multibranch Support feature is enabled on the Enable/Disable Features (CS100000) form.
Account	The particular account for which the balance (for the specified subaccount, if subaccounts are used in the system) has been translated into the destination currency.
Description	The description of the account.
Subaccount	The subaccount for the selected account for which the balance has been translated into the destination currency. This column appears on the form only if the Subaccounts feature is enabled on the Enable/Disable Features form.
Translation Method	The translation method used for the account, as specified in the translation definition on the Translation Definition (CM203000) form.
Source Amount	The balance of the account in the source currency, which is shown depending on the translation method specified in the translation definition.
Translated Amount	The period-to-date or year-to-date balance of the account in the destination currency.
Orig. Translated Amount	The account balance in the destination currency after the previous translation that was prepared with the same translation definition. For the first translation prepared in the system, this column holds zero balances for all accounts.
Rate Type	The rate type used for the translation of the balance specified for this account in the translation definition on the Translation Definition (CM203000) form.
Currency Rate	The effective exchange rate for the destination currency that was used for translating the account balance.
Transaction Debit Amount	The debit amount of the adjusting transaction for the account-subaccount pair. This amount is calculated as the amount in the Translated Amount column minus the result of the previous translation with the same translation definition in the Orig. Translated Amount column. If the difference is positive, it is recorded as a debit amount, and if the difference is negative, it is recorded as a credit amount and the debit amount is set to zero.
Transaction Credit Amount	The credit amount of the adjusting transaction for the account-subaccount pair. This amount is calculated as the amount in the Translated Amount column minus the result of the previous translation with the same translation definition in the Orig. Translated Amount column. If the difference is negative, it is recorded as a credit amount; if the difference is positive, it is recorded as a debit amount and the credit amount is set to zero.