Sales export and import but customer not found

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.
TinHK
Contributing Cover User
5 Posts
Contributing Cover User
Australia
Contributing Cover User

5Posts

0Kudos

0Solutions

Solved: Go to Solution

Sales export and import but customer not found

Hi, 

 

I have exported from historic sales and amend some data and imported to MYOB for another calendar month sales. However, all the import record was skipped and the error message is following

 

Summary of errors
Error -190: Customer not found. Sale invoice not imported.

 

I practise the same in other companies files (export sales, import sales with update data) but i do not have this problem.

 

May i know why this company file cannot recognize the import customer?

 

Thank you.

 

2 REPLIES 2
Steven_M
45,180 Posts
Former Staff
New Zealand
Former Staff

45,180Posts

0Kudos

6,759Solutions

Accepted Solution Solved

Re: Sales export and import but customer not found

Hi @TinHK 

 

When importing those records back in I would be looking at unmatching the Card ID and Record ID fields. For example as shown in the following screenshot, I've selected to Auto-Match and then navigate to the Card ID and Record ID fields unlinked them (click the field name on the right).

 

Attachment.PNG

 

Also, I notice that the system is thinking that there are 44 records to be imported. I would assume that you have removed some records from the import file prior to uploading to the Forum?

 

Please note: I have assumed you have ensured that the card name is listed in the company file under the Card File>>Cards Lists>>Customer list.

Kind regards,
Steven

MYOB Community Support

Online Help| Forum Search| My Account

TinHK
Contributing Cover User
5 Posts
Contributing Cover User
Australia
Contributing Cover User

5Posts

0Kudos

0Solutions

Re: Sales export and import but customer not found

Thanks Steve, 

 

The import is successful.

But i do not understand why the Card ID or Record ID is unmatch.

 

Yes I remove the excessive data because it is confidential.

 

Have a nice weekend  Smiley Happy 

 

Didn't find your answer here?

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