Import Invoice problem

John A Brown johnbrowngreybeard at gmail.com
Wed Jun 21 15:28:18 EDT 2017


Hello,

I am using GnuCash 2.6.16 in Windows 7. (I did update GnuCash.) The error
happens when I click File -> Import -> Import Bills & Invoices. I choose
Invoice000502.csv, invoice, comma separated. When I get this information
entered the Preview window displays the actual information that is in the
file. When I click OK I get an error telling me "ROW 1 DELETED,
CUSTOMER_DOES_NOT_EXIST; id=502". The "id=502" it is referring to is the
first field which is listed as id and I understand this field is invoice
number. The data in this file for owner_id (customer number) is 8351 and
there is a customer with customer number 8351.

I experimented and tried different things but it always gives the same
error. I did utilize invoice import feature in an earlier GnuCash version
successfully. I have carefully compared my format to that described in Help
-> GnuCash Tutorial and Concepts Guide -> Importing Business Data -> Import
Bills or Invoices. I worked on this 12 days ago with GnuCash 2.6.5 and I
got past this error and got the sample to import. I updated GnuCash and
tried to get it to import the next invoice. I can't seem to get this
solved.

Any help or suggestions would be appreciated. Is there any way to see a
more detailed explanation of the error like in a log file?

Kind Regards, John A Brown


More information about the gnucash-user mailing list