Import Invoice problem

[Bruce Danielson]

Importing invoices is a little more difficult and the data must be a little more precise than importing customers.  When I got it to work (in the latest version) I had text strings in the "ID" field & "owner id" field.
I also stuck in a "date_opened" date (date when importing?).
Buster
-------------------------------

Sorry I'm wrong - Customer ID is the Owner ID field.
Buster
------------------------------

Sorry I'm a couple of days late on this - I see "billing_id" is blank - that should have valid Customer ID's.
Others have noted the missing date_opened field data, etc.  Try purring Customer numbers in the billing id field.  You'll get an error if customer # (billing id) is null.
Buster  

-----Original Message-----
From: gnucash-user [mailto:gnucash-user-bounces+danielsonb=logroom.com at gnucash.org] On Behalf Of John A Brown
Sent: Wednesday, June 21, 2017 3:04 PM
To: Mike Evans
Cc: gnucash-user at gnucash.org
Subject: Re: Import Invoice problem

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