Dynamics 365 Business Central: Automate Currency Exchange Rate Updates
Hi Readers,
Business Central allows users to update currency exchange rates by navigating to Home >> Exch. Rates on the currencies page
Business Central provides an way to update currency exchange rates automatically by enabling integration with external exchange rate services that provide XML or JSON feeds through the Currency Exchange Rate service page.
At D365Bytes, we provide daily updated XML rates from Central Bank of Kenya, Bank of Tanzania, Bank of Uganda, National Bank of Rwanda & National Bank of Ethiopia which you can use in Business Central. The guide below shows how to our currency exchange rate service.
Set Up Exchange Rate Service
1.Search for 'Currency Exchange Rate Services'.
2. Click on New to create a new service.
3. Fill in the following fields in the General and Service section:
| Field | Value |
| Code | D365BYTES |
| Description | D365BYTES Rates |
| Service URL |
https://d365bytes.com/xml/kes.xml - Kenyan entity https://d365bytes.com/xml/ugx.xml - Ugandan entity https://d365bytes.com/xml/tzs.xml - Tanzanian entity https://d365bytes.com/xml/etb.xml - Ethiopian entity https://d365bytes.com/xml/rwf.xml - Rwandan entity |
| Service Provider | D365BYTES |
4. Open the Field Mapping area and populate the source columns
| Caption | Source |
| Parent Node for Currency Code | /currency/details |
| Currency Code | /currency/details/cur_symbol |
| Starting Date | /currency/details/exchange_rate_date |
| Exchange Rate Amount | /currency/details/exchange_rate_amount |
| Relational Exch. Rate Amount | /currency/details/exchange_rate_value |
5. Click on preview at the top of the page to confirm the mapping is okay.
6. The system will show a preview of the applicable currency rates with the rate applicable on that day from the respective central banks.
7. Click on Enable to activate the service.
8. The system will automatically create a job queue entry to automatically update the rates in the back ground.
9. You can make changes to the job queue if needed.
10. If the job queue was not created, the user can do a manual update on the currencies page ( Exchange Rate Service >> Update Exchange Rates )
11. The exchange rates will be updated.
Updating Historical Rates
You can get custom historical xml rates for CBK currencies on the website.
1.In the XML rates page, scroll to the currencies and click on Open. ( This applies only for CBK Rates at the moment)
2. In the historical page, select the date range required in the Custom Date Range and click on Load XML
3. The system will provide an xml link that can be used to load historical records within the date range selected.
4. Create a Currency Exchange Rate Service and consume the link as below
| Caption | Source |
| Parent Node for Currency Code | /currency/channel |
| Currency Code | /currency/channel/currency_symbol |
| Starting Date | /currency/channel/exchange_date |
| Exchange Rate Amount | /currency/channel/exchange_rate_amount |
| Relational Exch. Rate Amount | /currency/channel/exchange_rate |
5. Following similar steps in the guide above to enable and run the job queue, the system will be updated with the historical rates
Additional Info
- We have also transformed exchange rates where the exchange rate amount is not 1 to the relational exchange amount e.g Japanese Yen (100)
