Everyone wants to know which of their accounts have not been followed up recently. But using the Neglected Accounts report is just sooo 1995. Nobody uses reports anymore – we want everything as a view, chart or dashboard! But until the most recent release of Dynamics CRM, the only way you could create a Neglected Accounts view was thru installing add-on products or developing code.
Well, my friends, those days are gone forever. Welcome to the second half of 2015, where your all of your neglected account dreams come true!
Here’s the simple process for creating a neglected account view:
1. Create a Rollup Field
Create a rollup field that rolls up the maximum Actual End date of all closed activities (including activity party activities) for the account. See the image below (you can click the image to zoom in).
2. Create a Calculated Field
Now create a calculated field that calculates the number of days that have elapsed since the maximum activity end date that you calculated above. See the image below.
3. Create a View
Now create a view using whatever number of days you want to neglect your accounts before they show up in the view. You guessed it … see the image below.
4. Get Fancy
But wait … there’s more! You can have different thresholds for neglectation (new word that I just invented). For example:
Don’t forget to do an analysis to show how all of your A accounts change their phone number and never return any calls! :)
You can apply the same principle to your leads, contacts and opportunities.
Now go out and start to make sure that those really important accounts get the harassing attention that they deserve!
The complementary paper includes over 12 years of research, recent survey results, and CRM turnaround success stories.
This 60-second assessment is designed to evaluate your organization's collaboration readiness.
Learn how you rank compared to organizations typically in years 1 to 5 of implementation - and which areas to focus on to improve.
This is a sandbox solution which can be activated per site collection to allow you to easily collect feedback from users into a custom Feedback list.
Whether you are upgrading to SharePoint Online, 2010, 2013 or the latest 2016, this checklist contains everything you need to know for a successful transition.