Multi-Currency

Overview

BOS Enterprise allows transactions to be recorded in multiple currencies. Rates of Exchange can be added using up to six decimal points. A setting lets you choose to multiply or divide the exchange rate. (e.g. USD x 17.5 = Local Currency or USD / 0.0571 = Local Currency).

General Settings > Currencies

Navigation Example

Main Menu > Setup > Settings > General (tab)

Note

The defaults are the values for new databases, new users and new Transaction Types. Your database may have different values.

Setting Description Default
Currencies > CurrenciesProvides an Edit... button in the Value column. Clicking the button opens an interface that allows currencies to be added. The currency symbol must match the internationally recognised symbol for the currency. See Currency Setup below.Not applicable
Currencies > Denominations for Home CurrencyProvides an Edit... button in the Value column. Clicking the button opens an interface where the denominations can be added or edited (that is, which notes and coins are available).Not applicable
Currencies > Enable Multi-currencyCheckbox. If checked, multiple currencies can be used. If unchecked, all the multi-currency functions are disabled.Checked
Currencies > Local CurrencySelect the Local Currency from the list of currencies entered.Not set
Currencies > Use the Multiplication Exchange RateCheckbox. If checked, the local currency is multiplied by the exchange rate to determine the foreign currency (e.g. ZAR x 19.050335 = 1 Euro). (If unchecked (default), the foreign currency is divided by the exchange rate to determine the local currency amount (e.g. USD / 0.0568 = ZAR).Unchecked

Currency Setup

Navigation Example

Main Menu > Setup > Settings > General (tab) > Currencies > Currencies (setting)

Currencies Tab

Info

Fields marked in blue (✎) can be edited.

Field Description
IDThe system-generated number for the currency.
SymbolThe internationally recognised symbol for the currency. This symbol appears throughout the application where currencies are used.
DescriptionFor internal use only. Enter the name of the currency.
MajorThe name of the notes (e.g. Rands, Euros).
MinorThe name of the coins (e.g. Cents).
Multiply
  • The amount by which the local currency must be multiplied to determine the foreign currency (e.g. ZAR x 19.050335 = 1 Euro).
  • The amount can include up to six decimal numbers.
  • Any change to the Multiply field updates the Divide field.
Divide
  • The amount by which the foreign currency must be divided to return the local currency amount (e.g. USD / 0.0568 = ZAR).
  • The amount can include up to six decimal numbers.
  • Any change to the Divide field updates the Multiply field.
Updated by
  • The name of the User who last updated the currency or Auto when the system updates the currency.
  • These updates include changes to the Description or Major, Minor names.
  • See the History Tab for only exchange rate changes.
UpdatedThe date on which the record was last updated.

History Tab

  • Displays a list of exchange rate updates with the changes.

Understanding Currencies in BOS Enterprise

  • Currencies are set for each Customer and Supplier (defaults to the local currency).
  • If a customer or supplier is allocated a foreign currency all their transactions must be in that currency.
  • If a customer or supplier uses more than one currency, create separate accounts for each currency (e.g. Customer A – ZAR, Custom A – EURO).
  • You can override the multiple or divide exchange setting when creating a transaction.
  • Bank accounts must be linked to a currency. A context menu option: Change Currency (Enables Currency column for editing) lets you select or edit the currency. (Main Menu > Setup > Accounting > Accounts (tab)). A Warning appears if transactions are linked to the account using the existing currency.
  • Separate Transaction Types are required to record bank payments and receipts in the various currencies because a bank account can only be linked to a single currency.
  • Separate Transaction Types are not required for customer or supplier invoices. Invoices default to the customer or supplier's currency as set up on their accounts. However, the Transaction Type's setup must allow multiple currencies.

Updating Exchange Rates

  • Exchange rates can be scheduled to automatically update at regular interval using BOS Tools.
  • In BOS Enterprise currencies can be manually updated by overtyping the specific exchange rates.

Foreign Currencies and Item Prices

  • If items are used for foreign-currency transactions, they must have a price in that currency.
  • On item's Costing & Pricing tabs, prices can be created for each currency.
    • There can be multiple supplier prices.
    • There can only be one cost and sell price per currency and per unit.
    • Cost and Sell Prices in a foreign currency can be linked to supplier prices in any currency.
    • When creating prices, if the RoE Override checkbox is checked, you may override the exchange rate when using the item. (This column may be hidden and can be exposed using the Field Chooser (*) in the first column.)
    • An amount can be entered in the Cost Adj % column to provide for costs such as currency fluctuations, shipping and customs clearance fees.

Viewing Reports

Field Description
Ledger accounts
  • Ledger accounts automatically select the currency from the currency dropdown list that they are in.
  • A different currency can be selected from accounts that are in a foreign currency dropdown list (e.g. a bank account in US dollars, can be viewed in US dollars or South African Rand (the local currency), but not in any other currency).
Transaction lists
  • You can show or hide columns for the currency of the transaction and the VAT exclusive amount in the foreign currency (e.g. Currency, Total CUR).
Age Analyses
  • There is a checkbox Local Currency.
    • If checked, all the balances appear in the local currency. With this option, a balance may show as outstanding in the local currency, when the accounts are zero in the foreign currency. This outstanding balance is due to exchange rate fluctuations (that is, different exchange rates apply to the invoice and payment).
    • If unchecked, all the balances appear in their own currencies.
  • A Currency column displays the currency allocated to the customer or supplier.

Report an issue with this page

For more useful feedback, select the text on the page you're reporting about, then click Feedback again — or continue without selecting anything.