Dear colleagues,
I know there are a few threads about this topic but I couldn't find my answer.
Let's hope you have an idea for my problem.
While implementing D365FO for a Norwegian branch of an EU company we have the following constellation:
- Accounting currency is NOK and reporting currency is EUR.
- EUR currency has the triangulation flag set (as default)
- FX data source is ECB and we would like to use the integrated standard fx rate update functionality.
- We have regular sales and purchases in USD, GBP, SEK...
Taking SEK currency as an example: ECB is not providing the NOK-SEK pair but EUR-NOK and EUR-SEK.
I was expecting that when registering an invoice in SEK, the system will do the triangulation SEK-EUR-NOK, however, this is not happening and an error message pops up claiming that the rate is missing.
After setting up the FX rate EUR-NOK & SEK-EUR in denomination currencies it works (invoice in SEK, equivalent in NOK and reporting in EUR), however, this is not the intended purpose of denomination functionality because in there the rate is fixed for a date and that would require a manual daily update of the rates.
A second option is to directly create the pairs NOK-SEK, NOK-USD... but they won't be automatically updated by the standard functionality either. The user would need to calculate them and fill them in.
Do I miss something or there is simply no better solution?
Thanks in advance for your comments