Error -190: Customer not found. Sale invoice not imported.

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.
Highlighted
Contributing User SzakacsK
6 Posts
Contributing User
Contributing User

6Posts

2Kudos

0Solutions

Error -190: Customer not found. Sale invoice not imported.

Hello, J've just upgraded to AccountRight Plus AU 2019.2.0 and now having trouble exporting Sale Invoices when I didn't before. 

Keep getting Error 190, have checked both Customer ID and Name to make sure they match, which they do as nothing was altered to the card file before or after the upgrade.

Any Help would be appreciated.

 

Thanks

7 REPLIES 7
Ultimate Partner Mike_James
4,357 Posts
Ultimate Partner
New Zealand
Ultimate Partner

4,357Posts

1,914Kudos

548Solutions

Re: Error -190: Customer not found. Sale invoice not imported.

Hi @SzakacsK , are you able to attach an example of the file you are importing?


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise Report Writer - Custom Reporting from MYOB programs
(Including AccountRight Classic/Live, and exo Payroll)

Contributing User SzakacsK
6 Posts
Contributing User
Contributing User

6Posts

2Kudos

0Solutions

Re: Error -190: Customer not found. Sale invoice not imported.

Hi Mike

I hope this helps.

Ultimate Partner Mike_James
4,357 Posts
Ultimate Partner
New Zealand
Ultimate Partner

4,357Posts

1,914Kudos

548Solutions

Re: Error -190: Customer not found. Sale invoice not imported.

Hi @SzakacsK, I note that the final field in the file is labelled Card ID, but I suspect this is the (internal) Record ID. When you import, are you matching on Card ID? If so, try Record ID, and unmatch both Company Name and Card ID.

 

This file format was designed for version 19.x and previous versions; in this new version it will detect that and apply the old field names. (The new version uses different field names, and files designed for the new version start with "{}" in line 1).


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise Report Writer - Custom Reporting from MYOB programs
(Including AccountRight Classic/Live, and exo Payroll)

Contributing User SzakacsK
6 Posts
Contributing User
Contributing User

6Posts

2Kudos

0Solutions

Re: Error -190: Customer not found. Sale invoice not imported.

Hi Mike

 

Tried doing your suggestions, still no luck, same 190 comes up?

 

Ultimate Partner Mike_James
4,357 Posts
Ultimate Partner
New Zealand
Ultimate Partner

4,357Posts

1,914Kudos

548Solutions

Re: Error -190: Customer not found. Sale invoice not imported.

Hi @SzakacsK , I've imported your file into ClearWater 2019.2, after modifying the account number and record id to agree with Clearwater file data. The sale was imported with a warning about categories not being turned on, which is fine. 

 

In the import settings I selected comma delimited, add duplicates and match on record iD.

 

I selected Match All, then unmatched the company name and first name fields, then unmatched the card ID field at the foot of the field list, and re-matched the cardid field to the record ID. 


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise Report Writer - Custom Reporting from MYOB programs
(Including AccountRight Classic/Live, and exo Payroll)

Contributing User SzakacsK
6 Posts
Contributing User
Contributing User

6Posts

2Kudos

0Solutions

Re: Error -190: Customer not found. Sale invoice not imported.

Hi Mike

Thanks so much for your help it has worked/imported with a Warning 252; Invalid or Blank Payment is Due; default substituted.

I hope this warning doesn't upset anything?

 

Cheers

Ultimate Partner Mike_James
4,357 Posts
Ultimate Partner
New Zealand
Ultimate Partner

4,357Posts

1,914Kudos

548Solutions

Re: Error -190: Customer not found. Sale invoice not imported.

Great! That warning will not affect the transaction, it just means that the default payment terms have been used instead.


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise Report Writer - Custom Reporting from MYOB programs
(Including AccountRight Classic/Live, and exo Payroll)

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