Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Error message while im...
Finance forum
Suggested answer

Error message while importing new customer data

Posted on by 168
Has anyone had below error message while import customer data?
 
I was importing new customer data by Data management, not updating customer data.
 
  • Layan Jwei Profile Picture
    Layan Jwei 4,742 Super User on at
    Error message while importing new customer data
    Hi,
     
    Can you share a screenshot of the number sequence setup please
  • STP Profile Picture
    STP 168 on at
    Error message while importing new customer data
    @Frank,
     
    I keep the data simple for importing.
    All customer accounts are definitely new in the system.
     
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 3,722 Super User on at
    Error message while importing new customer data
    Can you post a screenshot of your source file?  It almost looks like the system thinks you're trying to update an existing customer that doesn't yet exist.
  • STP Profile Picture
    STP 168 on at
    Error message while importing new customer data
    @Frank @Navneeth,
     
    No, those customer data are new.
     
    For example, in the system, there are 100 customer records, from CU001 - CU100, now I have additional customer data, say CU101 - CU110. That's why I set the number sequence to manual and import these 10 customer records. However, I got the error message.

    Therefore, the error message doesn't make sense to me.
  • Suggested answer
    Navneeth Nagrajan Profile Picture
    Navneeth Nagrajan 1,339 on at
    Error message while importing new customer data
    Hi,
     
    Looks like you are trying to validate and import data for an existing customer.  If number sequence is set to manual ensure that the customer is first cleaned up from the system, before you try importing the customer data. The import won't work if the customer exists and the account number sequence is set to Manual.
     
    Also, check the data in the Global address book and remove the customer from the Global Address book too, if it exists.
     
    Happy to answer questions, if any.
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 3,722 Super User on at
    Error message while importing new customer data
    Are you trying to import any other customer related data in the data project?  Maybe contacts or addresses?
  • STP Profile Picture
    STP 168 on at
    Error message while importing new customer data
    @Layan,

    I have already setup the number sequence as manual for Customer account.
     
    The issue is I still got the error message even the number sequence has been setup as Manual.
  • Layan Jwei Profile Picture
    Layan Jwei 4,742 Super User on at
    Error message while importing new customer data
    Hi,

    Yes just delete this column from the file and import the rest and the number sequence will be auto generated for this new customer and it will be created successfully. However, If you would like to specify the number sequence for that new customer, then I think u need to switch the number sequence setting to manual.

    Thanks,
    Layan Jweihan
    Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
  • STP Profile Picture
    STP 168 on at
    Error message while importing new customer data
    Hi @Mohamed Mine Mahmoudi,
     
    What about the customer account number is manual?
  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 7,269 User Group Leader on at
    Error message while importing new customer data
    Hi @STP,
     
    If you want to import new customer you must set customer number empty and then in mapping details set the field as auto-generated.
     
    Best regards,
    Mohamed Amine MAHMOUDI

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans