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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Account addresses with...
Microsoft Dynamics CRM (Archived)

Account addresses with multiple locations

(0) ShareShare
ReportReport
Posted on by Nikolas_

Hello everyone,

I try to understand the best way to work with multiple locations in the account-entity. 

We have to manage several accounts with multiple locations. However, I don't want to add several sub-accounts as all the opportunities, addresses and so on should be managed and seen in one place. I also would like to have the option to choose a location (address) for each contact that works in the respective company without having duplicates stored in the contact-entity. That way, I only would need to update one record if a location changes.

What is the best practice to handle that requirement?

Thank you in advance and best regards!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    prt33k Profile Picture
    prt33k 6,907 on at

    Hi Nikolas,

    Address is a child record for customer entity. So you can only have a account or a contact as parent record.

    Also, address entity doesnt allow any custom relationship to be created on it so nothing much can be done there either.

    So one option will be to create a custom address entity and have two relationship on it for account and contact - N:1 with account while N:N with contact.

    This way you will have multiple address associated with Account and user can select any of those address for the contact records.

    However, when you use custom address instead of OOB address - you might loose certain OOB feature and increase customization so do consider that..

  • Nikolas_ Profile Picture
    Nikolas_ on at

    Hi prt333,

    thank you for your reply.

    I think I found a solution for my first need, to display various locations for one account. I added a subgrid to the account-form to display all addresses I want to store.

    If I understand you correctly, I can't link the address from a contact to an account as address is a child record. Would it be a possible and suitable to define the address for contacts as read-only and to copy the address of a location using a workflow? I really don't want to have duplicates in the system and looking for a way to achieve that.

    Thank you and best regards

  • Suggested answer
    prt33k Profile Picture
    prt33k 6,907 on at

    yes...you can have a javascript which will make all the filed readonly if the parent type is contact.

    Also you can have a workflow to copy the address from account to new address but when you want this to trigger? because you will need to set the parent as contact for the copied record.

    Also, you need to keep the two address in sync - so another workflow which trigger on update of Account's address and copy the value to Contact's address.

    Thanks,

    PS

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans