{"id":4315,"date":"2017-01-17T16:21:58","date_gmt":"2017-01-17T10:51:58","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=4315"},"modified":"2022-07-21T12:14:47","modified_gmt":"2022-07-21T06:44:47","slug":"configure-rollup-view-for-activities-with-dynamics-crm365","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2017\/01\/configure-rollup-view-for-activities-with-dynamics-crm365\/","title":{"rendered":"Configure Rollup view for activities with Dynamics CRM\/365"},"content":{"rendered":"

Introduction:<\/strong><\/p>\n

This is another \u201cbig\u201d enhancement that I am sure a lot of us had been waiting for. This has now been enabled for Account and Contact Entities.<\/p>\n

Ever since Dynamics CRM has been around, you would have seen the activities view on CRM has a drop-down for filtering the view with the following options.<\/p>\n

This record only \u2013 Shows all activities that have this account\/contact set as the regarding.<\/p>\n

Related Regarding Records \u2013 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<\/p>\n

    \n
  1. Activity associated with a child account or contact of the selected record.<\/li>\n
  2. Child Account or contact in the To\/From (Activity party) of the activity.<\/li>\n
  3. Activity has the regarding set to an Opportunity, Quote, Order, Invoice, Case and Contract, a limited list of OOB entities.<\/li>\n<\/ol>\n

    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.<\/p>\n

    Can we see them all now?<\/strong><\/p>\n

    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.<\/p>\n

    \"Configure<\/p>\n

    Event is the custom entity in our example, you can see the activity related to the Event also show up in this view.<\/p>\n

    How to set this up?<\/strong><\/p>\n

    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.<\/p>\n

    In this example we created a simple Event entity with a Customer type of attribute and Activities enabled.<\/p>\n

    \"Configure<\/p>\n

    To have the activities associated with Event show up on the Account view, we go ahead and edit the account-event relationship.<\/p>\n

    \"Configure<\/p>\n

    Let us edit the edit the new_account_new_event_customer relationship.<\/p>\n

    \"Configure<\/p>\n

    You need to change the Relationship behaviour to Parental, so that the Rollup View picklist is enabled for editing. Choose \u201cCascade All\u201d in Rollup View and Publish the customization.<\/p>\n

    Prior to this change the activities associated with Event1 did not show up on account.<\/p>\n

    \"Configure<\/p>\n

    After the change, we see them as shown in the first screenshot above.<\/p>\n

    Does it work with other entities?<\/strong><\/p>\n

    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.<\/p>\n

    \"Configure<\/p>\n

    How do I read programmatically?<\/strong><\/p>\n

    Rollup Request<\/a><\/p>\n

    With the Rollup view set to Cascade All, this request will return all the activities as is seen on the form in CRM.<\/p>\n

    Conclusion:<\/strong><\/p>\n

    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.<\/p>\n

    70% of global 2000 companies apply gamification to improve productivity and returns!<\/div><\/div><\/h2>\n

    Gamifics365<\/a> <\/strong>\u2013 Spin the magic of games within Microsoft Dynamics 365 CRM to improve user adoption, enhance productivity, and achieve company goals!<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

    Introduction: This is another \u201cbig\u201d 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 on CRM has a drop-down for filtering the view with the following options.\u2026 Read More: Configure Rollup view for activities with Dynamics CRM\/365 »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":4321,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,16,19],"tags":[326,327,1487,1488],"class_list":["post-4315","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-customizations","category-dynamics-365","category-dynamics-crm","tag-configure-rollup-view","tag-configure-rollup-view-for-activities","tag-rollup-view-dynamics-365","tag-rollup-view-dynamics-crm"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t