Skip to main content

We are implementing a data warehouse with data from Dynamics 365 F&O and I’m thinking that we will have money data from UK in pounds and from Spain in euros and we will need currency conversion (based on time) to resolve this situation.

Some body has considered this situation?

How must it be implemented?

 

Hi Ramon

In the old AX 2012 data source you had the tables called ExchangeRate and ExchangeRateCurrencyPair

Which can be set up like so. Maybe do a filter so it only does the conversion to EUR

If you mix this with this guide

https://legacysupport.timextender.com/hc/en-us/articles/115005972746-Improve-execution-times-by-splitting-exchange-rates-out-on-dates#the-exchange-rate-table-contains-both-start-and-stop-date

You can get a currency per date and use it for better performance.


Reply