Account/Contact Rollup View for Activities with Dynamics CRM and Dynamics 365
This is another “big” enhancement that I am sure a lot of us had been waiting for. This has now been enabled for Account and Contact Entities.
Ever since Dynamics CRM has been around, you would have seen the activities view in CRM has a drop-down for filtering the view with the following options.
This record only – Shows all activities that have this account/contact set as the regarding.
Related Regarding Records – This was a special filter. This automatically did a rollup of all activities associated with the account/contact. It used the following conditions for selection:
- Activity associated with a child account or contact of the selected record.
- Child Account or contact in the To/From (Activity party) of the activity.
- Activity has the regarding set to an Opportunity, Quote, Order, Invoice, Case and Contract, a limited list of OOB entities.
If you created a custom entity that was parented by the Account or Contact and had activities created against this custom entity, they would not be displayed on the Account or Contact activities view even with the Related Regarding filter enabled.
Can we see them all now?
With this customization level setting, you can now have the activities related to custom entities roll up to the account/contact. A single view of all activity history associated with the parent record.
Event is the custom entity in our example, you can see the activity related to the Event also show up in this view.
How to set this up?
The setting is available for configuration in the relationship settings. For every child record that you have parented with Account or Contact there would be a related 1:N relation created.
You need to change the Relationship behavior to Parental, so that the Rollup View picklist is enabled for editing. Choose “Cascade All” in Rollup View and Publish the customization.
Does it work with other entities?
I wanted to check if the roll-up works for showing up all activities for custom entities. In this example if you see I have a lookup for Parent Event on the Event entity. Each event can have its own set of activities, however if I wanted to check all activities associated with the Event and its child events on the Parent event, that rollup is still locked.
How do I read programmatically?
With the Rollup view set to Cascade All, this request will return all the activities as is seen on the form in CRM.
We have one problem solved with the Rollup View now available for configuration. Hopefully soon we should have this flag enabled for hierarchy entities where we would want a rollup of activities to the parent.