I am trying to update a field to show 4 decimal places. The field is a custom field and is a Formula(Currency). Other fields like this I went in changed it from 2 decimals to 4 with no problem. This last field is giving me this error
[There were custom validation error(s) encountered while saving the
affected record(s). The first validation error encountered was "One of
the objects selected for your roll-up summary uses dated exchange
rates and the other object does not. Roll-up summary fields can only
summarize values of currency fields if both objects convert values or
both objects do not.".]
The formula in the field is IF(Contract_Term__c = 0,0,Amount / ROUND(Contract_Term__c,0)
)
1) Not sure why it is talking about dated exchange rates we only have a single one active and no historical ones entered.
2) Not sure why it is talking about a Roll-up it is just a calculated field
3) I can't find any Roll-ups that even reference this field.
Best Answer
I'm going to hypothesize that
Opportunity
as the fieldamount
is referencedOpportunityLineItem
but some custom objectOnce dated exchange rates are enabled, they apply to the Opportunity, OpportunityLineItem, and a handful of other objects. They do not apply to custom objects. See doc
Hence, the RSF on Opportunity against some child Detail object will fail with the error you noted
Also from the doc:
Dated exchange rates are very useful on Opportunities but only if you have more than one currency enabled.