If the invoices in different currencies are included in the report and you do not select a currency in the Convert to Currency field, the value total in the report will be meaningless, as it will be the sum of amounts in different currencies. In such cases, it is recommended that you enter a currency in the Convert to Currency field.

If you select a currency in the Convert to Currency field, the prices and values in the report will be converted to the selected currency using the exchange rate specified in the Bank for FCY Docs. field. One of the following exchange rates will be used:

• Exchange Rate for Price List (see Program Parameters | Company | General)
• Bank of Slovenia (see Program Parameters | Company | General)

The date that will be used for the conversion will be determined the same way it is when entering issue invoices: the date for the exchange rates is usually the date of the invoice. You can specify a different date at Program Parameters | Goods | General.  For an example see Invoices Issued Report in a Foreign Currency.

If you create a report in a foreign currency, the currency used in the report will be shown among the report criteria in the report header.

Example:

• Invoice 09302000001 was created in USD. The amount of the invoice was 100 USD, and the Bank of Slovenia's middle exchange rate the day the invoice was created was 1 EUR = 1.32 USD. VAT was not calculated for the invoice.
• The amount in the invoice was 100 GBP, and the Bank of Slovenia's middle exchange rate the day the invoice was created was 1 EUR = 0.67 GBP. VAT was not calculated for the invoice.

1. Invoices Issued Report without Currency Criteria

If you do not enter currency criteria, the total of these two invoices will be the sum of two amounts in different currencies, and will therefore be meaningless.

2. Convert to Currency (USD)

Let's suppose you would like to show both invoices in the same currency in order to compare information. You would like the report to be in U.S Dollars, so in the panel for entering criteria for the invoices issued report, select the code for the Dollar, USD, in the Convert to Currency field.

You would like to use the Bank of Slovenia's exchange rates. These are also the exchange rates that you use when entering documents.

Note that the currency that you selected appears in the report header among the report criteria (Currency - USD).

The program will produce a report with the following information.

• Issue invoice 09302000001 does not require conversion, as it was created in the selected currency (USD). The value of the invoice is 100 USD.
• Invoice 09302000002 was created in GBP. The value of the invoice is 100 GBP. In the report, this amount will be converted to USD: 197.02 USD.

3. Convert to Currency (EUR)

If you select the currency code for the Euro in the convert to Currency field, all invoices will be converted to Euros using the exchange rates that you selected in the Bank for FCY Docs. field. In line with the settings that you have entered, the exchange rate on the day that each invoice was issued will be used.

• Invoice xxx was created in USD. The value of the invoice was 100 USD, and the middle exchange rate of the Bank of Slovenia on the day the invoice was issued was 1 EUR = 1.32 USD. The value of this invoice in the report will therefore be 75.76 EUR.
• Invoice xxx was created in GBP. The value of the invoice was 100 GBP, and the middle exchange rate of the Bank of Slovenia on the day the invoice was issued was 1 EUR = 0.67 GBP. The value of this invoice in the report will therefore be 149.25 EUR.

The values in invoices issued reports are therefore NOT generated simply by copying the values in the in EUR field in the invoices (see Value Bar), but are recalculated using the same parameters that were used when the invoices was created.   If the value in the invoice does not match the value in the invoices issued report, it means that either the document or the exchange rates have been changed. In this case, we recommend that you check the exchange rate in the document against the exchange rate used for posting (see Financials | Reports | Summary Reports | Automatic Posting).