A new knowledge base article has been published on our support portal.
Overview
When using multiple currencies in your Dynamics 365 instance you will want to keep the exchange rates updated for more accurate currency conversions.
We can do this easily using the Open Exchange Rates API and North52 BPA’s WebFusion and Scheduler components.
North52 BPA Solution
The North52 BPA solution works like this:
- A Schedule is set up to run daily and executes a Custom Action
- A Formula is set up on the Custom Action which:
- Calls the Open Exchange Rates API using the CallRestAPI function
- A list of exchange rates for all currencies are returned
- We then find all currencies in the Dynamics 365 system and then loop over each one (except the default currency) updating the exchange rate field with the corresponding value returned from the API request