If the user has the right permissions and an ERPconfig API is used, Currencies can be maintained via 'Setup' → 'Financial setup' → 'Currencies'.
Add and edit
Via the add button, it is possible to add a Currencies manually.
In addition, it is possible to edit or adjust the Currencies. Using the button will save the adjustment.
Via Excel upload
Using the download icon, the Excel template can be downloaded. This can be used to add a whole new set of Currencies, or to modify existing Currencies by overwriting the data.
In the Excel, the fields have to be filled in according to the downloaded format. It is not possible to modify the columns, column names (titles), and order, this will cause an error during the upload. This functionality makes it possible to support different Currencies. At last, via the upload
Format
The format from the Excel should be maintained for a successful import. It is therefore not possible to adjust the the columns, column names (titles), and the order, this will cause an error during the upload. The fields mentoined below should be filled in with a specific format:
|
Veld |
Format |
|---|---|
|
Code (code) |
The code belonging to the currency. |
|
Exchange rate (exchange_rate) |
Numerical. The exchange rate belonging to the currency. |
|
Reversed exchange rate (is_reversed_rate) |
Reverse exchange rate, with options yes or no. Use only one of the two options below in English without capitalisation:
|