Close Opportunity if all related Quotes are closed (won/lost)

(0) Share

Report

Posted on by SR11

Hi there,

Users have the option to close the opportunity if they are closing the last quote on it. Occasionally, users do not select the option to close the opportunity leaving us with a lot of open opportunities. I would like to create a workflow or flow to automatically close an opportunity if the last quote on it is closed. Cannot think of a way to start on this request. Any insight would be helpful.

Thanks in advance.

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hello,

To do that in workflow you will have to write some code.

With flow you have no need in code. Here is approximate flow design:

1. Flow starts when quote changes state to "Closed".

2. Flow uses "Retrieve Records" for quotes with filters by parent opportunity equal to opportunity of the quote that triggered flow to start and state that is equal to open.

3. You add a "Check" statement where you check the length of collection you received on the previous step - if it is equal to 0 ( that means that there are no opened quotes for this opportunity).

4. If 3 is true - then you just update the state of opportunity to won.

Good luck.

Was this reply helpful? Yes No
Verified answer

PS 23,577 on at

Like (0)

Report
Copy link

Link copied!

Hi There

I agree with Andrew's Flow suggestion and the steps would be more or less same.

If you want to use workflows, no code is involved and the following screenshot will help you:

Was this reply helpful? Yes No
Suggested answer

ashish12 3,079 on at

Like (0)

Report
Copy link

Link copied!

Using MS Flow is the best way to do it.

Was this reply helpful? Yes No
SR11 54 on at

Like (0)

Report
Copy link

Link copied!

Thank you for pointing me in the right direction. I was able to use MS Flow to accomplish this.

Was this reply helpful? Yes No