Import Invoice problem

[John A Brown]

Mike E,

As I understand strings, 000502 is a string. 502 is also a string. Those
strings are not equal. So if the Invoice ID is stored as a string, each of
000502, 502, and 0502 are unique ID's.

In GnuCash Tutorial and Concepts Guide > Managing Business finances >
Business Features > Accounts Receivable > Invoices and about two pages down
under the topic "Assign Starting Invoice Number" it says "By default,
GnuCash starts with invoice number 1 and increments from there." They are
talking about a number not a string.

When I imported customers into GnuCash, I did assign a customer number of
000123. That customer number was imported as 123 which made me think
GnuCash id's are numbers.

I am confused about how to do this. I appreciate the help and do not want
to seem argumentative or bad spirited.

If an incorrect invoice number is entered in GnuCash, it cannot be changed
or deleted. It can only be "not posted" but it stays there forever. (been
there, done that. That is my experience and knowledge gleened from this
list. Please tell me if I am wrong and how I am wrong.)

Mike E, when you enter an invoice with an ID like 00123, how does it show
up later in the A/R register? As 123 or 00123?

Kind Regards, John Brown


On Wed, Jun 21, 2017 at 5:15 PM, Mike Evans <mikee at saxicola.co.uk> wrote:

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