setting next invoice number (mysql system)

[Phil Longstaff]

To tell you the truth, I don't know how I store it either.  It's possible that it is being stored in the slots which works fine for XML because when you write the file, the book and its slots are written.  For SQL, however, the call writing the slots needs to be surrounded by gnc_book_begin_edit()/gnc_book_commit_edit() to force an update.  I'll check it out.

 Phil
---------
I used to be a hypochondriac AND a kleptomaniac. So I took something for it.




________________________________
From: Derek Atkins <warlord at MIT.EDU>
To: Bill Neely <ceo at xantek.cc>
Cc: gnucash-user at gnucash.org
Sent: Fri, April 16, 2010 8:47:07 PM
Subject: Re: setting next invoice number (mysql system)

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
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.