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

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 22

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]

I have the same question (0)
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Moderator on at

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

  • Hossam Z. EL Hassan Profile Picture
    Hossam Z. EL Hassan 22 on at

    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

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,403 Super User 2026 Season 1 on at

    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 22 on at

    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.

  • Hossam Z. EL Hassan Profile Picture
    Hossam Z. EL Hassan 22 on at

    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.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,403 Super User 2026 Season 1 on at

    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.

  • Suggested answer
    Hossam Z. EL Hassan Profile Picture
    Hossam Z. EL Hassan 22 on at

    Hi André,

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

  • Martine Cezanne Profile Picture
    Martine Cezanne 47 on at

    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

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 521 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 438

#3
Adis Profile Picture

Adis 261 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans