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 :
Finance | Project Operations, Human Resources, ...
Answered

Import contact person for customers

(0) ShareShare
ReportReport
Posted on by 5

Hello experts,

I want to import contact person for customer master but when I was searching for data entity and I found smmContactPersonV2Entity but in this I'm not able to find an option where I can give a customer account. Please suggest me how to proceed further?

I have the same question (0)
  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    14,672 Super User 2025 Season 2 on at

    Hi keerthanaa,

    I order to import customer contacts, you can use standard entity "Contacts V2"

    pastedimage1634650909189v1.png

    Each customer account is related to a unique Party ID where Contacts associates to it.

    For example, Customer 00003 using Party 100002307 and it value used as customer reference.

    pastedimage1634651112231v2.png

    In order to import contacts for customer you need to use Party Id of customers.

  • EA-06020800-0 Profile Picture
    on at

    Let us know your confirmation on the suggestions.

  • keerthanaa  Profile Picture
    5 on at

    Hi Alireza,

    Thanks for the reply.

    I've tried this entity. I've deleted the contact ID and modified the name then imported the excel again with the same "Associated party number" so that another contact for the same associated party number (i.e) customer or vendor would be created,

    pastedimage1634654170315v2.png


    but I'm facing this error

    pastedimage1634654226319v3.png

    can you guide me through?

  • Verified answer
    André Arnaud de Calavon Profile Picture
    300,904 Super User 2025 Season 2 on at

    Hi Keerthanaa,

    If you want to have an automatic Contact ID number, you should remove the column from the source file (Excel). If the field is present in the source file, it will assume that a manual number was provided; in your file an empty value.

  • Verified answer
    Alireza Eshaghzadeh Profile Picture
    14,672 Super User 2025 Season 2 on at

    Hi keerthanaa,

    Andre has already address the solution.

    You can delete the fields from the excel file for "CONTACTPERSONID" and "CONTACTPERSONPARTYNUMBER". Then import the contatcs.

    Or you can have these two fields in the Excel file, while in the mapping you can activate "Auto-generated" before the import.

    pastedimage1634679924435v1.png

  • keerthanaa  Profile Picture
    5 on at

    Hi Andre and Alireza thank you so much for the reply I've deleted "ContactPersonID" and "ContactPersonPartyNumber" fields from the excel file, then imported and it got successfully imported, and also I've checked the respective customer and there is a new contact which I've impoerted via excel.

    Actually I was trying to create a contact from postman for integration purpose. Before that I was just trying with data management Import method. After removing these fields from the entity body in postman LastEditDateTime, IsImported, FormattedPrimaryAddress, ContactPersonName, ContactPersonPartyType, ContactPersonId, ContactPersonPartyNumber I could create a contact for a customer using post method. Thank you so much.

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…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 663 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 540 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 348 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans