Monday, 23 September 2019

Comparing Values on Parent and Child entity Records in Dynamics 365

Scenario: Parent entity record and child entity record were maintaining a unique value. Due to some technial issues, some child records got generated with a different value other than parent entity record value. The challenge was to find out the records which had a mismatch and then fix them.

Solution:
Created a calculated boolean field on the child entity record.
Formula for calculated field- Set the boolean field if child entity field is not equal to parent entity field value.
Later using advanced find, found out all the records which had the boolean field set. Exported them and updated the right values by referring the parent field value and imported back.

7 comments:

  1. Microsoft Azure

    AZ-203: Developing Solutions for Microsoft Azure
    AZ-300: Microsoft Azure Architect Technologies
    AZ-301: Microsoft Azure Architect Design
    AZ-400: Microsoft Azure DevOps Solutions
    AZ-500: Microsoft Azure Security Technologies
    AZ-900: Microsoft Azure Fundamentals

    Discount Offer! Use this Coupon Code to get 30% OFF BF30

    ReplyDelete
  2. Hello There. I found your blog using msn. This is a really well written article. I will make sure to bookmark it and come back to read more of your useful information. Thanks for the post. I will definitely return.
    computer networking services

    ReplyDelete