Currency exchange rate decimals

(0) Share

Report

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.

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)

All responses (4)

Answers (0)

Sort by

André Arnaud de Cal... 305,150 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
André Arnaud de Cal... 305,150 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Andre,

We did, thanks for the input non the less.

Kind regards,

Jaco

Was this reply helpful? Yes No