Visma.net ERP
Translation worksheets (CM304000)
This topic gives you information about the elements that you find in this window in Visma.net ERP, such as fields, field values, buttons, and check boxes.
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.
| 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 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. |
| Translation batch number |
The number of the batch that implements the
translation transactions upon release. |
| Debit total |
The debit total for the translation. |
| 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.
|
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. |
| 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. |
