Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Deleting CustomerAddress entity records

(0) ShareShare
ReportReport
Posted on by 2

Hello,

Is there any way to delete customeraddress entity records. We have more than 380K contacts and due to that more than 1cr customer address records

Now these customer address records are consuming more than 6 GB space. These records are not require at all in instance. 

Please suggest method to delete these all address records.

Thanks in Advance

Rutul

*This post is locked for comments

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,325 Most Valuable Professional on at
    RE: Deleting CustomerAddress entity records

    Rutul,

    I'm afraid you will not be able to delete addresses. Just FYI all the fields prefixed address1_ and address2_ in account and contact entity are stored in customeraddress table. It's undeletable.

  • Suggested answer
    gdas Profile Picture
    gdas 50,089 on at
    RE: Deleting CustomerAddress entity records

    You should remove the association of those address  first where the dependency found using bulk edit or using workflow  and then proceed with bulk deletion.

  • Rutul Chauhan Profile Picture
    Rutul Chauhan 2 on at
    RE: Deleting CustomerAddress entity records

    Bulk delete job is not working for this type of record. even when i tried to delete single record, it shows dependency error and hence i cannot delete the same.

    I need alternate idea on how to delete the same

  • Suggested answer
    Dynamics365 Rocker Profile Picture
    Dynamics365 Rocker 7,755 on at
    RE: Deleting CustomerAddress entity records

    You have to create a bulk delete job as suggested by Gampi.

  • Gampi Reddy Profile Picture
    Gampi Reddy 85 on at
    RE: Deleting CustomerAddress entity records

    Hello,
    You may use OOB Bulk deletion process . Like this :-

    1.Go to Settings > Data Management.

    2.Choose Bulk Record Deletion.

    3.Choose New to run the Bulk Deletion Wizard to create a bulk deletion job with the records you want to delete.

    and also there is one more way to do with code .. I am attaching like here please go through it

    docs.microsoft.com/.../sample-bulk-delete-exported-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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans