By Alex Johnson, March 10, 2026

Hai ha money transfer

In today’s global economy, businesses often engage in transactions that require handling multiple currencies. Understanding how to manage currency exchange rates accurately is essential for ensuring the validity of accounting processes. This article focuses on the Currency Exchange Rate Services available in systems like NAV 2016, 2017, 2018, and Dynamics 365 Business Central (D365BC). Utilizing these services can significantly enhance operational efficiency by automating the exchange rate update process.

The Importance of Accurate Exchange Rates

For organizations that conduct international business, the periodic update of exchange rates within their Enterprise Resource Planning (ERP) systems is crucial. Accurate currency values impact Accounts Payable (AP) and Accounts Receivable (AR) transactions, journal entries, and ultimately, bank and General Ledger (GL) balances. There are two primary methods for inputting exchange rates into NAV and D365BC:

1. Manual entry via the “Currency Exchange Rates” page.
2. Automatic updates through the “Currency Exchange Rate Services” function, which we will discuss in detail.

Setting Up Currency Exchange Rate Services

Configuring Currency Exchange Rate Services to automatically obtain exchange rates from reliable sources can save time and reduce errors significantly. This article will detail the setup process using the Bank of Canada (BOC) as a source.

To initiate the setup:

1. Navigate to Departments > Administration > IT Administration > Services > Administration > Currency Exchange Rate Services
2. Click on “New” to create a new service entry.

This opens a setup page featuring various fields that you must complete:

1. Code: A brief identifier for the service.
2. Description: A detailed explanation of the service.
3. Enabled: This must be checked at the end of the setup to activate the service.
4. Service URL: The web address from which the service will retrieve currency rates.
5. Service Provider: Name of the exchange rate service provider.
6. Terms of Service: A link to the relevant terms of service.
7. Log Web Requests: This can be useful for troubleshooting service issues.

For this setup, the URL for the Bank of Canada should look like this:

http://www.bankofcanada.ca/valet/observations/group/FX_RATES_DAILY/xml?start_date=2018-07-01

This URL can be modified by changing the date at the end, which designates the earliest rate update date for your service. For instance, inputting “2018-07-01” directs the system to overwrite all previous currency rates from that date onwards.

Field Mapping for Accurate Data Retrieval

Once the basic service setup is complete, the next step is to configure the “Field Mapping” section. This ensures that the system correctly interprets the incoming data from the BOC:

1. Parent Node for Currency Code: Select this node to map the currency codes accurately.
2. Currency Code: Similar to the previous step, this selects the line where the currency code appears. Use the designated format provided by the BOC, which generally appears as “FXEURCAD.”
3. Starting Date: Extract the starting date for the currency data.
4. Exchange Rate Amount: This should specify the amount for which the exchange rate will be quoted, such as one unit of currency.
5. Relational Exchange Rate Amount: This field indicates how the system retrieves the value of foreign exchange currency.

For a functional Currency Exchange Rate Service, ensure that each field is mapped correctly as per the BOC’s data format.

Enabling the Currency Exchange Rate Service

After completing the field mapping, you need to enable the service. Click on the “Enabled” button in the General FastTab, which will take you to the Job Queue Entry page. Here, you can set the following parameters:

1. Earliest Start Date/Time: Specify when the service should first run. By default, this will be set to the current date.
2. Recurring Job: This should typically be checked, allowing you to designate specific days for the service to run. Since BOC only updates rates from Monday to Friday, leave the weekend unchecked.
3. Number of Minutes Between Runs: Given that exchange rate updates by the BOC occur daily, setting this to 1440 minutes (or 24 hours) is advisable.

Conclusion and Benefits

By implementing the setup outlined above, businesses can automate their currency exchange rate updates effectively, reducing manual effort while enhancing accuracy. This automatic integration with the BOC’s daily service illustrates a strong model for similar implementations.

While the Bank of Canada service is free for public use, it’s essential to note its limitations. It updates only the currencies that the BOC provides. As such, companies using currencies outside this list (for example, the Ukrainian Hryvnia) must seek alternative services that might incur fees.

In summary, leveraging the Currency Exchange Rate Services function in NAV and D365BC not only saves time but also ensures that invoices reflect the most current rates available, subsequently improving financial accuracy. At Encore, our Solution Specialists are equipped to assist businesses in setting up these services efficiently to meet their specific needs. For more assistance regarding Dynamics 365 Business Central or NAV, feel free to contact us!

Useful Links Regarding the Bank of Canada

• Terms of Service
• Daily average exchange rates (published once each business day by 16:30 ET)
• Monthly average exchange rates (published by 16:30 ET on the last business day of each month)
• Annual average exchange rates (published by 16:30 ET on the last business day of each year)

To explore more about managing currency exchange rates and related topics, check out further insights available on the hai ha money transfer channel.

Disclaimer: This content is provided for informational purposes only. It does not constitute financial advice. Please consult with a qualified financial professional for personalized advice regarding your specific situation.