718 Washington Ave. N. Suite #101
Minneapolis, MN 55401
View map and all Locations

Send us a message

In order to maintain an accurate pipeline, it is critical for sales teams is to be vigilant updating opportunity close dates. Luckily, you can easily create a view of past-due opportunities in Dynamics CRM. The diagrams and instructions below will walk you through how to create a view of opportunities to be updated so you have visibility of these important items.


Here we go!

Past-Due Opportunities in Dynamics CRM

  1. Click on Sales in the left navigation of CRM.
  2. Click on Opportunities.
  3. At the top of the screen, select the views dropdown.
  4. At the bottom of the list, select Create Personal View. CRM pops up the Advanced Find window.

  1. Click the Select hyperlink to drop down a list of fields and choose Status
  2. Click on the next drop down and choose Equals
  3. Click on the Look up button and select Open
  4. Click the Select hyperlink to drop down a list of fields and choose Est. Close Date.
  5. Click on the next drop down and choose Last X Years.
  6. Choose the number of years you would like the query to go back. Most businesses will only need to put a 1 or 2 here.
  7. Click Save As and name the view and click OK. You can put in a description if you so desire.

To use the view you just created go back to step 3 and select the view from the My Views section of the drop down. If you feel that your view would bring value to others you can share your view or make this into a system view.

Happy CRM’ing!

Avatar for Joe D365

Joe D365

Joe D365 is a Microsoft Dynamics 365 superhero who runs on pure Dynamics adrenaline. As the face of PowerObjects, Joe D365’s mission is to reveal innovative ways to use Dynamics 365 and bring the application to more businesses and organizations around the world.