You need to sign in to do that
Don't have an account?
Mac Swift
Validation rule for Opportunity Line Item
Hi FOLKS,
I have a requirement in my Organization where I need to make a custom Field Mandatory on Opportunity, if there is word "ABC" and "XYZ" in the product name (in the Product ine Item). I have one more issue here - most of the time the Quotes are not synced to the Opp by the Sales rep.
Please help me to resolve the issue.
Thanks in Advance,
Mac
I have a requirement in my Organization where I need to make a custom Field Mandatory on Opportunity, if there is word "ABC" and "XYZ" in the product name (in the Product ine Item). I have one more issue here - most of the time the Quotes are not synced to the Opp by the Sales rep.
Please help me to resolve the issue.
Thanks in Advance,
Mac
You have to use the following validation rule,
CONTAINS(Product , "abc") && CONTAINS( Product , "xyz")
where product is your product line item field name.
You may have to update to reflect actual names of your fields.
Regards,
Roshni
Sorry for not being so clear with my requirement. Actually its gonna be cross object Validation rule. As I want to check the Opportunity line Item - if there is "ABC" word into the Product Name ( in Opportunity line Item). If Yes, Sales rep will not be able to change the Opportunity Stage to "Purchasing", until the Custom field "Reason" is not be populated.
Not sure if this can be done with the help of Validation rule or the Workflow.
Looking forward for the expert guidance.
Mac