Forum Discussion

INO80's avatar
INO80
Member
5 years ago
Solved

Customer Not Found

Hi,   I am trying to import a CSV file from a Community Data Solutions software into MYOB but my imports are not successful. I keep getting the 'Customer Not Found' error.   Alternatively, I save...
  • Mike_James's avatar
    Mike_James
    5 years ago

    Hi INO80 , if I can comment, your import file contains Abbey,Luke,"Luke Abbey" as the co/lastname and firstname fields. (Excel has added quotes because of the comma in the second field).

     

    If your customer is an individual, eg Abbey, Luke (LastName, Firstname), then the file should contain Abbey, Luke in the first two fields.

INO80's avatar
INO80
Member
5 years ago

Hi Neil_M ,

 

Thank you for your suggestion.

 

I have made the corrections as suggested but I am still getting the error message. I created a new customer with identical details as the one I have in my import file but no matter what I do, I still get the Customer not Found error. Can you pinpoint anything I am not doing rightly? 

 

Attached are the CSV file I am trying to import, the import log and an exported sales file.

 

Thank you.

Mike_James's avatar
Mike_James
Ultimate Cover User
5 years ago

Hi INO80 , if I can comment, your import file contains Abbey,Luke,"Luke Abbey" as the co/lastname and firstname fields. (Excel has added quotes because of the comma in the second field).

 

If your customer is an individual, eg Abbey, Luke (LastName, Firstname), then the file should contain Abbey, Luke in the first two fields.

  • INO80's avatar
    INO80
    Member
    5 years ago

    Hi Mike_James ,

     

    Thanks for that clarification.

     

    I created the card as a company, not as an individual, and then proceeded to modify my data source to that effect. During matching, I unmatched first name and was able to successfully import.

     

    Thanks to you too Neil_M. Your cntribution was helpful.

     

    My Regards.

     

     

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.