Live Projects - eBilling and Invoice System

Who can use this project ?

1. Commercial visual basic application developer can use this project as a whole or part of it as required.

2. Student who are submitting their final year project for BE, BCA, BSC-IT, MCA, MS, this project is well commented, ready made project documentation available for submission.

3. Who want to learn database programming in visual basic.

4. Who want to know how to develop commercial application from project requirement to implementation and  final documentation.

5. Win API Programming in visual basic.

6. How to create report in Crystal Report and integrate with visual basic application.

Project Description

This project is made for one of the big decorator services in Mumbai, they supply decorating item to film industry for movie shooting. Presently they issue their client handwritten invoice and they enter details in manual register. And maintain MS Excel file for product rate. They want computerization of their manual invoice and bill generation process.

When I first meet with the customer I find.

1. They are not expertise in computer operation

2. They are used to MS Excel, grid like entry

3. Presently they are maintaining their products list in MS Excel, they want this data should be imported in new software

4. They want very fast processing of bill

5. As they are catering service to the film industry and their customer are high profile. They are very strict in bill correctness, so there is no margin of error.

6. They have 3 pc in their office running WinXP home edition.

7. They are using P-IV 3 GHZ, 160 GB HDD, 512 MB RAM in their PCs

8. They are very strict of software licensing.

9. They are very strict on software completion time and they want it should complete before the deadline.

10. They want every report should be Export in MS Excel.

11. All report should be printed in DOS-Matrix and Ink Jet Printer.

12. Only Accountant and his team should have permission to use the software.

13. For future modification of any master should be done by customer only.

14. Backup of the main database should be done by the software.

15. They have 3 different company names, software should have option to select the company name while entering bill and generate reports, and should option to add future company.

16. Each customer can hire multiple products.

17. 17. Maximum number of products in a bill is 10.

18. While entering bill, client name should come automatically for previously created bill.

19. Bill/invoice should print net amount in words automatically.

20. The CST/VAT tax stamp should print in bill invoice and they want software should have an option to change the text if Income Tax department change the stamp.

Solution
After analysis the requirement we decide that we need to create

1. Product master module, where we import all product data from MS Excel.

2. Company Master to maintain company details.

3. Client master to maintain client name address.

4. Bill master where we maintain bill details like bill no, bill date, client details, etc.

5. Bill Details where we maintain details transaction like product, quantity, rate etc.

6. Reports in Crystal Report for easy print and export options.

Software used

1. Front End : Visual Basic 6
   For fast development, easy to deployment and maintain.

2. Back End : MS Access 2003
   Client already have MS Office installed in their system, nos of user are 3 only.

3. Report : Crystal Report 8.5
   Easy to create, ability to print and select printer, can export report in different format including MS Excel, easily integrate with Visual Basic 6.
    

Some important coding features you can get from this project.

1. How to convert MSFlexGrid as editable text box and drop down list box.

2. How to format MS-Excel worksheet with border color, back ground color, text color and change column width in visual basic.

3. Convert Rupees to amount in word like 123.50 will convert into "Rupees one hundred twenty three and fifty paise only"

4. How to connect and show crystal report from visual basic application.

Download the project documentation, source code, database and report files.