Hai Ha Money Transfer

Money Transfer / By /

By Christopher Andrews, March 10, 2026

Hai Ha Money Transfer

Understanding Currency Exchange in ERP Systems

For businesses engaged in international trade or any form of cross-border transactions, understanding how to manage currency exchange rates within their Enterprise Resource Planning (ERP) systems is paramount. Accurate currency exchange rates ensure that accounts payable (AP) and accounts receivable (AR) transactions are recorded correctly, maintaining the integrity of financial data across the organization.

This article delves into the mechanisms by which exchange rates can be effectively integrated within systems like Microsoft Dynamics NAV and Dynamics 365 Business Central (D365BC). Specifically, we turn our attention to the automatic updating of exchange rates using the Currency Exchange Rate Services, with the Bank of Canada (BOC) as a primary resource.

The Importance of Accurate Currency Exchange Rate Management

Currency fluctuations can significantly impact financial reporting and operational efficiency. Companies that operate with multiple currencies must periodically update exchange rates to maintain the accuracy of their general ledger and financial statements. Typically, there are two methods to input exchange rates into NAV and D365BC:

  1. Manual entry on the “Currency Exchange Rates” page.
  2. Automated updates via the “Currency Exchange Rate Services” function.

This discussion focuses primarily on the latter, emphasizing its benefits and practical implementation.

Setting Up Currency Exchange Rate Services

To successfully set up the Currency Exchange Rate Services, users must first navigate to the designated area within the ERP system:

Departments > Administration > IT Administration > Services > Currency Exchange Rate Services

Here, users can initiate a new service by clicking on “New” within the Ribbon, which opens a form for configuration.

Key Configuration Fields

Several fields warrant attention during the setup process:

  1. Code: A brief identifier for the service.
  2. Description: A detailed explanation of the service.
  3. Enabled: Activating this field prevents further adjustments to the setup.
  4. Service URL: The web link to the service’s data source.
  5. Service Provider: The official name of the data source provider.
  6. Terms of Service: A link to the service’s terms and conditions.
  7. Log Web Requests: An optional feature that can assist in troubleshooting any setup issues.

Integrating with the Bank of Canada

For this implementation, we will use the Bank of Canada’s daily exchange rates. The URL for accessing this service appears as follows:

Bank of Canada Exchange Rates

Users can modify the start date in the URL to reflect the earliest date for the availability of currency exchange rates. Setting it to a specific date allows the system to update currency rates retrospectively from that point onward, which can be especially useful for ensuring historical accuracy in financial records.

Field Mapping Essentials

Upon filling out the service fields, the next step involves completing the Field Mapping FastTab:

  1. Parent Node for Currency Code: This requires selection of the appropriate node that represents the currency code within the data structure.
  2. Currency Code: Similarly, the correct node for the currency code must be specified, ensuring correct identification matching the BOC’s coding structure.
  3. Starting Date: A critical field to capture the effective date for exchange rates.
  4. Exchange Rate Amount: Indicates the monetary value for currency exchange rates, commonly set to “1”.
  5. Relational Exchange Rate Amount: This field retrieves the foreign exchange value corresponding to the defined amount.

Finalizing the Setup

With the Field Mapping set, the final step involves enabling the Currency Exchange Rate Service. After marking the service as enabled, you will configure the Job Queue Entry, determining when and how frequently the rates are updated:

  1. Earliest Start Date/Time: Choose a launch date and time for the service.
  2. Recurring Job: Mark this option to keep updates ongoing, adjusting the interval to align with BOC’s updates (typically weekdays).
  3. Number of Minutes Between Runs: A daily execution interval set at 1440 minutes conforms to the BOC’s daily updates.

Conclusion

In summary, automating currency exchange updates through the Currency Exchange Rate Services streamlines the financial operations of businesses that depend on dynamic exchange rates. It saves time, enhances accuracy, and allows for prompt adjustments as new rates become available. While utilizing the BOC service offers a cost-effective solution for Canadian dollars, businesses operating in other currencies may require different service providers, who may impose fees for their exchange rate information.

At Encore, we are committed to helping organizations optimize their use of Currency Exchange Rate Services. Our team of specialists is ready to answer any questions about Microsoft Dynamics 365 Business Central or NAV to support your ERP objectives. For personalized assistance, feel free to reach out to us!

Additional Resources

  • Bank of Canada Terms of Service
  • Daily average exchange rates (available every business day by 16:30 ET)
  • Monthly average exchange rates (published by 16:30 ET on the last business day of each month with specific transformation rules)
  • Annual average exchange rates (provided with transformation guidance by 16:30 ET at year-end)

Disclaimer

This article is intended for informational purposes only and should not be used as financial advice. Please consult a professional for guidance specific to your financial situation.