+ Start a Discussion
Santosh KSantosh K 

Need Urgent help - Related Lookup Filters

Hi All,

Needed one urgent help !!

While debugging an issue, I found there is an exception thrown in the debug logs for an Opportunity:

System.DmlException: Update failed. First exception on row 1 with id <<OPPORTUNITY ID>>; first error: FIELD_FILTER_VALIDATION_EXCEPTION, Value does not exist or does not match filter criteria.

Then I further checked - Related Lookup Filters associated with the Opportunity.

The Filter Criteria was -

XYZ : Account Name ID EQUALS Opportunity: Account Name ID

where XYZ is a REQUIRED LOOK UP field to the Opportunity.

Can anyone explain as what this filter criteria means. This would be really helpful.

Thank you!

S Kumar
Best Answer chosen by Santosh K
Shivanath DevnarayananShivanath Devnarayanan
It means, the account ID on XYZ should match the Account Id on opportunity 

All Answers

Shivanath DevnarayananShivanath Devnarayanan
It means, the account ID on XYZ should match the Account Id on opportunity 
This was selected as the best answer
amidstcloudamidstcloud
Hi S Kumar,

It seems like you have two Account lookup on the opportunity. 

1) Account 
2) XYZ.(Account Lookup)
'"
And there is filter on Account which say ..  Account must be the same as you have in XYZ.  if XYZ refers to "Test account".. you have to select the same in XYZ also.

Regards
Ankit

Santosh KSantosh K
Thank you so much Shivanath and Ankit for helping me out!

Have a great day!

Regards,
S Kumar