Import Invoice problem

John A Brown johnbrowngreybeard at gmail.com
Wed Jun 21 18:03:46 EDT 2017


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.
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mybadfile.csv
Type: text/csv
Size: 396 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20170621/9b2d18f8/attachment.csv>


More information about the gnucash-user mailing list