Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

To Custom Entity or Not

Posted on by

Hi All,

Hope you're having a lovely day!

My organisation has several teams and projects each with different data fields that they want to collect against accounts (organisations) and contacts. Importantly, the structure of the organisation can change drastically based upon external funding, so teams and projects can be created or ceased meaning that the needs can change drastically.

Traditionally when they had additional fields they would add them to the Contacts entity or Accounts entity (a big no-no as it means those tables grow enormously). Aside from capturing this information outside the CRM, I've been wondering if there was a way to meet this need in the CRM. The best idea I have so far is developing custom entities specifically for the the team's needs that we can hide later on (using security settings) if the team changes or project ends. From my limited understanding, it should be possible to link the custom entity to a contact or account record using a connection so we can ensure that the information is linked to the account in some way (I'd imagine it would only need to be a one-to-one relationship in most cases).

I'm open to other ideas on how to address this need if anyone has any advice?

Thanks,

Andrew J.

*This post is locked for comments

  • Verified answer
    Hari Narayanan Profile Picture
    Hari Narayanan 589 on at
    RE: To Custom Entity or Not

    I would suggest to go with custom entity, unless you can re-use contact and account fields fully. Most of the projects which i have worked on use just account name and account address which would affect database size since both this entities have a lot of OOB fields. and as you mentioned drastic changes to the records and too many records are not a good option so any transaction must be kept in a seperate entity. you can relate the entities directly to account rather than a relationship (buit it entirely depends on your project specifications.

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

Featured topics

Product updates

Dynamics 365 release plans