Dynamics 365 Parent Child Account Relationship Configuration – Part 1

Let’s discuss a business case, there are organizations which own multiple businesses. As a customer relationship manager, Dave wants to perform below tasks.

  • See all child accounts for a particular organization in a sub grid
  • View the number of child accounts for a specific account – use this field for creating filters/ customer journeys etc ( i.e. Send an email to organizations with more than three child accounts)

First, we need to see the out of the box functionality dynamics provides for this scenario.

Out of the box “Account” main form provides the “Parent Account” lookup field.

This field uses the relationship : account_parent_account

Let’s review this relationship:

It shows that parent account has 1: N relationship with child accounts. Meaning, one parent account can have multiple child accounts.

The relationship is hierarchical and any change you do to parent account will cascade through to child accounts. However, when you delete the parent account, it will remove parent link from all child accounts.

Now that we have understood the relationship behavior, let’s again look at each requirement.

  1. Create sub grid to show all child accounts.

Go to Account main form. Add Component > 1 Column Tab and we can name this “Child Accounts”

Now, add a Subgrid and select Accounts(Parent Account) as the entity. Then select “Active Accounts” as the default view.

Make sure to check the “show related records” check box

It should now add the Child Accounts grid to this tab.

Save > Publish and let’s test this.

Add parent account:

View the Child Accounts tab for ” Adventure Works”

Now Dave is able to see the child accounts for any account in the account form. Our goal in this whole exercise was to provide relationship manager with a better experience by having all account related information in one place.

In the next post let’s discuss how to configure a roll up field that will show the number of child accounts for an account. Then we can discuss useful scenarios for this roll up field.

Happy Learning!



Categories: Dynamics 365

Tags: , , , ,

3 replies

  1. Hi Kaushal, thank you for the valuable post. Just a continuation of this requirement, suppose we need to display this child accounts sub grid on another entity like ‘opportunity’ so the requirement would be to display all child accounts related to the account for which the opportunity is created on a subgrid on opportunity form, how do we achieve this?

    I already have the child account view for account entity on the parent account form and its working fine I tried adding the same view to the opportunity form but its displaying all accounts instead of the child accounts corresponding to the account for which the opportunity is created.

    We dont have the option to select Accounts(Parent account) as the entity for the lookup when adding it on opportunity form.

    Do we need to create additional relationship? Thank you for your advice!

    Like

Trackbacks

  1. Dynamics 365 Parent Child Account Relationship Configuration – Part 2 – PowerPlatform Solutions

Leave a Reply to Kaushal Kodagoda Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: