To use the external exchange rate type

The amounts on the sales listing and the Intrastat declaration must usually be reported in the company's local currency.

When you process the invoices and orders in Invoicing LN converts the amounts to the local currency by using the exchange rate type of the transaction.

For the amounts on the sales listing and the Intrastat report, the rules for the currency rates to be used can differ between the countries. In some countries, you can use your own company rates and in other countries, you must use specific exchange rates, for example, the rates used by the European Central Bank.

For the sales listing and the Intrastat declaration, you can generate the amounts to be reported in two ways simultaneously:

  • As internal values for your own audits, using the transaction exchange rates. These amounts can be used to match the sales listing or the Intrastat declaration to your sales and purchase accounts.
  • As declaration values using the external exchange rates prescribed, for example, by the central bank. These amounts are included on the reports.

To calculate the amounts using the external exchange rate, take the following steps:

  1. Define an exchange rate type for the external exchange rates and define the exchange rates between the transaction currencies and the reporting currency for this exchange rate type. Use the currency rates prescribed by your central bank or other authority. For details, refer to To define currency rates.
  2. In the Companies (tcemm1170m000) session, you can optionally select the default external exchange rate type for the company.
  3. In the Export Intrastat Transactions (tccom7271m000) session or the Process Sales Listing (tccom7270m000) session, select the Recalculate Amounts with Declarant Exchange Rates check box.
  4. Select the external exchange rate type in the Declarant Exchange Rate Type field. By default, LN displays the external exchange rate that you entered in the Companies (tcemm1170m000) session.
  5. LN recalculates the invoice values and the statistical values in the local currency using the external rates of the invoice dates or order dates and prints the recalculated values on the reports. You can view these values as well as the internal values in the Sales Listing (tccom7170s000) session and the Intrastat Transactions (tccom7171m000) session.

Related topics