Creating and Configuring Exchange Rate Tables

Overview

The exchange rates between currencies are defined in exchange rate tables. Lucanet allows, in addition to average exchange rates, closing exchange rates, and historical exchange rates, also year-to-date exchange rates to be stored foreign currency translations for all exchange rate relationships (transaction currencies and display currencies). You can create any number of exchange rate tables in order to model variants of the same exchange rate connections with different exchange rates in Lucanet, for example.

This article contains the following sections:

Creating Exchange Rate Tables

To create one or more exchange rate table(s):

  1. Right-click the Exchange rate tables root folder.
  2. Choose Create | Exchange rate table from the context menu. The Create Exchange Rate Table dialog is displayed:

    Create an exchange rate table
  3. Specify at least one transaction currency and one Display currency.
  4. Click Save.

An exchange rate table is created automatically for each combination of different transaction currencies and display currencies. If you have, for example, selected both EUR and USD as both transaction currency and display currency, then two exchange rate tables will be created: EUR -> USD and USD -> EUR.

Configuring Exchange Rate Tables
The dialog for editing an exchange rate table is displayed.
Configure an exchange rate table

To configure an exchange rate table:

  1. Click the name of the exchange rate table in the tree view and then at the top right click Edit.
  2. On the Exchange rates tab, choose the data level for which exchange rates are to be defined from the drop-down list Data level.
  3. Define the currency detail:
    Retain the preselection if the exchange rate display is to take place from the view of the transaction currency (= one currency unit of the transaction currency corresponds to x currency units of the display currency).
    Choose the other option if the exchange rate display is to take place from the view of the display currency (= one currency unit of the display currency corresponds to x currency units of the transaction currency).
  4. Deactivate the check box Show max. 5 decimal places if all decimal places are to be displayed for each exchange rate.
    Usually, the Lucanet software rounds the complete exchange rates in accordance with commercial principles.
  5. Enter the exchange rate settings for each period (see Defining Exchange Rate Settings for the Actual Data Level/Defining Exchange Rate Settings for Planning Data Levels).

 

The following exchange rate settings are available for the actual data level for each period:


Option

Description


Closing exchange rate

Enter the closing exchange rate. The value can be imported from the European Central Bank or from MS Excel (see Importing Exchange Rates).


Average exchange rate

Enter the average exchange rate. The value can be imported from the European Central Bank or from MS Excel (see Importing Exchange Rates).

The value is automatically determined by clicking Calculate .


Year-to-date exchange rate

Enter the year-to-date exchange rate.

The value is automatically determined by clicking Calculate .


Year-to-date start

Activate the check box in the Year-to-date start column in order to configure the beginning of the fiscal year and the determination of the year-to-date exchange rate to this period.

The Year-to-date start cell is active only if the On account level with year-to-date exchange rate value is selected as the default conversion type for transaction types. 

The month for which the switch-over to the conversion with the Year-to-date exchange rate was selected is at the same time the beginning of the fiscal year for the aggregation of the year-to-date values to be converted.


Default translation type for transactions

Choose a different value if necessary:

  • On document level with average or historical exchange rate The average exchange rate or the historical exchange rate is used for the conversion.
  • On account level with year-to-date exchange rate The exchange rate stored in the Year-to-date exchange rates column or the historical exchange rate is applied for the conversion. 

If you change the translation type for transactions and if postings already exist for reporting entities that use this exchange rate table, then the message The changes shown in red will take effect only after a reorganization of the database is displayed. This means that this change will have no effect until the current database is exported and then imported once again.


The following exchange rate settings are available for the planning data level for each period:


Option

Description


Closing exchange rate

Enter the closing exchange rate. The value can be imported from the European Central Bank or from MS Excel (see Importing Exchange Rates).


Average exchange rate

Enter the average exchange rate. The value can be imported from the European Central Bank or from MS Excel (see Importing Exchange Rates).

The value is automatically determined by clicking Calculate .