how to generate invoice number on inserting invoice

Question

1.50/5 (2 votes)

See more:

, +

Hi guys,

I have created one asp.net page for invoice,
where i have to generate invoice no# before insertion.

for eg, creating invoice form:

Date:__________ Invoice# 10012

Item:__________ Description:__________ Qty:__________Remarks:__________

'Save'

on every new invoice, i have to auto increment the 'invoice#'.
how to do that,

plzzz help/suggest me.

thanks.

Posted 8-Apr-14 5:43am

abdul subhan mohammed

Updated 8-Apr-14 7:37am

v5

Add a Solution

Comments

Richard C Bishop 8-Apr-14 11:49am

Generate a number where?

abdul subhan mohammed 8-Apr-14 13:35pm

i hv updated my question

[no name] 8-Apr-14 12:04pm

We would have no idea what the business rules are for your invoice number. We would also have no idea what you have tried and why this is a problem.

abdul subhan mohammed 8-Apr-14 13:35pm

i hv updated my question

abdul subhan mohammed 8-Apr-14 12:10pm

i have update my question, plz check.

abdul subhan mohammed 8-Apr-14 12:16pm

before insertion i have to show the invoice# would be this....

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Er. Puneet Goel · Answer 1 · 2014-04-08T22:17:00

Solution:
Like if your table name is InvoiceTbl
than do this

1. Make InvioceNo column identical like identity(1, 1)

2. Run this query to get next number:

SQL

SELECT Max(InvoiceNo) FROM  InvoiceTbl

This will return you max invoice number.

2. Add One (+1) to the returned number.

3. ave the new record

Kornfeld Eliyahu Peter · Answer 2 · 2014-04-08T06:14:00

Solution 1

Define the field for invoice no in the SQL as auto-increment:
http://www.w3schools.com/sql/sql_autoincrement.asp[^]

Posted 8-Apr-14 6:14am

Kornfeld Eliyahu Peter

Comments

abdul subhan mohammed 8-Apr-14 12:16pm

before insertion i have to show the invoice# would be this....

[no name] 8-Apr-14 12:20pm

So get the last one inserted and increment it.

Kornfeld Eliyahu Peter 8-Apr-14 12:23pm

That can't work if he has more than one user...

[no name] 8-Apr-14 14:05pm

Sure it can. At no time is a user needed at all.

Kornfeld Eliyahu Peter 8-Apr-14 14:06pm

You didn't got me. What if two or more end users are to fill the invoice form?

[no name] 8-Apr-14 19:01pm

Ah... now I get you. That is true but since the OP has not even defined a problem at all, then it's purely an academic exercise.

Kornfeld Eliyahu Peter 8-Apr-14 12:22pm

In this case you have to handle a different table, that used to occupy invoice no.
Set up a table to hold last invoice no, and get the next number from there.
An other option is to use a configuration variable that do the same - holds the last invoice no used...

_Starbug_ · Answer 3 · 2014-04-08T08:04:00

for adding a invoice no for your invoice form you can add it to top-left or top-right of your form(for example). for generating new invoice no for your new invoice you can create a string that has numbers and letters that with every click on create invoice button you can generate new invoice no that has a letter that show invoice type(buy,sell or other) and a number that can created randomly or with order.

how to generate invoice number on inserting invoice

3 solutions

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0