Skip to main content

Currency conversion

  • February 9, 2023
  • 1 reply
  • 65 views

rvgfox
Problem Solver
Forum|alt.badge.img+4

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?

 

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • February 9, 2023

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings