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 / Finance | Project Operations, Human Resources, ... / Import new customers
Finance | Project Operations, Human Resources, ...
Suggested answer

Import new customers

(0) ShareShare
ReportReport
Posted on by Hossam Z. EL Hassan 12

Hi, 

I am trying to import customers to D365 F&O, but I am receiving the error "Cannot create a record in The customer accounts that are associated with warehouse management transactions (WHSCustTable). Customer account: 080121, No.
The record already exists."

I am entering the customer account manually and it is matching the Next value in the customer sequence. I have also tried entering numbers higher than the Next value of the number sequence and still receiving the same error.

Kindly find attached the number sequence setup, along with the customer import sample and the global address book sample

pastedimage1621276776248v1.png

Number-Sequence.PNG[View:/cfs-file/__key/communityserver-discussions-components-files/765/Customer-Import-Template.xlsx][View:/cfs-file/__key/communityserver-discussions-components-files/765/Global-Address-Book-Template.xlsx]

  • Martine Cezanne Profile Picture
    Martine Cezanne 47 on at
    RE: Import new customers

    Hi Hossam,

    I have same message in the customer account. Can you tell me what your concern was about custom fields ? I only customisation wiews ... Thanks you

  • Suggested answer
    Hossam Z. EL Hassan Profile Picture
    Hossam Z. EL Hassan 12 on at
    RE: Import new customers

    Hi André,

    Thanks as you have mentioned, it was related to the customization fields. I had to remove them and then it worked perfectly.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 294,145 Super User 2025 Season 1 on at
    RE: Import new customers

    Hi Hossam,

    I made an attempt to import the customers and succeeded after creating a new customer group 'EXT'. Initially, there were a lot of fields unmapped, so I guess these are related to some new features and customizations. Do you have extended this data entity with a customization? Can you also check if the WHSCustTable has new indexes which are set to not allow duplicates? By default this table has only one index on the customer account field.

  • Hossam Z. EL Hassan Profile Picture
    Hossam Z. EL Hassan 12 on at
    RE: Import new customers

    Hi Andre,

    I have tried again with fresh entries for Global address book and customer. But still the same error persists. I am wondering if you can try the same files from your end.

  • Hossam Z. EL Hassan Profile Picture
    Hossam Z. EL Hassan 12 on at
    RE: Import new customers

    Hi Andre,

    Thanks, you are making me think in a different direction. As you said, when I first got the error I tried to reimport the file using a different customer account number. It seems like some of the information went in the first time to the warehouse entite. I will create fresh entries for Global Address Book and start again.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 294,145 Super User 2025 Season 1 on at
    RE: Import new customers

    Hi Hossam,

    Did you also import the customers before? If so, did you delete the customers or try to re-import the same file?

  • Hossam Z. EL Hassan Profile Picture
    Hossam Z. EL Hassan 12 on at
    RE: Import new customers

    Hi Frank,

    Address ID and Party ID exist only in the Global address book entity. I have imported the values sucessfully eariler. Then I am using those values to import my customer data and link the global address book

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,489 Super User 2025 Season 1 on at
    RE: Import new customers

    Have you verified that the Address ID and Party ID don't already exist?  That could be what the error message is referring to.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,145 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,923 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans