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
|
