Hello Friends,
I am preparing a form to create a new Invoice.
In this I want the invoice number field to be reset to 1 at the beginning of a new financial year.
Financial year eg. 2012 - 2013 (Begins on 1st April 2012 and ends on 31st March 2013)
Format for Invoice number 0001/2012-2013, 0002/2012-2013 and so on...
So how do i go about for creating a function in vba to achieve this.
Thanks in advance for your help.
I am preparing a form to create a new Invoice.
In this I want the invoice number field to be reset to 1 at the beginning of a new financial year.
Financial year eg. 2012 - 2013 (Begins on 1st April 2012 and ends on 31st March 2013)
Format for Invoice number 0001/2012-2013, 0002/2012-2013 and so on...
So how do i go about for creating a function in vba to achieve this.
Thanks in advance for your help.