Sales export and import but customer not found

TinHK

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.

 

export sales.TXT

Error import -netscout.txt

Steven_M

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).

 

 

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.