Menu
▾
▴
Re: [SL] Incrementing, Resetting invoice numbers?
|
From: Matthias C. <cr...@fr...> - 2008-01-05 07:48:19
|
Hi Luke Will <%yy%><%mm%> automaticaly 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 -- Matthias Cramer, Erachfeldstrasse 1b, CH-8180 Bülach, Switzerland http://www.freestone.net GnuPG 1024D/2D208250 = DBC6 65B6 7083 1029 781E 3959 B62F DF1C 2D20 8250 |
