[SOLVED] ASP Invoicing System

[Monie]

Hey guys...

Does any of you have a sample of a simple asp program (using access database) for a simple invoicing database?

Please refer to the attached image for the sample invoice that i wanted to make.

thanx...

[robbied72]

What format do you want to output it in, PDF, E-Mail,....?

[alexgeek]

Originally Posted by robbied72

What format do you want to output it in, PDF, E-Mail,....?

Wouldn't that be a webpage?

[robbied72]

Ok, should be no problem with an ASP page, I just presumed he would want tou output it and send it to the customer.

All that is needed is some 2 Recoordsets and some code. If you have more details I would be happy to assist and guide.

Regards

Robbie

[alexgeek]

Originally Posted by robbied72

Ok, should be no problem with an ASP page, I just presumed he would want tou output it and send it to the customer.

All that is needed is some 2 Recoordsets and some code. If you have more details I would be happy to assist and guide.

Regards

Robbie

I'm gunna stick around for this

[robbied72]

Originally Posted by alexgeek

I'm gunna stick around for this

What u mean alex?

[alexgeek]

Originally Posted by robbied72

What u mean alex?

To see the end result.
There are loads of tutorials like this for PHP, but ASP I find few.
so i'd like to see how to do this

[robbied72]

Do you mean like freshbooks? If he wants to do something like this then why try to build one when fresh books is free to a point.

I can now see what you mean, I ain't got time at the present to build a monster app like that, i missunderstood.... lol.

I thought he wanted to output it so a user could login and get the invioce afterbeing notified by e-mail.

Robbie

[karinne]

Or one of these maybe?

[alexgeek]

Oh, I assumed it was for educational purposes

[Monie]

Originally Posted by robbied72

Ok, should be no problem with an ASP page, I just presumed he would want tou output it and send it to the customer.

All that is needed is some 2 Recoordsets and some code. If you have more details I would be happy to assist and guide.

Regards

Robbie

Well, thanks robbied72.
Ok, lets start. I use this invoicing/billing in my brother small shop.
Actually, I know the basic input, save and delete function in asp and I know how to do that. The problem in what I wanted to archieve here is:

Reffering to the attachment, I have 5 column and a few rows default. The price will be the [amount x unit price]. What I want to do is, the row depends on the number of items a customer want to buy. Let say the costomer want to buy 5 item, so the row will be 5.

Currently, I set the row to maybe 10. so if the customer want to buy 5 item, the rest of the column will be empty and the database function will not execute because of this.

Do you guys have any idea how to build this kind of simple billing system using asp and access?

Or maybe i will stick to use ms excel that is more simple.

[karinne]

Why don't you use something that's already built?

See the link robbie gave you and mine goes to a list.

[robbied72]

Originally Posted by monie

Well, thanks robbied72.
Ok, lets start. I use this invoicing/billing in my brother small shop.
Actually, I know the basic input, save and delete function in asp and I know how to do that. The problem in what I wanted to archieve here is:

Reffering to the attachment, I have 5 column and a few rows default. The price will be the [amount x unit price]. What I want to do is, the row depends on the number of items a customer want to buy. Let say the costomer want to buy 5 item, so the row will be 5.

Currently, I set the row to maybe 10. so if the customer want to buy 5 item, the rest of the column will be empty and the database function will not execute because of this.

Do you guys have any idea how to build this kind of simple billing system using asp and access?

Or maybe i will stick to use ms excel that is more simple.

Monie, I have put together a framework on which you can build upon view here The Source files can also be obtained in ZIP format from here too, I have not styled it and can not spend much more time on it but the basis is there for you.

Hope it helps?

EDIT: Forgot to mention there is an address to kill the Session Variables (You could Add this to the Print Invoice page as a button) - http://www.donenet.co.uk/invoice/web...asp?killUser=Y

[Monie]

Originally Posted by karinne

Why don't you use something that's already built?

See the link robbie gave you and mine goes to a list.

That is what I am looking for, thank you robbied72!
I will put my effort to learn the program and change it according to my need.

The link that karinne and robbie gave me is to complicated, I mean the invoicing system. The system also using the internet to operate. What I want is a stand alone system (eg. asp & access) that can be used for billing purpose in my brother small shop. By the way thank you for giving me the example, maybe I could use that one day.

Hey, robbied! Do you mean a button like "EXIT" the invoice (that kill/clear the session variable)? Let me try that first.

EDIT: Forgot to mention there is an address to kill the Session Variables (You could Add this to the Print Invoice page as a button) - http://www.donenet.co.uk/invoice/web...asp?killUser=Y

[robbied72]

Originally Posted by monie

That is what I am looking for, thank you robbied72!
I will put my effort to learn the program and change it according to my need.

The link that karinne and robbie gave me is to complicated, I mean the invoicing system. The system also using the internet to operate. What I want is a stand alone system (eg. asp & access) that can be used for billing purpose in my brother small shop. By the way thank you for giving me the example, maybe I could use that one day.

Hey, robbied! Do you mean a button like "EXIT" the invoice (that kill/clear the session variable)? Let me try that first.

No Problem Monie, you can use the code and adjust it to your needs.

Robbie

[Monie]

Hey robbied,

Maybe my question is more on javascript function or maybe a database function but anyway let me ask first and see if you could help me.

Ok, let say I want to add the calculation part, I mean let say if I want to give a discount 10% to one customer to a specific item, (that already in the database with the price already set)

what way should I do that?
Could you give me a brain wash, thanks.

[robbied72]

Originally Posted by monie

Hey robbied,

Maybe my question is more on javascript function or maybe a database function but anyway let me ask first and see if you could help me.

Ok, let say I want to add the calculation part, I mean let say if I want to give a discount 10% to one customer to a specific item, (that already in the database with the price already set)

what way should I do that?
Could you give me a brain wash, thanks.

Hi Monie,

I have just added the discount calculations based on the amount set in the customer table, i have also added 3 new buttons to the final invoice page (Print Invoice, Add Item to sale and Complete Sale(this abandons the session and sets it up ready for a new sale)).

You can download the zip file from the same location as above as i have overwrote the old system.

Hope this works for you buddy.

Robbie

[robbied72]

Hi Monie, Just thought it would be easy to control stock levels in here to, ain't got time at the moment to do it myself but all you would have to do is add another command to the tasks.asp page to deduct from the products table.

Send me a copy of the final product when your finished so I can take a look.

[Monie]

Originally Posted by robbied72

Hi Monie, Just thought it would be easy to control stock levels in here to, ain't got time at the moment to do it myself but all you would have to do is add another command to the tasks.asp page to deduct from the products table.

Send me a copy of the final product when your finished so I can take a look.

To be honest, I really.. really.. really like your system. I've been searching the net for almost 1 year to find the sample invoicing system just like this one. Thanks to you robbied. My brother will be surprise to see this.

The system I would say 98% satisfy my requirement and with a little bit of CSS styling, it will be perfect!

For the Stock Level thing, maybe later bcoz I have to study your coding/variable/calculation in order to do that, not to mention that I don't have any idea before this on how to do calculation in asp. Its really difficult for me I guess.

Well, I really appreciate your help man.
I will try to do the stock count and if I can't do it I will get back to you.
Thanks.

[robbied72]

Originally Posted by monie

To be honest, I really.. really.. really like your system. I've been searching the net for almost 1 year to find the sample invoicing system just like this one. Thanks to you robbied. My brother will be surprise to see this.

The system I would say 98% satisfy my requirement and with a little bit of CSS styling, it will be perfect!

For the Stock Level thing, maybe later bcoz I have to study your coding/variable/calculation in order to do that, not to mention that I don't have any idea before this on how to do calculation in asp. Its really difficult for me I guess.

Well, I really appreciate your help man.
I will try to do the stock count and if I can't do it I will get back to you.
Thanks.

Monie, Give me a shout if your stuck....