Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
I am testing to import sales data into MYOB. One of transactions' client name includes hyphen. I guess that's the issue caused Error -190: Customer not found. I tried to delete hyphen and tired to delete hyphen with words behind it, still didn't work. Is anyone can give me advice? Please see attachments.
The hyphen shouldn't be an issue. Sometimes the error message can be misleading. I take it you are using AR201x as opposed to v19.
Best way to deal with any import issue is to first export a sample of the transactions you are trying to import, then format your import file to match the sample export.
Also the error refers to using the Card ID. This suggests you may not have mapped the fields correctly. For a customer or supplier, you must use name, Card ID or record_id. Ensure you map the name to the correct field. The reference to Card ID could also be caused by having 2 cards in the same name, for example as a supplier and as a customer. MYOB can't tell them apart and so you should allocate a Card ID and use that.
Hope this helps
I did exported a sampe as template. The reason I use Co./Last Name to match is because lot of clients don't have Card ID and I do want to record them in the same file. There is no issue to import other clients data with only Last Name match.
I've checked there is no two same card name. I also tried to use Card ID, delete Hyphen, delete hyphen with subsidiary name. All didn't work. I livechatted with MYOB assistant, she can't tell me the reason but as you tell me Hypen shouldn't be an issue. She adviced me to give MYOB a call but unfortunately they transferred my call to different people, it took me too long to wait. I will give them a call later.
Hope can find out reason.
Can you confirm that this Card is in fact a Customer (not a Supplier).
Yes. This card is customer not supplier.
March 2016 - last edited March 2016
Just wondering what type of invoice this is - Service, Prof, Item or Misc. I assume it must be Item although your column heading shows Activity ID. I note there is no account being posted to which implies the account is tied to the Item. Nor any inclusive indicator.
If you have still be unable to solve this, I know you have exported a sample, but can I suggest you manually enter this actual transaction for this customer, and then export this transaction to see if that helps pinpoint the issue. While v19 will often use default values when they are not imported, AR2015 will not in many cases. It may be that AR2015 needs more fields for this customer.
This is time billing sales invoice.
I will manually enter this transaction and see the export templet works or not.
Recently I have another issue. When I manually enter invoice, I can add blank line and put notes in but no Activity, rate, price etc.(please see the attached pic)
After export it , blank line missing(I've attached text file and excel file) .
I've tried add another line in excel and just put client's name nd note but it didn't work.
Any other way to deal this issue?
Sorry to add more question. Thanks
AR201x doesn't like blank lines and there is a new procedure to manually enter a note (as you have done on your image). It's curious that this does not export.
I just tried with a service invoice, entered a detail line, one inserted blank with a note, and then another detail line. I then exported, and sure enough, line 1 and line 3 exported, no sign of inserted blank Line 2. Another one for the developers.
Perhaps another user has a solution.
Thank you Gavin.
I've sorted my first issue which is because of client's name in card file use different version of "-".
Hope MYOB can figure out second problem. It doesn't make sense we can't export blank line with notes.
I just solved an issue where AccountRight 2016.2 reported Card not Found because my import had a space in the Cust. First Name field where it did not have this problem with an earlier version - try putting a space in the blank line and see if that solves the problem.