Invoice Numbers - Unique?

[Brian C. Huffman]

On 01/16/2011 02:25 PM, Robert Heller wrote:
> At Sun, 16 Jan 2011 13:56:34 -0500 "Brian C. Huffman"<bhuffman at graze.net>  wrote:
>
>> All,
>>
>> It seems to me that invoice numbers ought to be unique.  But I see that
>> even for the same company, new invoice numbers are overlapping on
>> already posted/paid invoices.
>>
>>   From my customer's perspective, I'd think they'd want to have a unique
>> invoice number for their payment systems for each invoice.
>>
>> What do others think?
> Are you manually entering invoice numbers or letting GnuCash generate
> them? GnuCash generates unique invoice numbers -- it has its own
> internal counter.  AFAIK, there isn't a interface to set this number
> and it starts with 1 by default (one *can* manually edit the XML file
> to change the number to something else, such as a large integer like
> 10000).  If you manually enter a number, GnuCash makes no attempt to
> insure it is unique and does not update its internal counter in any
> way.
>

I'm letting GnuCash generate them automatically and it's choosing 
invoice numbers that have already been used.

As far as changing the number in the XML file, I'm using mysql as my 
storage.  Is there a place in the SQL schema?  I haven't found it so far...

Thanks,
Brian