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:

  1. ? The currency used by a specific supplier/customer can be set in their [ Detail | Financial ] tab.
  2. ? 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").
  3. ? 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.
  4. ? See How To: Type a Euro Symbol

See Also


Did you find this article helpful?