Translation worksheets (CM304000)
In this window, you can view the details of existing translations and to edit translation details. When a translation is created, the debit total is equal to the credit total, because one of the values contains the translation gain or loss calculated as the difference between the credit total and the debit total.
However, after you finish editing the translation worksheet, the totals may differ. If they do, enter a new translation control total before you save the worksheet. When you save it, a new gain or loss will be calculated to compensate for the difference, and the translation will become balanced again.
This window is available only if the Translation of financial statements functionality is enabled in the Enable/disable functionalities (CS100000) window.
## Search line in list window If you are in the list window, the first line in the table is a search line. Each column has a search field which you can click to search for or filter on specific values and narrow down the displayed table rows. You can search and filter in as many columns as you need to, to only display the results you want to view. There are two types of search fields: + White: here you can type a specific search term to display results in this column containing this exact value. If you search on several (partial) words, you can separate them by a space or **%** and get different results: + space: the result contains the words in any order, + **%**: the result contains the words in the specific order, and the **%** functions as a wildcard as well. + Grey: you can click this to open the column filter pop-up window where you can filter the results for this column.The window toolbar
| Button | Description |
|---|---|
| Release | Releases the translation and initiates the creation of the appropriate batch. |
| Reports | Provides the Translation details menu command, which you can click for quick access to the Translation details (CM651500) report for the translation. |
The top part
In this area, you can select a translation that has been prepared in the Prepare translation (CM501000) window and view the settings of the translation.
| Element | Description |
|---|---|
| Translation number | The unique number assigned to the translation in accordance with the numbering series. |
| Status | The status of the translation, which can be Balanced, Unposted (the status of a released translation), or Posted. |
| Translation date | The date when the translation was generated. |
| Currency effective date | The date for the destination currency rate change. |
| Period | The period for which the translation is performed. |
| Description | The detailed description of the translation type. |
| Translation ID | The ID of the type of translation, which was defined in the Translation definition (CM203000) window. |
| Branch | The branch of the company. |
| Destination ledger ID | The destination ledger (which should have a reporting type) where the results of the translation will be stored. |
| Destination currency | The currency of the destination ledger. This is the currency to which all the amounts should be translated. |
| Translation batch number | The number of the batch that implements the translation transactions upon release. You can click the batch number to view details of the batch. |
| Debit total | The debit total for the translation. The translation gain or loss amount is added to balance the credit and debit totals. |
| Credit total | The credit total for the translation. |
| Control total | The translation control total. 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. If there is any difference resulting from manual editing, you must enter a new control total. |
The table
This table displays the list of account balances translated to the specified currency in accordance with the translation settings.
| Column | Description |
|---|---|
| Account | The particular account for which the balance for the specified subaccount was converted into the destination currency. |
| Description | The description of the account. |
| Subaccount | The subaccount for the account. |
| Translation method | The translation method used for the account. |
| Source amount | The period-to-date (PTD) or year-to-date (YTD) balance of the account in the base currency. |
| Translated amount | The PTD or YTD balance of the account in the reporting currency. |
| Orig. translated amount | The account balance in the reporting currency after the previous translation. For the first translation, all account-subaccount pairs involved have zero balances. For the first translation in the period, all account-subaccount pairs for which the PTD method is used have zero amounts in the column. |
| Rate type | The rate type used for translation of the balance. |
| Currency rate | The effective exchange rate for the destination currency. |
| Transaction debit amount | The debit amount of an adjusting transaction for the account-subaccount pair, which is calculated as the currently translated amount minus the result of the previous translation. If the difference is positive, it is recorded as the debit amount, and if the difference is negative, the debit amount is set to zero. |
| Transaction credit amount | The credit amount of an adjusting transaction for the account-subaccount pair, which is calculated as the currently translated amount minus the result of the previous translation. If the difference is negative, it is recorded as the credit amount; if the difference is positive, the credit amount is set to zero. |