setting next invoice number (mysql system)

[Bill Neely]

Yes, that is what I did.

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


On 4/16/2010 12:16 PM, Derek Atkins wrote:
> 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
>>>
>>>
>>>        
>>
>>      
>