Re: [SL] Incrementing, Resetting invoice numbers?

[Luke <sl...@li...>]

system -> defaults -> sales invoice/ar transaction number

In any of those "last number" fields (sales order, customer, AP 
Transaction, etc.), you can enter a substitution-capable string which will 
be used as the next number for that particular item.

In your case, if your last invoice number was 2008-005, and you wanted the 
first one generated to be 2008-006, I believe what you would enter is:

20<%yy%>-005

Then, every time you generate an invoice, SL will use the next number in 
the sequence.

Now, the problem that we are talking about here, is that if the last 
invoice of 2008 is 2008-099, the next invoice number will be 2009-100, 
instead of 2009-000 or 2009-001, which would be desirable.  Because of 
this, at the start of your next left hand side incrementation, you must 
manually reset the right hand side in defaults.

Luke


On Sat, 5 Jan 2008, 
Matthias Cramer wrote:

> Hi Luke
> 
> Will <%yy%><%mm%> automatically be replaced by sql-ledger or do you have 
> some other magic? where do you put that ? into the templates or 
> somewhere in the sql-ledger config?
> 
> I like to have invoices in the form 2008-001, 2008-002 etc. Until now I 
> enter the invoicenumber by hand, which is somehow anoying.
> 
> If You or someone else would have a solution to that, that would be very 
> wellcome.
> 
> Best regards
> 
>    Matthias
> 
> Luke wrote:
> > That was ours' as well, when we were using it in production.  I should 
> > have asked Deiter to write something for this, back when we still had an 
> > active support contract.:(
> > 
> > Luke
> > 
> >  On Fri, 4 Jan 2008, Michael Hasse wrote:
> > 
> >> Be nice if somebody has an answer - we have the same "problem".
> >>     Our workaround has been to simply set it back to "1" in the  
> >> system defaults.
> >>
> >>
> >> Thanks,
> >>
> >> Michael
> >>
> >>
> >> On Jan 4, 2008, at 3:12 PM, Luke wrote:
> >>
> >>> This is a "how to" question.
> >>>
> >>> Currently, we have our invoice, etc., numbers in defaults, setup like
> >>> this:
> >>>
> >>> <%yy%><%mm%>-01
> >>>
> >>> So, the first invoice of 2008, for example, would be:
> >>>
> >>> 0801-01
> >>>
> >>> The second would be:
> >>>
> >>> 0801-02
> >>>
> >>> Assuming we do not generate any more invoices in January, and do  
> >>> the next
> >>> one in February (in other words: a failing business:)), the next  
> >>> invoice
> >>> would be numbered:
> >>>
> >>> 0802-03
> >>>
> >>> That last number keeps increasing, and never resets.  I would think  
> >>> that
> >>> there should be a way to make it automatically reset when the base  
> >>> number
> >>> (in this case the year/month combo) changes.
> >>> In other words, I want that first February invoice to be numbered:
> >>>
> >>> 0802-01
> >>>
> >>> Is there any way to make this happen?
> >>>
> >>> Thanks and regards,
> >>>
> >>> Luke
> >>>
> >>> ---------------------------------------------------------------------- 
> >>> ---
> >>> This SF.net email is sponsored by: Microsoft
> >>> Defy all challenges. Microsoft(R) Visual Studio 2005.
> >>> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> >>> _______________________________________________
> >>> sql-ledger-users mailing list
> >>> sql...@li...
> >>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >>
> >> -------------------------------------------------------------------------
> >> This SF.net email is sponsored by: Microsoft
> >> Defy all challenges. Microsoft(R) Visual Studio 2005.
> >> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> >> _______________________________________________
> >> sql-ledger-users mailing list
> >> sql...@li...
> >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >>
> > 
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Microsoft
> > Defy all challenges. Microsoft(R) Visual Studio 2005.
> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 
> 
>