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

[SzakacsK]

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

[Mike_James]

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

[SzakacsK]

Hi Mike

I hope this helps.

[Mike_James]

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

[SzakacsK]

Hi Mike

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

[Mike_James]

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. 

[SzakacsK]

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

[Mike_James]

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