Auto Generation of Invoice Number

Let's say you have some invoice numbers which contains Alphabets as well as numeric number.
And you want to increment it one by one.

For Example:

if Invoice number is "AZ99999999" then Next Invoice Number will be "BA00000001"

Notice here that , the invoice number's lenght is 10 Characters out of which first 2 are Alphabets and the rest (8) are Numeric. invoice number can be of any digit with any combination of numerics and alphabets.

The function can be changed to your need very easily. but here i will demonstate for the above example.

Function:
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
Public Function IncrementInvoice(ByVal strInvoiceNumber As String) As String
 
        If strInvoiceNumber.Length <> 10 Then
            Return "Error"
        End If
 
        Dim strAlphaPart(1) As Char
        strAlphaPart(0) = strInvoiceNumber(0)
        strAlphaPart(1) = strInvoiceNumber(1)
 
        Dim IntPart As Int64
        IntPart = strInvoiceNumber.Substring(2, 8)
 
 
        If IntPart = 99999999 Then
            If strAlphaPart(1) = "Z" Then
                strAlphaPart(0) = Chr(Asc(strAlphaPart(0)) + 1)
                strAlphaPart(1) = "A"
 
                IntPart = 1
 
                Return strAlphaPart(0) & strAlphaPart(1) & IntPart.ToString.PadLeft(8, "0")
            Else
                strAlphaPart(1) = Chr(Asc(strAlphaPart(1)) + 1)
            End If
 
        Else
            IntPart += 1
            Return strAlphaPart(0) & strAlphaPart(1) & IntPart.ToString.PadLeft(8, "0")
        End If
 
    End Function


Output:
'outputs example:
strTemp = IncrementInvoice("AA99999998") 'Output will be: "AA99999999"
strTemp = IncrementInvoice("AA00000005") 'Output will be: "AA00000006"
strTemp = IncrementInvoice("AZ00000007") 'Output will be: "AZ00000008"
strTemp = IncrementInvoice("AZ99999999") 'Output will be: "BA00000001"

Comments

Post a Comment

Popular posts from this blog

How to Install Squirrel Mail in ubuntu

Image
Squirr elMail   is an Open Source project that provides both a web-based email application and an IMAP proxy server. The webmail portion of the project was started by Nathan and Luke Ehresman   in 1999 and is written in the PHP scripting language. It can be installed on almost all web servers as long as PHP is present and the web server has access to an IMAP and SMTP server                                                                                             SquirrelMail webmail outputs valid HTML 4.0 for its presentation, making it compatible with a majority of current web browsers. S...
Read more

How to Display Date in PHP

Image
To get current datetime (now) with PHP you can use   date   with any PHP version, or better   datetime class   with PHP >= 5.2 Various date format expressions are available   here . Example using   date This expression will return NOW in format   Y-m-d H:i:s 1 2 3 <?php echo date ( 'Y-m-d H:i:s' ); ?> Example using   datetime class This expression will return NOW in format   Y-m-d H:i:s 1 2 3 4 <?php $dt = new DateTime(); echo $dt ->format( 'Y-m-d H:i:s' ); ?> A more complete approach Above examples will return NOW using your server timezone, as it is defined in   php.ini , for example: 1 2 3 4 [Date] ; Defines the default timezone used by the date functions ; http://php.net/date.timezone date.timezone = Europe/Athens But, the best approach is to save dates to   UTC . UTC (also called Zulu time) is the   standard in...
Read more

Export HTML Table Data to Excel, CSV, PNG and PDF using jQuery Plugin

Image
Exporting data   in to a format is a very common features in website.There is a lot of plugin which is used to export table data into xml,csv and png format but that will use for separate jquery file for each exporting format. The   tableExport   is a wonderful jquery plugin which extracting table data into all formats like JSON , XML, PNG, CSV, TXT, SQL, MS-Word, Ms-Excel, Ms-Powerpoint and PDF, so with help of this jquery plugin you not need any other jquery plugin to extract data from tables.You can integrate   tableExport   plugin very easily with your project.
Read more