Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Exchange Rate issue in...
Microsoft Dynamics CRM (Archived)

Exchange Rate issue in a Rollup Field

(0) ShareShare
ReportReport
Posted on by Gabriel Rustice 10

Hi All,

We've recently updated our Exchange Rates (which by the way, we set up to change all historical records, instead of the standard CRM rule to preserve the past records). So far so good.

What is weird is that in one of our Rollup Fields we have under the Contract Entity, that sums up all related products, is having a weird behavior.  It only happens with one Currency (USD), although we have (and changed the exchange rate of) 5 different currencies. 

Sometimes, the Rollup Field behaves normally. It means that if I add a product line of 1 USD, then the Rollup Field will be 1 USD. However, other times if I add a product of 1 USD, the Rollup is becoming 1.04 USD. So it is always multiplying by X 1.04. What is nonsense to me is that, in these cases, both the Contract and the Products are in USD.

32175.Untitled.png

Does anyone has ever had anything similiar? My guess is that the exchange rate has some relation with it, because it is happening since we updated them.

Thanks

*This post is locked for comments

  • minohimself Profile Picture
    minohimself 2 on at
    RE: Exchange Rate issue in a Rollup Field

    I have the same issue but in my case its cause by Default currency exchange rate. Somehow we manged to have default currency exchange rate != 1 and when the system recalculates even if its the same currency to the same currency hes using this exchange rate and from my 1000e on child entity there is 1069e on my parent (rollup field)

    I'll see if i can update the currency exchange rate through sdk.

  • RGBeauchemin Profile Picture
    RGBeauchemin 55 on at
    RE: Exchange Rate issue in a Rollup Field

    What you are describing is also an issue, but a different issue than what I was raising.

    In addition to what you describe, if opportunities exist through a number of subsequent FX changes (some of our sale cycles last several months) and various Opportunity-Product records are updated individually through time, the Opportunity-Product records end up with different FX rates and different than the parent opportunity.  To difference in roll-up field can take significant proportions, measured in 10's of dollars, or even 100's of dollars.

    And we cannot ask our 100+ sales folks to keep update their 10's of opportunities, each containing 10+ opportuniry-product records.

    This is a major design flaw of MS-CRM that dates back to CRM4 (at least)

  • RGBeauchemin Profile Picture
    RGBeauchemin 55 on at
    RE: Exchange Rate issue in a Rollup Field

    It appears to be a recognized issue tha Microsoft finds "normal"

    We have raised a ticket with Microsoft and filled a Change Request.

    We will escalate to the highest degree.

  • Antbutcher Profile Picture
    Antbutcher 387 on at
    RE: Exchange Rate issue in a Rollup Field

    Thanks, but your solution is different to the problem we are experiencing, there is no difference to the exchange rates.  It appears to me a bug in Dynamics where the base currencies are set to a different decimal place precision than the normal currencies meaning we are  .1 out when the rolllup calc is performed.

  • Gabriel Rustice Profile Picture
    Gabriel Rustice 10 on at
    RE: Exchange Rate issue in a Rollup Field

    Yes, I did. Check out my previous post with the solution.

  • Antbutcher Profile Picture
    Antbutcher 387 on at
    RE: Exchange Rate issue in a Rollup Field

    beauchee, 

    We are experiencing the exact same issue, opportunity and opportunity products both in USD. However, our roll up fields are calculating 1 cent out. For example USD32,000 becomes USD32,00.01.  It must be using the base currency to perform the roll up field which I find strange as if we change the exchange rate and recalculate the roll up field value changes but always calculates a cent out. 

    Did you ever resolve this issue?

  • Gabriel Rustice Profile Picture
    Gabriel Rustice 10 on at
    RE: Exchange Rate issue in a Rollup Field

    I finally found out what was causing the issue.

    It was in fact what I suspected from the beginning: the Exchange Rate. 

    After we updated our Exchange Rates, the records created prior to the change were acting weird because they were using the old exchange rate to convert money fields to the BASE currency fields. And then when rolling up to the Parent entity, they were using the new Exchange rate. 

    So that means, we just needed to update the all currency fields, but in our case, the ones inside the child entity that were misleading the calculations.

    Thanks everyone,

    Gabriel

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Exchange Rate issue in a Rollup Field

    I have the same issue.  My home currency is USD

    I have no issue with rolling-up currency amount fields from the children (Opportunity-Product) records in the Opportunity records when they are in USD.

    When the opportunity is in a non-home-currency, then the totals may (randomly) have +-0.01 difference than the real total.

  • Gabriel Rustice Profile Picture
    Gabriel Rustice 10 on at
    RE: Exchange Rate issue in a Rollup Field

    I've tried that and didn't work either.

    I wonder if there could be any relation to the currency mapping as I am working with a child CUSTOM entity. But I really don´t know, it is super odd that sometimes the calculation works normally and sometimes not. I couldnt figure out a pattern yet.

    Maybe a ticket with MS as Prashant Shukla suggested can be the way to go.

  • Verified answer
    PS Profile Picture
    PS 23,577 on at
    RE: Exchange Rate issue in a Rollup Field

    I would suggest you to open a ticket with Microsoft

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans