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
You can get a currency per date and use it for better performance.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.