Skip to main content
All CollectionsTroubleshootingSalesforce validation errors
Resolving validation errors - "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 (...)"
Resolving validation errors - "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 (...)"

Guidance on cause and resolution to this Salesforce validation error surfacing on 'StandardValueSet' or 'CustomField' metadata

Mateusz Kochanowicz avatar
Written by Mateusz Kochanowicz
Updated over 6 months ago

Explanation of the error

You may come across this Salesforce validation error when deploying StandardValueSet or CustomField metadata types:

"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 above error suggests that there is probably a roll-up summary field (in the source environment) that is using a value from LeadSource in another object.
โ€‹
Finding that roll-up summary field in the source and deleting it can help with successfully validating the deployment package.

It's possible that in this scenario it is the Lead object that needs to be checked, since the error message is referencing this object's StandardValueSet.


Additional guidance

However, if the object in question (e.g. Lead object in which the roll-up summary field may be located) is in the Master-Detail relationship, it's likely that the roll-up summary field will be located in the master object of that relationship.

Based on additional guidance from StackExchange forum, apparently "you cannot create a master-detail relationship in which the User or Lead objects are the master".
โ€‹
So it's worth keeping in mind that in this scenario the roll-up summary field may not be in the Lead object if there's a master-detail relationship created for this object, and the object isn't the master in the relationship.

Resolution

Based on Salesforce's documentation: About Advanced Currency Management, if your org has enabled Advanced Currency Management (this enables multiple currencies in the org), in the source environment you'd need to delete any currency roll-up summary fields using Opportunities and Accounts, or Opportunities and Custom objects.

We hope that the use case we've described above will give you extra information to help with troubleshooting steps you can take to try to resolve this error.

For more information on the issue, please refer to below resource:

Disclaimer: This error is returned directly by Salesforce, rather than Gearset. Even so, we offer guidance based on our combined experience with the Metadata API. Where possible, we try to help guide you to fix or avoid this error. In the case that this isn't possible, we may need to direct you to Salesforce support for further clarification.

Did this answer your question?