/
BC Set up Exchange Rate Service

BC Set up Exchange Rate Service

Setting up exchange rate services allows you to view and apply the exchange rate for different currencies within the system. This document will show you how to set up the exchange rate service using the provider FloatRates.

Start instructions here

  1. Search for Currencies, and select the appropriate option from the menu.

  2. Select Exchange Rate Services from the ribbon.

  3. Select New or +new to set up a blank service.
    Note: Follow these exact instructions to set up your service through FloatRates. You can use other options by finding and using the appropriate URL.

  4. Enter a code and description

  5. For the ‘Service URL’ enter: http://www.floatrates.com/daily/cad.xml

  6. Service Provider -  will be FloatRates or whoever is providing the service.

  7. Terms of Service – if a terms of service is provided this can be linked here.

  8. Next, we need to connect NAV fields to the appropriate xml fields in the Field Mapping FastTab. The Source column is where we connect the data. The lines you need to populate are:

    1. Parent Node – click the action button (3 dots) to open the source and select Item. We will connect the main table data for the Parent Node. This will populate the source field with ‘/channel/item’.Currency Code – This should be sourced to the ‘target currency’

    2. Starting Date – Sourced to the date the exchange rate was posted.

    3. Exchange Rate Amount – Sourced to the exchange rate of the target

    4. Relational Exc. Rate – Sourced to the base currency amount.

    5. Relational Currency Code – Added this field to the Field Mapping. Source to the Base Currency

    6. Fix Exchange Rate Amount – Does not need to be sourced, but a default value of ‘Relational Currency’ should be set since all my exchange rate amounts will be with a relational value of ‘1’.

  9. Next, we need to establish some Transformation Rules. Some of the source data we selected is not formatted properly, and this will convert the information appropriately.

    1. Transform the Starting Date. The Starting Date currently looks like this, Tue, 22 May 2018 12:00:01 GMT, which is not a NAV format. We need to create a new Transformation Rule to convert. Select the Look up value button on the Transformation Rule field on the starting date line.

      1. First set a code and description for this new rule with a transformation type of Substring.

      2. The Start Position will be where in the text we want NAV to start which will be 5 characters in to start at 22.

      3. Length will be set to the end of the date of 2018, which is 12 characters. This now narrows that field to look like this, 22 May 2018.

      4. Still not a NAV format, so we can apply an additional Rule where it says, Next Transformation Rule. Select the already premade Rule called US_DATE_FORMAT. This will then convert your date into a proper NAV format.

      5. You can test by copy pasting your data in the ‘Test Text’ and selecting Update to see if you get the results you want.

  10. We have to add a Transformation Rule to the Relational Exch. Rate Amount as that field was not provided with ‘$1’ we were looking for. Select the Look up Value button and select + new.

    1. Set the transformation type to Substring.

    2. Enter 1 for the Start position. This is the case because our field looks like this, 1 CAD = 0.77872376 USD, and we only want the first character of ‘1’.

This can be tested to make sure everything pulls correctly by clicking the ‘Preview’ button in the Home ribbon tab.

If you get that page to appear then everything is set up correctly, if you do not then you received errors that should be corrected. If an error occurred, go back through the previous steps.


After you successfully preview the exchange rate service, select enable, you will then be asked if you want to set up a Job Queue so the exchange rates can be run automatically at a specific time. If you select Yes you will see an additional window.

Most of the information will be filled in, but adjustments can be made on how often you want this to reoccur.

The Starting Time and Ending Time should be adjusted as the exchange rate from the xml will not be updated until 8 P.M. Eastern Time. Generally, this should run after business close and postings are complete.

  • Starting Time – Set to 11:00 P.M. (Eastern Time Zone server)

  • Ending Time – Set to 11:01 P.M. (Eastern Time Zone server)

No. of Minutes between Runs: 2 (this will only allow the Job Queue to run once)