Import Invoice problem

[Mike Evans]

The id's are stored as text strings, change the ID to  000502 and try again.

Maybe (probably) the importer should do this for you but currently it just read the string.

Mike E

 On Wed, 21 Jun 2017 17:03:46 -0500
John A Brown <johnbrowngreybeard at gmail.com> wrote:

> Attached to this email is a file named mybadfile.csv.
> 
> Thank you, John Brown
> 
> On Wed, Jun 21, 2017 at 3:36 PM, Mike Evans <mikee at saxicola.co.uk> wrote:
> 
> > Can you post a sample of the file you are trying in import?
> >
> > Obviously you may want to hide any sensitive data.
> >
> > Mike E
> >
> > On Wed, 21 Jun 2017 14:28:18 -0500
> > John A Brown <johnbrowngreybeard at gmail.com> wrote:
> >
> > > 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
> > > Invoice and try again.


.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
> > > _______________________________________________
> > > gnucash-user mailing list
> > > gnucash-user at gnucash.org
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > -----
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >