sql-ledger-users

[SL] Incrementing, Resetting invoice numbers?

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

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

Re: [SL] Incrementing, Resetting invoice numbers?

[Michael H. <mh...@it...>]

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

Re: [SL] Incrementing, Resetting invoice numbers?

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

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
> 

Re: [SL] Incrementing, Resetting invoice numbers?

[Matthias C. <cr...@fr...>]

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

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
> 
> 
> 

Re: [SL] Incrementing, Resetting invoice numbers?

[Armaghan S. <sa...@le...>]

On 1/5/08, Matthias Cramer <cr...@fr...> wrote:
> 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.

This "magic" is built-in in sql-ledger. There are a number of tokens
you can use in the defaults to generate document/customer/vendor/parts
numbers.

Here is a list from update_defaults procedure in SL/Form.pm

# check for and replace
# <%DATE%>, <%YYMMDD%>, <%YEAR%>, <%MONTH%>, <%DAY%> or variations of
# <%NAME 1 1 3%>, <%BUSINESS%>, <%BUSINESS 10%>, <%CURR...%>
# <%DESCRIPTION 1 1 3%>, <%ITEM 1 1 3%>, <%PARTSGROUP 1 1 3%> only for parts
# <%PHONE%> for customer and vendors
# <%YY%>, <%MM%>, <%DD%>, <%FDM%>, <%LDM%>

-- 
Purpose-built SQL-Ledger Hosting
http://www.ledger123.com/


--