Currency conversion

  • 9 February 2023
  • 1 reply
  • 46 views

Userlevel 3
Badge +1

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?

 


1 reply

Userlevel 6
Badge +5

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