Dynamics Community Forum Thread Details

Currency Base Field Precision

Hi all

I'm having an issue with multi-currency setup and a roll-up field and it's due to exchange rate conversions and the face the Base value is only being stored to 2 decimal places. I know that my problem would be solved if it was stored to 4 decimal places, but I can't seem to get it to do so. Using CRM 2016 On-Prem.

My roll-up field sums the amount value of child records. It should equal $100,000 AUD. However, the roll-up field is returning $99,999.99. This is why:

Exchange rate is 1.6426000000. When I refresh the field, CRM is obviously summing up my child fields and getting $100,000 and then populating the Base field on my parent entity by dividing it with the exchange rate, and then rounding it to 2 decimal places, giving £60,879.09. This is what I can see in the database. The local currency roll-up field is then doing the reverse and taking the base value and multiplying by the exchange rate, giving $99,999.9932 - explaining what I can see in the front-end.

If CRM was storing the base value to 4 decimal places, it would be £60,879.0941, which when multiplied by the exchange rate would give me my $100,000.00!

So, any idea how I can get the Base field for a roll-up field to store values to 4 decimal places rather than 2? I have set the roll-up field itself to be 4 decimal places and I can see that the non-base column is storing to 4, but the base continues to be just to 2... I've also tried setting currency precision on AUD and GBP to 4 decimal places but that didn't solve the issue either.

Thanks!

Quick Links

Leaderboard