setting next invoice number (mysql system)

Bill Neely ceo at xantek.cc
Fri Apr 16 12:50:51 EDT 2010


I have been through the slots table from top to bottom, and don't see 
anything that remotely resembles an invoice counter. And, yes, I have 
already created an invoice.

Bill

http://business-phones.us A professional phone system for your business. Bypass the "phone company'.


On 4/16/2010 7:42 AM, Derek Atkins wrote:
> "Maf. King"<maf at chilwell.net>  writes:
>
>    
>>>> Hi Bill,
>>>>
>>>> Looks like it is in the slots table -
>>>>
>>>> SELECT * FROM slots WHERE name="counters/gncInvoice";
>>>>
>>>> HTH,
>>>> Maf.
>>>>          
>> On Friday 16 April 2010 00:24:44 you wrote:
>>      
>>> Maf:
>>>
>>> Interesting, but no such entry in my slots table.
>>>
>>> BTW version 2.3.11 of gc
>>>
>>> Bill
>>>        
>> Hi Bill,
>>
>> Don't forget to CC the list when you reply - I've hardly used the 2.3 series
>> and know very little about it, others here are much more knowledgeable!
>>
>> My only thought is that the invoice number counter may not be created until
>> you have created a first invoice - Derek will know more about this than I do.
>>      
> I have no idea how Phil stores book slot data in the SQL database.
> Sorry.  It would definitely be a counter slot.  Look around in the
> slots table?
>
>    
>> Maf.
>>      
> -derek
>
>    


More information about the gnucash-user mailing list