Import Error code -242

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
4 Posts
Cover User
Cover User




Import Error code -242

Hi, Since the 19.2.2019 we have trouble importing only 2 of our card files, previously there was no trouble in importing these card files. The error is 'Error -242: More than 1 customer found. Sale invoice not imported'

I have tried every suggestion that I have researched to correct this but nothing is working.  We are doing everything the exact same way as per before 19.2.2019. I have attached the excel spreadheet that we are trying to import and the Import Error report. Any solutions would greatly be appreciated. I am hoping that maybe a fresh pair of eyes may see what we might be missing. Smiley Happy


Thanks  Regards  Bev

MYOB Moderator
13,309 Posts
MYOB Moderator
MYOB Moderator




Re: Import Error code -242

Hi @GO2BEV2650 


If you were experiencing a multiple customer found, I would start by trying to import just one of these records producing the error. This would help rule out any potential issues caused by multiple entries on the import file.


Assuming the error continued when importing a single record, I would be inclined to look at the customer list within AccountRight to ensure that there aren’t multiple customer cards with sufficiently similar detail that they are being picked up during the import process.


Additionally, I note that the import file looks very unusual, in terms of a number of empty columns, as well as what I assume are transaction lines with zero dollar amounts on them.  You may want to enter in one of these transactions into AccountRight first and then exporting it out, before comparing that export to what you are trying to import to ensure that they are formatted the same


MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
Get the conversation started and make a new post Start a Post