Transpas can collect the currenct currency rates from the European Central Bank (ECB). The rates are collected through the page Euro foreign exchange reference rates.
The ECB sets a new rate daily around 16:00. You might want to set that this rate should not be used until the next day. For this you can use date offsets within Transpas.
¶ Currency
In het screen Currency you can set which values are connected to a currency code.
Open the screen Currency
- F11 -> Currency or
- Main files -> Financial -> Currency
See the screenshot below: For NOK has been filled in that the currency rate provider is the Central Bank of Norway. When you click Get currency rate the current currency rate will be collected.
As can be seen new rates are collected daily around 4 PM. Those rates will already apply to that day.
When currency rate provider is empty, no rate can be collected.
¶ Currency rate providers
Settings for collecting the rate can be made at the currency rate provider.
Open the screen Currency rate providers
- F11 -> Currency rate providers or
- Main files -> Financial -> Currency rate providers
In the top of the screen the different providers are shown.
Every provider offers rates, in the bottom right you can set which currencies are to be collected from this provider. Currencies can be dragged with the mouse from Non associated currencies to Associated currencies or vice versa.
Some of the most important settings:
| Effective date offset | When this is empty, the collected date will apply to today. But you can set that this shouldn't be effective until tomorrow. See Date offset for more information. |
| Rate rounding | How decimals are to be rounded to |
| Update rates automatically | When this is set to no, rates are not automatically updatet |
| Update start time | The time when the first rate is to be collected |
| Update interval | The amount of time between every moment of collecting rates |
¶ Update mode
- Update is the default, this means Transpas can overwrite and add lines.
- Add only No updates of existing lines (this can occur when a currency rate provider supplies a different rate for an earlier date).
- Add newer only Don't add lines which are older than existing lines (this may occur when a rate couldn't be collected due to an error).