Generate Currency Translation Reports

Here you generate reports showing the amounts in the original currency and converted currency per form.

The report contains columns with values for original currency and converted currency for the current period, original currency and converted currency for the comparison period and a column with a calculated currency rate for both periods. The currency rate has been calculated in the report as the converted currency divided by the original currency and is not exactly the same as the rate used for currency translation of each account. When small amounts are converted, the rate may vary due to rounding, but if the variation is greater, there is probably something wrong with the currency translation.

If the system's currency rates are configured for division (D), the calculated currency rate will instead show the original currency divided by the converted currency.

For more information, see Define Currency Codes.

Procedure

  1. On the Group menu, click Reports/Currency Translation. The Reports - Currency Translation window opens.
  2. Enter the actuality, period and OB actuality for which you want to generate the report. OB period is automatically displayed.

    The selection of period in the Conversion Selections fields affect what companies or groups that will be available in the company selection field. Validation is made against the Define Company Structure.

    The OB actuality and period from which the report will load OB values. The previous year's CB period is automatically displayed, and can not be changed. If the report is going to be used for checking purposes, you should enter the same OB actuality as when you ran the currency translation.

  3. If you want to generate the report for companies within a specific group, select the Group option button. In the Consolidation type and Group text boxes, enter the relevant information for which you want to generate the report. Select the Include subgroups check box to include reports for all subgroups that belong to the specified group.
  4. If you want to generate the report for one or several companies, select the Company option button and enter the company code(s) in the Company text box.
  5. Select which currencies to show in the report, either a currency type or a currency code. Make a selection both for From currency (the original currency) and To currency (the converted currency)

    Select either the currency types, between which the currency translation has been run (for example LC and LE), or select relevant currency codes (for example from GBP to USD). These selections can also be combined, i.e. you can select to show the report from LC to USD or from CHF to LE. LE will always be the currency of the company that owns the selected company directly. If there are several owning companies, the report will show the currency of the company with the largest owning percentage.

  6. Select the form or forms you want to generate a report for and enter the closing version for which you want to generate a report.
  7. If applicable, enter the relevant extended dimension codes in the Extended Dim text boxes. If you leave the text box blank, the total value of the extended dimension will be displayed.
  8. If you want to have a report layout suitable for large numbers, select the Use Alternative Layout for Large Numbers (>9 digits).
  9. Click the Preview button to generate the report.

Results

The report displays the selected period and actuality as well as the closing balance from the previous year as reference. The Rates column contains a calculated rate based on the converted currency divided by the original currency. The rates may vary due to rounding, but if the differences are large, there may be errors in the currency translation.

To verify which calculation rule that has been used for an account, see the currency translation code for that account in the Define Account Structure window.