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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Is there a way/tool to...
Finance forum

Is there a way/tool to update the already existing contact information (email, phone, fax, etc...)?

(0) ShareShare
ReportReport
Posted on by 45

Hello,

I have some customers and corresponding addresses and contact information in the system. The task is to add new customers (with their additional information like addresses and contact details) and update the existing ones - customers with their addresses and contact details. Importing is easy with the Data Management workspace (by using Customers V3, Postal addresses, Party Contacts or Postal address electronic contacts entities). The good thing is that for each customer I have only one address (which will be primary) and thus I can update already existing addresses via the Customers V3 entity, as it's not possible to update this information via the Postal addresses entity. But for the contact information the scenario is more difficult as I have both primary and no-primary contacts - using the Customers V3 entity will update only the primary information - phone, fax, email, etc... and using the Party Contacts or Postal address electronic contacts entity generates a new record instead of updating the existing one in case of data change (i.e. Description). The reason for this is that contacts don't have a unique ID (a combination of fields - Description, Type, Locator, etc... is being used for the uniqueness). I hope this information could be helpful to someone, but I also hope to get some ideas on how to overcome the impossibility of bulk updating the contact details (in particular the "no primary" ones). Manual update record by record is always an option, but it's not esteemed, when having thousands of customers.

Thank you!

Categories:
I have the same question (0)
  • Suggested answer
    Eugen Glasow Profile Picture
    6,359 on at

    You have to export your data with the Location ID generated by the system, do your update in Excel, then import back with the existing Location ID. It goes into the UPDATE mode rather than INSERT mode.

  • V_K Profile Picture
    45 on at

    For Party contacts entity the LocationID has the same value among all the records for one customer (PARTYNUMBER), which means that by using the LocationID the specific contact record cannot be identified:

    pastedimage1566388083340v1.png

    For Postal address electronic contacts entity the situation is similar - one LocationID for all the contacts records under same address.

  • Suggested answer
    Pete Alberts Profile Picture
    3,542 on at

    Hi V_K

    I checked - there is no Data Entity that will allow you to bulk update non-primary electronic addresses for any party (reasonably sure, but under correction). I agree that it will be a handy feature.

    If I understand you correctly, you are looking for an entity that will have fields (core fields): PartyNumber, ElectronicLocationId, Locator. Then we can bulk update contact details.

    I think this is maybe possible - Locator & PartyNumber & LogisticsElectronicAddressMethodType should (in practice) be unique. So then we have a key - and then we can create an entity.

    In summary: I think this is possible with a reasonable amount of development time.

  • Eugen Glasow Profile Picture
    6,359 on at

    You are right. I checked the LogisticsPostalAddressElectronicContactEntity. The LOCATOR is a key field there, i.e. the e-mail address itself is a primary key. I.e. you cannot update them without making a new record.

  • Pete Alberts Profile Picture
    3,542 on at

    That is correct. And most probably one of the reasons that the Data Entity does not exist yet. But as I mentioned - creating a logical key for this data structure is possible, even though it is non-existent on the table.

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 > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans