Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Currency triangulation...
Finance forum

Currency triangulation and denomination daily update

(1) ShareShare
ReportReport
Posted on by 12

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

  • CU24061339-0 Profile Picture
    CU24061339-0 4 on at
    Currency triangulation and denomination daily update
    Dear all,
     
    I'm facing the same problem as the one described above. In 2024, is it still not possible to do a SEK-EUR-NOK triangulation on floating rates based solely on the EBC?
     
    Thanks
    Thomas
  • kreeps989 Profile Picture
    kreeps989 12 on at
    RE: Currency triangulation and denomination daily update

    Clear to me André, appreciated your clarification and the small customization idea.

    Thank you

  • kreeps989 Profile Picture
    kreeps989 12 on at
    RE: Currency triangulation and denomination daily update

    Hi Ludwig,

    My problem is that ECB only provides rates vs EUR and my company has ECB as fx source.

    When posting/generating invoices in SEK, USD, GBP I need the conversion between SEK (invoice curr) & NOK (accounting curr) which does not exist as a such in the system.

    Of course, I could take it from other sources (like Norges bank) but then fx will be a mixture of sources.

    Thanks!

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,791 Super User 2024 Season 2 on at
    RE: Currency triangulation and denomination daily update

    Hi,

    In the past, we did create a customization for another customer which was called "cross-rates". This feature could calculate and update the currency pairs. It was a customization in AX 2012. Using the blog from Ludwig, you can use the exchange rates provided by the ECB and make a calculation automation in e.g. Excel. Then import the rates. Or consider a similar customization as we did before.

    PS, like Ludwig mentioned, don't use the triangulation here.

  • Verified answer
    Eugen Glasow Profile Picture
    Eugen Glasow 6,355 on at
    RE: Currency triangulation and denomination daily update

    Yes, this is what we did in Norway: prepared a [monthly] Excel file, calculated cross rates there and imported all possible pairs.

  • kreeps989 Profile Picture
    kreeps989 12 on at
    RE: Currency triangulation and denomination daily update

    I assume that the better option is to create all pairs as such (ie. NOK-USD, NOK-SEK, NOK-GBP.. ) and maintain them manually.

    A modification to calculate the rates could also be an option.

    Denomination is definteively not intended for those floating rates and would also need manual maintenance. Moreover will cause problems in case of backdated postings.

    Thanks for your answer Eugen

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Currency triangulation and denomination daily update

    Hi,

    Why do you use the triangulation feature?

    The FX rates NOK to EUR are floating and not fixed.

    I don't think that the triangulation feature is right here.

    If you want to import other currency pairs then check out the following post

    dynamicsax-fico.com/.../import-exchange-rates

    Best regards

    Ludwig

  • Verified answer
    Eugen Glasow Profile Picture
    Eugen Glasow 6,355 on at
    RE: Currency triangulation and denomination daily update

    Yes, it used to work differently in versions prior to AX2012.

    Now you declare one currency a Triangulation currency, and the "denominated" currencies are tied to this currency through a fixed exchange rate. This is true for DKK which has a fixed conversion rate through the ERM II mechanism, but DKK only and no other currency:

    docs.microsoft.com/.../2-set-up-currencies-conversions

    There was a similar discussion: community.dynamics.com/.../denomination-currency---exchange-rate-type

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,791 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,488 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans