You need to sign in to do that
Don't have an account?
Marco Janmaat
validation rule that checks status of synchronized quote
"m trying to write a validation rule whereby when the user closes the opportunity, it checks if a quotation is synchronized and if the status of the quotation is accepted or rejected. Somehow I cannot get it to work. Below my code
AND(CASE(StageName,"Closed Won",1,"Closed Lost",1,0 ) =1, ISBLANK(SyncedQuote.Id), ISPICKVAL(SyncedQuote.Status,"Accepted"), ISPICKVAL(SyncedQuote.Status,"Rejected") )
AND(CASE(StageName,"Closed Won",1,"Closed Lost",1,0 ) =1, ISBLANK(SyncedQuote.Id), ISPICKVAL(SyncedQuote.Status,"Accepted"), ISPICKVAL(SyncedQuote.Status,"Rejected") )
Please use the below formula:
Thanks,
Maharajan.C
All Answers
Can you please explain more. Am not able to understand clearly.
Based on my understanding I have the below formula's. Please try it.
1. On Closing the Opportunity check there is any synced quote and If it is Accepted or Rejected status then throw the error:
2. On Closing the Opportunity check there is any synced quote and If it is not Accepted or Rejected status then throw the error:
Thanks,
Maharajan.C
Thats indeed what I'm looking for.
I added your code under the validation rules of the Opportunity field.
However, it doesn't give any error. When I don't sync the quote it doesn't give a error. It simply accepts closing the opportunity without any error.
Somehow its not working. Any idea?
When I close an opportunity I want it to check:
1) Does the opportunity have a synchronized quotation. If it has no synchronized quotation, It will show error message.
2) Is the status of synchronized quotation, "Accepted" or "Rejected". If its none of both, It will show error mesage.
The idea behind is that account manager firsts let us know if the "quotation" is accepted or rjected, before they close the opportunity .
Please use the below formula:
Thanks,
Maharajan.C