web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Currency exchange rate...
Finance | Project Operations, Human Resources, ...
Unanswered

Currency exchange rate decimals

(0) ShareShare
ReportReport
Posted on by Community Member

Hi Community,

We are currently running on D365FinOps PU38.

Our main goal is to restrict the exchange rate decimals to 4 (x,xxxx), trough out the application. Standard D365 will take the exchange rate and revert it to a 12 decimal value in the journal. For example if my exchange rate is 1.0755 CHF for 1 EUR. When you create a CHF voucher, D365 will do the following; 1/1.0755 = Exchange rate with 12 decimals (It will do the opposite for EUR to CHF). See below.

pastedimage1612976410215v2.pngpastedimage1612976419219v3.png

We have a lot of entities and other applications in our organization. All the other applications are restricted to 4 decimals, and only D365 is creating a difference in the amounts when we consolidate all the applications. Currently we manually correct the amounts outside of D365, before consolidation.

Out of experience I know you do not mess with decimals and rounding, but was just curious if anyone saw this in practice. Thanks in advance.

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Currency exchange rate decimals

    Hi Andre,

    We did, thanks for the input non the less.

    Kind regards,

    Jaco

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 297,483 Super User 2025 Season 2 on at
    RE: Currency exchange rate decimals

    Hi Jaco,

    I understand the example now. Have you tried to setup 'cross rates' within the same exchange rate type?

    E.g. one record with currency pair EUR > CHF and one with CHF > EUR?

  • Community Member Profile Picture
    Community Member on at
    RE: Currency exchange rate decimals

    Hi Andre,

    Thanks for the response. Yes, it is rounding the amount, but the issue is the rate in the journal needs to round to 4 decimals.

    Accounting Currency = EURO

    Transactional Currency = CHF

                                                                       Exchange Rate Imported       Rate used in journal                         Accounting Currency Amount

    D365FO       CHF 100.000.000,00             1.0755 CHF for 1 EUR           1/1,0755 = 0,908925649882            EUR 90.892.564,99  (100.000.000,00 x 0,908925649882 )

    Other ERP   CHF 100.000.000,00             1.0755 CHF for 1 EUR           1/1,0755 = 0,9089                            EUR 90.890.000,00 (100.000.000,00 x 0,9089 )

                                                                                                                                                                              -EUR 2.564,99 Diff

    I have the feeling from your response this is quite unique and I am very sceptical if this can be solved.

    Kind regards,

    Jaco

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 297,483 Super User 2025 Season 2 on at
    RE: Currency exchange rate decimals

    Hi Jaco,

    I have not heard your requirement before. Dynamics 365 is applying a rounding on the converted amounts to two decimals. Do you have real different amounts due to the exchange rate calculations? I can imagine it would be per amount a maximum of 1 cent? Can you provide some examples where the amounts are really wrong?

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 756 User Group Leader

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 629 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 514 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans