Currency triangulation issues

(6) Share

Report

Posted on by Puneet Darji

168

Hello,

In general ledger, I have setup my legal entity accounting currency as CAD and reporting currency as USD. I'm importing currency exchange rate on daily basis from central bank of europe provider (available out of box). This provider imports all the exchange rate keeping EUR as base. Also in currency master > EUR I have ticked EUR to be as reference for traingulation.

Now I'm tring to create a general journal with transaction currency as INR but system immediately gives error as exchange rate between CAD and USD not found. System already has EUR to INR, EUR to CAD and EUR to USD rates so it should be able to derive the rate via traingulation but seems its unable to.

Is my undertanding correct or do I have to do further setup to make this work.

Thanks

Puneet Darji

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

André Arnaud de Cal... 303,667 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hi Puneet,

Your assumption is wrong. You need to have currency pairs starting from CAD, your accounting currency, so: CAD-USD, CAD-EUR, and CAD to INR.

If you would enable triangulation for e.g. EUR, then the amount will be converted using CAD-EUR-USD. This is most likely not what you need.

For CAD and USD as base currency, the Central Bank of Europe provider is not the correct one to use.

Was this reply helpful? Yes No
Suggested answer

Giorgio Bonacorsi 2,013 on at

Like (3)

Report
Copy link

Link copied!

Hi Puneet,

As Andre mentioned, your assumption is incorrect.
In D365FO, you cannot import exchange rates from the EU Central Bank and then use EUR as a triangular currency to automatically calculate rates for other currencies. This is a common challenge in North American implementations.

Here are the two viable alternatives:

- Manual entry

- Enter the exchange rates directly into D365FO via OANDA API for automated rate imports. This requires your customer to have an active OANDA subscription and some custom development to pull and map the rates correctly.

In reality there is even a third option: you can import the exchange rate using the data entity "Exchange rates" if you can find another provide (the API connection is a custom).

Thank you,

Giorgio

1 people found this reply helpful.

Was this reply helpful? Yes No
Puneet Darji 168 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Thank you for the update and providing the understanding. I will work with my team based upon this provided information and find a way.

Was this reply helpful? Yes No