System Data Currencies
Currencies
The Currencies screen contains a list of currencies that the system uses. When purchasing from companies using these currencies the system will automatically calculate buy prices for the items in the system's base currency (normally pounds Sterling), based on the conversion rates set in [ System Data | Accounts | Currency Conversions ]. In addition, sell prices on a sales order will also be calculated in the correct currency associated with the customer[1].
Currencies Grid
- Currency Name: the name of the currency.
- Code: the alpha-numeric code for the currency to used on the system. We suggest using the ISO 4217 three letter codes. For example GBP (Pounds Sterling), USD (United States Dollar), EUR (Euro), etc.
Note: the system will warn the user when saving a new entry if a duplicate currency code has been created. The user can acknowledge the warning and continue or change the code used before saving again. - Format: used to define how a currency symbol will display in reports, see Currency Format below.
- CT Account: used to define the card transaction account set in
[ System Operations | Edit Credit Card Integration Settings ]dialog when using multiple currencies, please email Support for help in setting this up. - ISO 4217: the three digit numeric code for the currency, as specified by ISO 4217. This numeric code is usually the same as the ISO 3166-1 numeric code. For example, USD (United States dollar) has code 840, which is also the numeric code for the US (United States).
Currencies Context Menu
- Apply Value Range: allows the user to specify a value that is to be applied to all of the currently selected rows/items for the current column.
- Clear Selection: deselects the currently selected line(s).
Currency Format
The currency format column should normally contain the currency symbol followed by "%f"[2][3], for example:
| Currency | Code | Format | ISO 4217 |
|---|---|---|---|
| Pound Sterling | GBP | £%f | 826 |
| Australian Dollar | AUD | AU$%f | 036 |
| US Dollar | USD | $%f | 840 |
| Euro[4] | EUR | €%f | 978 |
| Yen | JPY | ¥%f | 392 |
| Indian Rupee | INR | Rs%f | 356 |
| Danish Krone | DKK | kr%f | 208 |
| Norwegian Krone | NOK | kr%f | 578 |
| Swiss Franc | CHF | SFr%f | 756 |
Notes:
- ? The currency used by a specific supplier/customer can be set in their
[ Detail | Financial ]tab. - ? The number of decimal places shown for a currency can, exceptionally, be changed by prefixing the currency format with a single digit (e.g. to always display GBP to four decimal places set the format to "
£%.4f"). - ? Changing a currency's format does NOT alter the number of decimal places stored in the underlying database; should you wish to store and calculate currency values to four decimal places, an update is required.
- ? See How To: Type a Euro Symbol