setting next invoice number (mysql system)

[Derek Atkins]

Hmm.  If you created an invoice, let the system generate an invoice ID,
and continued with it, then gnucash should have created the slots.
I guess you're going to have to wait for Phil to answer, because I don't
know how he stores it.

Sorry,

-derek

Bill Neely <ceo at xantek.cc> writes:

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

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