web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Sales forum / Deleting Parent Accoun...
Sales forum

Deleting Parent Account relationship

(1) ShareShare
ReportReport
Posted on by

Hello,

My database contains 500 accounts that have a "Parent Account".

We do not use this feature and it creates issues (unwanted cascading, ownership issues,...).

I want to stop using this field and to delete all the "Parent/Child" relationships between accounts. 

I tried to do that by searching for all the accounts that had data in the field "Parent Account". I clicked on "Modify" but I cannot modify the "Parent Account" field that way.

My other idea would be :

1. To create the following workflow:

==> If the field XXX (XXX being a field I will never use) is modified, then Erase the date in the Parent Account field. 

2. Select the 500+ accounts and modify the field XXX

I think it would work but this would obviously be a strange way to do it.

Is there any "clean way" to do this?

Thank you

Best regards

Vcor

Categories:
I have the same question (0)
  • Verified answer
    David Jennaway Profile Picture
    14,065 on at

    You could create an On Demand workflow that has a step to clear the Parent Account field. You can run this on a page of records at a time (so it's best to set the page size to 250), by selecting all records in a page of a view, and Run Workflow, select your workflow

  • Community Member Profile Picture
    on at

    This is a better idea. Thank you.

  • Suggested answer
    JayBuddhdevtest Profile Picture
    275 on at

    Hi Vcor,

    There are two ways of accomplishing this task:

    1. Create a on demand workflow to clear the field Parent account if it contains data. Use advance find with the query "Parent Account" contains data on Account entity and then run this on-demand workflow after selecting all the records. The limitations for this would need to be performed again and again with the back of 50/250 records.
    2. Create an SSIS package using Kingsway Soft or Task factory, Use Dynamics Crm source to Derived Column and then Dynamics CRM Destination. In Source select account as a target entity and select all fields in column. In derived column create a new column with value NULL. Now in destination select update and then entity as account, in columns all the columns will be mapped from Source look for parentaccountid column and map it with the column you created in derived column. Using this all the records will be updated without manual work.

    There will be no data loss by using any of the above method.

    I hope this helps. Please let me know if you have any questions/concerns.

    Thanks

    Jay

  • CU18100705-0 Profile Picture
    2 on at
    Thank you for answering, you made my day.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Sales

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans