Skip to main content
Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

How to bulk close open business opportunities?

(0) ShareShare
ReportReport
Posted on by

Hi!

I've started in a new role, and my predecessor have left a lot of old business opportunities open. 
my intension is too clean up a bit, and I want to close all the opportunities that are more than two years old. 
Is there a way to do this all in one go, or do I have to close them individually?

  • LuHao Profile Picture
    40,888 on at
    RE: How to bulk close open business opportunities?

    Hi partner,

    Please don't forget to click Yes under "Did this answer your question?" to close this thread.

    Thanks. 

  • Verified answer
    LuHao Profile Picture
    40,888 on at
    RE: How to bulk close open business opportunities?

    Hi partner,

    We will create a new personal Opportunity view to list all the opportunities that are more than two years old, then create a on-demand workflow to bulk close them.

    Step 1. In the Opportunity view, click Create view button.

    pastedimage1587978775236v1.png

    Select the filter to Create On, Order Than X Years, 2. Save it.

    pastedimage1587978908958v2.png

    Step 2. Go to Settings > Processes, new a workflow of Opportunity.

    pastedimage1587979003328v3.png

    Select As an on-demand process, Organization. Add Step - Change Status, select the status to Out-Sold. Activate it.

    pastedimage1587979144775v4.png

    Step 3. In the personal view, select all records, click Flow > the workflow. Then the selected Opportunities will be closed.

    pastedimage1587979259215v6.png

    If there are multiple pages of records, run the workflow once per page.

    If the number of pages is very large, then I recommend that you use XrmToolBox's "Bulk Workflow Execution" tool to run workflows in batches.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Now Available: 2025 Release Wave 2

Quick Links

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Holly Huffman Profile Picture

Holly Huffman 103

#2
Muhammad Shahzad Shafique Profile Picture

Muhammad Shahzad Sh... 96 Most Valuable Professional

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 51 Most Valuable Professional

Product updates

Dynamics 365 release plans