Home
Who can use this project ?
Commercial visual basic application developer can use this project as a whole or part of it as required.
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.
Who want to learn database programming in visual basic.
Who want to know how to develop commercial application from project requirement to implementation and final documentation.
Win API Programming in visual basic.
How to create report in Crystal Report and integrate with visual basic application.
Abstract
The client uses MS Excel, and maintains their product list, customer list, and prints the invoice, however it is not possible them to share the data from multiple system in multi user environment, there is lot of duplicate work, and chance of mistake. When the product price are changed they need to update each and every excel file. There is no option to find and print previous saved invoice. There is no security; any body can access any report and sensitive data, also no reports to find out the sales volume, stock list, and summary report. This eBilling and invoicing system is used to overcome the entire problem which they are facing currently, and making complete atomization of manual billing and invoicing system.
Project Scope
From an end-user perspective, the eBilling and Invoicing Project consists of two functional elements: an enhanced searchable database for customer, products, billing generation system and a report generation system.
Customer, Products, Billing Generation
An enhanced atomized system is developed to maintain Customer, Product, order, order details data and produce Bill and invoice with following features.
The system operator will be able to Add, Edit and search the product. Also the operator can delete the product; update the cost of the product as per the rights given to the operator by the administrator.
By using their own account, sales staff will be able to place orders through the system. In addition, sales staff will be able to apply discounts in accord with the current sales policy.
Improved search capabilities of product information will be available; It will display all the details of the particular product with current stock quantity.
Prices and order information will be expressible in international currency and date/time formats.
After placing the order system automatically print the invoice with pre printed stationary with all the details.
Searching of previously generated invoice is also available; Operator can search the previously saved invoice by system generated unique invoice no.
Importing the old stock into the system, it imports the old stock from predefined MS Excel file.
Maintain the user master and security features.
Report Generation System
A Report Generation system will be developed for the user and management of eBilling and Invoicing System. This MIS system will have both details and summary type reports for analysis the sales volume, sales trend, available stock, The Windows-based MIS application will include the following features:
Billing summary report, it has the selection criteria for the date range.
Stock Details and stock summary reports, It shows every details of the stock and can be used to monitor the sales pattern.
All reports can be exported in different format includes Text File, CSV File, MS Excel, MS Word File.
All report can be printed from any type of printer.
Bill and invoice can be printed in pre printed stationary.
Usage Summary
eBilling and Invoicing System Version 1.0 will address the following use cases. The complete usage scenarios will be completed during the information-gathering process. Use cases will be created and prioritized. Selected use cases will be expanded into usage scenarios and features that are derived from both use cases and the usage scenarios, as represented in the following diagram:
Solution
After analysis the requirement we decide that we need to create
Product master module, where we import all product data from MS Excel.
Company Master to maintain company details.
Client master to maintain client name address.
Bill master where we maintain bill details like bill no, bill date, client details, etc.
Bill Details where we maintain details transaction like product, quantity, rate etc.
Reports in Crystal Report for easy print and export options.
Software used
Front End : Visual Basic 6
For fast development, easy to deployment and maintain.
Back End : MS Access 2003
Client already have MS Office installed in their system, nos of user are 3 only.
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.
How to convert MSFlexGrid as editable text box and drop down list box.
How to format MS-Excel worksheet with border color, back ground color, text color and change column width in visual basic.
Convert Rupees to amount in word like 123.50 will convert into "Rupees one hundred twenty three and fifty paise only"
How to connect and show crystal report from visual basic application.
Download
Commercial visual basic application developer can use this project as a whole or part of it as required.
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.
Who want to learn database programming in visual basic.
Who want to know how to develop commercial application from project requirement to implementation and final documentation.
Win API Programming in visual basic.
How to create report in Crystal Report and integrate with visual basic application.
Abstract
The client uses MS Excel, and maintains their product list, customer list, and prints the invoice, however it is not possible them to share the data from multiple system in multi user environment, there is lot of duplicate work, and chance of mistake. When the product price are changed they need to update each and every excel file. There is no option to find and print previous saved invoice. There is no security; any body can access any report and sensitive data, also no reports to find out the sales volume, stock list, and summary report. This eBilling and invoicing system is used to overcome the entire problem which they are facing currently, and making complete atomization of manual billing and invoicing system.
Project Scope
From an end-user perspective, the eBilling and Invoicing Project consists of two functional elements: an enhanced searchable database for customer, products, billing generation system and a report generation system.
Customer, Products, Billing Generation
An enhanced atomized system is developed to maintain Customer, Product, order, order details data and produce Bill and invoice with following features.
The system operator will be able to Add, Edit and search the product. Also the operator can delete the product; update the cost of the product as per the rights given to the operator by the administrator.
By using their own account, sales staff will be able to place orders through the system. In addition, sales staff will be able to apply discounts in accord with the current sales policy.
Improved search capabilities of product information will be available; It will display all the details of the particular product with current stock quantity.
Prices and order information will be expressible in international currency and date/time formats.
After placing the order system automatically print the invoice with pre printed stationary with all the details.
Searching of previously generated invoice is also available; Operator can search the previously saved invoice by system generated unique invoice no.
Importing the old stock into the system, it imports the old stock from predefined MS Excel file.
Maintain the user master and security features.
Report Generation System
A Report Generation system will be developed for the user and management of eBilling and Invoicing System. This MIS system will have both details and summary type reports for analysis the sales volume, sales trend, available stock, The Windows-based MIS application will include the following features:
Billing summary report, it has the selection criteria for the date range.
Stock Details and stock summary reports, It shows every details of the stock and can be used to monitor the sales pattern.
All reports can be exported in different format includes Text File, CSV File, MS Excel, MS Word File.
All report can be printed from any type of printer.
Bill and invoice can be printed in pre printed stationary.
Usage Summary
eBilling and Invoicing System Version 1.0 will address the following use cases. The complete usage scenarios will be completed during the information-gathering process. Use cases will be created and prioritized. Selected use cases will be expanded into usage scenarios and features that are derived from both use cases and the usage scenarios, as represented in the following diagram:
Solution
After analysis the requirement we decide that we need to create
Product master module, where we import all product data from MS Excel.
Company Master to maintain company details.
Client master to maintain client name address.
Bill master where we maintain bill details like bill no, bill date, client details, etc.
Bill Details where we maintain details transaction like product, quantity, rate etc.
Reports in Crystal Report for easy print and export options.
Software used
Front End : Visual Basic 6
For fast development, easy to deployment and maintain.
Back End : MS Access 2003
Client already have MS Office installed in their system, nos of user are 3 only.
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.
How to convert MSFlexGrid as editable text box and drop down list box.
How to format MS-Excel worksheet with border color, back ground color, text color and change column width in visual basic.
Convert Rupees to amount in word like 123.50 will convert into "Rupees one hundred twenty three and fifty paise only"
How to connect and show crystal report from visual basic application.
Download
- Attachments
eBilling Executable.zip - You don't have permission to download attachments.
- (88 Kb) Downloaded 33 times
