Introduction

Currency exchange or conversion rates are maintained in this application. This data is used in multiple areas of the Scope system such as billing, payables and tariffs.

Description

New

Opens a pop-up window in which a new currency can be created.

Edit

Opens the currency highlighted using the currency editor in order to edit the currency details.

Delete

Deletes the highlighted currency.

Refresh

Updates the index to ensure the latest currencies and their rates are displayed.

Import...

Opens a popup window that allows import of external exchange rates into the application.

Table - Exchange Rates

A complete list of currencies and their rates.

New Currency

Currency

The 3 digit currency code of the new currency. This is a search field that can be used to find currencies available on the system.

Unit

The drop-down list provides a list all possible units:

Direct Quotation (Parity)

This checkbox is used to determine if the currency is quoted directly or indirectly.

OK

Saves the currency and exits the popup window.

Cancel

Exits the pop-up window without saving any changes.

Currency Editor

Currency Table: Code Units and Quotation type

The title of the currency table show the details of the currency and the listing beneath shows the actual exchanges rates. No rate is highlighted in the table, but any row may be selected and the details of this row will appear in the area below the table. This valid date and rates may then be adjusted. On selecting the Apply option, the new rates will appear in the table while the rates on which they were based will still be present.

Valid from

The Date, from which the exchange rate is valid.

Exchange rates / _Rate Types _

For each currency it is possible to maintain different types of exchange rates:

*note:

For reduction of risk regarding business with foreign currencies it was normal to add a mutual buffer at the house rate.

This mutual buffer had some different effects:

example: official exchange rate EUR-USD 1.17  and rates with a small addition (1.20) or rather a small reduction (1.10)

local currency of forwarder = EUR.

Invoice in EUR with a line about 100 USD

Invoice in USD with a line about 100 EUR

To optimize above mentioned cases the house rate is split into a "buying rate" and "selling rate". At the setup of ECB-Download (https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml) an addition or reduction can be adjusted.

Apply

Stores the rates and updates the summary table.

Close

Closes the currency editor.

Import of CSV-file

Exchange rates can be imported vis CSV file. Each exchange rate type must be imported seperately (see file format)

Exchange Rate type

Select the exchange rate type from the drop down.

Data file

Select the file from the directory. Enter the path or use to open the search dialogue.

Mark the file and select open.

Import

Starts the file import and closes the pop-up.

Cancel

Closes the popup without import.

File format

The import file needs to have the following criteria:

• CSV-Format (Semikolon separated file)
• column names need to match the following list:

Example:

baseCurrency;rate;unit;directQuotation;validFrom
USD;1,2370;1;0;15.11.2019