setting next invoice number (mysql system)

Derek Atkins warlord at MIT.EDU
Fri Apr 16 10:42:16 EDT 2010


"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