Import Sales from CSV - MYOB AccountRight 2020
Hi, I'm trying to import sales item data into MYOB Accountright 2020.2 using the import wizard using the attached CSV. From the CSV one record is always imported successfully (BAYRANGE GROUP) but the others always return error - 190 Customer not found. I have confirmed that the Co./Last Name is an exact match.
The issue seems to be with the white spaces in the Co./Last Name which prevents the search working correctly even when exact match. To test I have copied the Co./Last Name directly from the customer card & pasted into the search box and MYOB still can't find the record - see attached "AccountRight Search Result" jpg. If the myob search function can't find it's own records I can't see how the import can work? But also I can't explain why "BAYRANGE GROUP" always works? It has white space and there are other records in the cards with the word "Group". Any help would be greatly appreciated, thanks.
Hi JDRF , if you tick the "Show inactive cards" option, then search, do you find the card?
Also, as a general rulle, if you are importing based on company name, untick the record ID and card ID options on the import mapping screen, if they are in your file. And if you get an import error, close the wizard before re-trying anything, as errors can carry forward.
