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