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:[email protected]] On Behalf Of John A Brown Sent: Wednesday, June 21, 2017 3:04 PM To: Mike Evans Cc: [email protected] 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 <[email protected]> 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 <[email protected]> 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 > > [email protected] > > 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 > [email protected] > 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 [email protected] 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.
