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 / 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]

I have the same question (0)
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 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 12 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... 301,075 Super User 2025 Season 2 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 12 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 12 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... 301,075 Super User 2025 Season 2 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 12 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

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 551 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 278 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans