setting next invoice number (mysql system)

Derek Atkins warlord at MIT.EDU
Fri Apr 16 15:16:50 EDT 2010


Bill,

Ahh, but did you create an invoice *AND* let it create its own Invoice
Number?

-derek

Bill Neely <ceo at xantek.cc> writes:

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

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available


More information about the gnucash-user mailing list