Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Field inheritance in account hierarchy

Posted on by 110

Hello,

I have an account which have sub accounts. There are single line text field  which should be inherited to all accounts related to parent account. How I can do this?

Thanks.

  • LuHao Profile Picture
    LuHao 40,872 on at
    RE: Field inheritance in account hierarchy

    Hi Tuomas,

    Do you just want to inherit the value to the sub account once (when create), or do you want to keep the fields updated?

    If the value is inherited only once when create sub account, then I recommend using the field mapping or workflow.

    1. Field mapping for relationship.

    https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/map-entity-fields

    https://www.marksgroup.net/blog/dynamics-365-mapping-fields/

    Advantage: Effective immediately, you can see the value on the form before the new record is saved.

    Disadvantage: It only works when creating a new record from the related record form. It will not work when creating new records outside the form.

    2. workflow

    https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/workflow-processes

    https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/configure-workflow-steps

    Select the scope you want to trigger this workflow and check ‘Record is created’.

    pastedimage1578988286332v1.png

    In the update form of the workflow, use the Form Assistant to set the field values. Under 'Look for', the first selects Parent Account (Account) and the second selects the corresponding field.

    pastedimage1578988534338v2.png

    Advantage: No matter how you create a new sub account, as long as there is an parent account, this workflow will be triggered.

    Disadvantage: The workflow is triggered when you click the Save button of the create form. Until then, you cannot see the value of the field.

     

    If you want to keep the sub account fields updated based on the parent account, then I recommend you using flo, workflow tool or write plugins.

    1. Flow

    https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Update-Child-Records-in-Dynamics-365-CE-using-Microsoft-Flow/ba-p/176291

    https://www.cloudfronts.com/update-child-records-when-parent-record-is-updated-using-microsoft-flow-for-d365-ce/

    2. workflow tool

    https://github.com/demianrasko/Dynamics-365-Workflow-Tools/blob/master/docs/Update%20Child%20Records.md

    https://www.encorebusiness.com/blog/update-child-records-in-a-onemany-relationship-in-dynamics-365-customer-engagement/

  • erhan.keskin Profile Picture
    erhan.keskin 2,247 on at
    RE: Field inheritance in account hierarchy

    Hi,

    I assume you want to copy that field to the sub accounts.

    - You can use the mapping of the relationship between accounts.

    - You can use WF to populate the fields

    - You can use Plugin to populate the fields

    Regards,

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: Field inheritance in account hierarchy

    Hello,

    I believe to have you will need to develop something custom either using plugin/workflow/flow - when this "inherit" field is changed - change has to be distributed across all children records.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans