Exchange Rate issue in a Rollup Field

(0) Share

Report

Posted on by Gabriel Rustice

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

I have the same question (0)

All responses (15)

Answers (1)

Yadnyesh Kuvalekar 4,102 on at

Like (0)

Report

Can you share formula you are using in your rollup field?

Also which is your organisation base currency? It would be great if you can send screenshot of USD currency record.

Was this reply helpful? Yes No
Yadnyesh Kuvalekar 4,102 on at

Like (0)

Report

Hi,

Roll up field works perfectly without any issues on different currencies. Can you check the currency selected on the parent record (on which you have roll up field)? And also, check the currencies selected on the child records. It should calculate the amount properly.

There seems to be some issue in your calculation which you are comparing with rollup field's calculation. Request you to revalidate and if still facing an issue, request you to share screenshots with an example.

Was this reply helpful? Yes No
Gabriel Rustice 10 on at

Like (0)

Report

Thanks, Yadnyesh Kuvalekar

The formula is quite simple. Here is a screenshot.

Also, here is a screenshot of the Currencies. Our default currency is CAD. The issue happens only with USD.

I'm not sure if the currency is the issue, but again...it started happening right after we updated them.

Was this reply helpful? Yes No
Gabriel Rustice 10 on at

Like (0)

Report

The currency from the parent record is the same as the child ones. It only happens with USD.

Was this reply helpful? Yes No
Suggested answer

Yadnyesh Kuvalekar 4,102 on at

Like (0)

Report

Hi Gabriel,

When exchange rates are changed, it does not get applied to existing records until any currency field gets updated on the record. So, there might be chances that your records have old exchange rates on the old record and rollup field might be considering new rates. Can you please check if you are facing issuefor new records as well? If not, then please try below steps:

1. Open existing record where you're facing issue.

2. Update any amount field and save the record. Now manually refresh roll up field and check if you are seeing correct amounts. If so, then you will need to update at least a sinlge amount field on existing records to get correct data.

Was this reply helpful? Yes No
Verified answer

PS 23,577 on at

Like (0)

Report

I would suggest you to open a ticket with Microsoft

Was this reply helpful? Yes No
Gabriel Rustice 10 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Gabriel Rustice 10 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Antbutcher 387 on at

Like (0)

Report

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?

Was this reply helpful? Yes No