You can use this function to print three types
of reports for a selected period and actuality.
The
report types are:
- A report on currency rates - displays the rate ratio between selected
currencies and the currency to which the rates are to be related,
not necessarily the base currency. The report enables you to generate
reports of cross-rates.
- A report on historical rates - displays a summary of historical
rates for selected currency codes (From Currency Code and To
Currency Code) and companies. This report will only include
the currency codes for which there is a value stored in both the From
Currency Code and To Currency Code columns.
- A reconciliation report for historical rates that reconciles the
values for the selected currency and company. Reconciliation takes
place between what is entered in the register of historical rates
(in the From Currency Code column) and the
period values. Period values can be reported values, company journals
or group journals.
The Reconcile Historical Rates report
shows two difference columns: Actual Difference and Adjusted
Difference. The Actual Difference is
the difference between values including signs. The Adjusted
Difference is the difference between absolute amounts,
excluding signs. If you do not want to enter values with signs in
the historical register, for example with minus for cost accounts,
we recommend that you use the adjusted difference column. However,
if you are accurate with signs, we recommend that you use the actual
difference column.
You can print the Reconcile Historical
Rates report with the detailed or condensed settings.
In the condensed report, the reconciliation takes place by company,
account and currency. In the detailed report, reconciliation takes
place at a detailed level, that is, if appropriated by dimension,
counter company, journal type and journal number. By selecting one
of the relevant check boxes, it is also possible to produce a report
that only displays any occurring differences.
Procedure
- On the Group menu, click Reports/Currency
and Historical Rates. The Reports - Currency
and Historical Rates window opens.
- Select the report or reports you want to generate:
- Currency Rates: Select this option to
generate a report of currency rates that shows the rate ratio between
selected currencies and the currency the rates should be related to.
If you choose this report, enter the appropriate selections for Currency
Code and Rates Relates to. The Rates
Relates to option enables you to generate reports of cross-rates.
Then go to step 6.
- Historical Rates. Select this option to
generate a report of historical rates that shows a summary of historical
rates for selected currency codes (From Currency Code and To
Currency Code) and companies. This report will only include
the currency codes that have values for both From Currency
Code and To Currency Code. From
Currency and To Currency codes are
matched. This means that the rate relation will only be included in
the report where values exist for both currencies. You can select
more than one currency code. Then go to step 6.
- Reconcile Historical Rates. Select this
option to perform a reconciliation of all accounts using historical
rates (E, F and G codes) for the amounts entered in the historical
currency register and the amounts entered as period values. Reconciliation
will be made for currencies depending on the selected currency in
the From Currency Code text box. The report
shows two difference columns: Actual Difference and Adjusted
Difference. Actual Difference is the difference between
Period values (including signs) and values entered in the Historical
register (also including signs). Adjusted Difference is the difference
between the absolute amount (excluding signs) of Period values and
the absolute amount (excluding signs) of values entered in the Historical
register. If you choose this report, you also have to enter Options
for step 3, 4 and 5.
- (Only for Reconcile Historical Rates) Select the level
of detail to present the report in:
- Detailed: The reconciliation will be performed
by extended dimension, counter company, journal type and journal number.
- Condensed: The reconciliation will be
performed on company and account level.
- (Only for Reconcile Historical Rates) If you want to exclude
rows where the differences are zero, select one of the Hide Rows check
boxes.
- Hide rows where Actual Differences are zero:
Check this box if you only want to include rows with differences (including
signs) between period values and values entered in the historical
register.
- Hide rows where Adjusted Differences are zero:
Check this box if you only want to include rows with differences between
the absolute amount (excluding signs), of period values and values
entered in the historical register.
- Hide rows where both Actual and Adjusted Differences
are zero: Check this box if you want to exclude rows that
are zero for both the Hide rows where Actual Differences
are zero and the Hide rows where Adjusted Differences
are zero columns.
- (Only for Reconcile Historical Rates) If you want to have
a report layout suitable for large numbers, select the Use
Alternative Layout for Large Numbers (>9 digits).
- Enter the actuality and period range you want to print
the report for. To print the report for only one period enter the
same period in the From Period and To
Period text boxes.
- Click the Preview button to generate
the report.