Currency Updates

Overview

The Currency Update service enables you to automatically update all the currencies in the database (Except for the local currency) - manually or at scheduled intervals. It can update currencies on both BOS Enterprise and BOS Professional databases. Currencies are matched on their official symbols, for example, GBP, USD, and ZAR, so ensure these are properly set up in the database. 

Currency values are sourced from currencyfreaks.com. Currency Freaks provides up-to-date exchange rates for 180 currencies.

Adding a new Currency Update

• On the Home screen, click Menu > Currency Updates and click the New (button)

• Description - add a short Description to identify which Database is being updated

• Connection String - Right-click and select Edit Connection String  - This is the database that will be updated

• Schedule - Right-click and select Edit Schedule - See Scheduler for more details.

Note

For the process to run correctly, the Decimal Separator must be set to a period, not a comma. To change, follow the steps below:

1. Open the Control Panel

2. Navigate to Region

3. Additional Settings: Click on Change Date, Time, or Number Formats.

4. Customize Format: In the Numbers tab, change the Decimal symbol from a comma (,) to a period (.).

Note that the above may be slightly different depending on the version of Windows is used.