Re: [SL] Numbers

[C. D. H. <Du...@Du...>]

Florian Reitmeir wrote:
> Hi,
>
> i've to deploy sql-ledger to my company.. and i've read the manual, and
> changed some of the german translations. (if there is some intrest in this,
> to whom can i send them?)
>
> the number, like 'order number', 'Invoice Number', 'Quotation Number' .. are
> these generated automatic? or semi automatic? And how can this numbers
> controlled, so is it possible to change/jump number by year? or are these
> just counters?
>
>
> e.g. we want .. 
>
> year 2006
> starting by 1000
>
> year 2007
> starting by 5000
>   
The kind of numbering that you're looking at - ranges for years - can't 
be done automatically with SQL-Ledger.  SQL-Ledger will maintain a 
sequence for you and can insert Year, Month, etc.  For example, I use 
A<%yy%>.13334 for my invoices.  This builds invoice numbers in the 
A07.13334 fashion.  07 will go to 08 next year, and the number will 
increase by 1 with each invoice.  On the part side of things I 
autonumber parts with <%description 3%><%yy%>.15428 - which uses the 
first 3 characters of my partname, the year, followed by a sequential 
number. 

If you're looking to change your invoice number by 4000 between years 
I'd either go in and change the seed on Jan 1, or I'd write a trigger 
that did it for me.

Dunc