a project report on
TRANSCRIPT
A PROJECT REPORT ON
BILLING SYSTEMFOR
VIBGYOR TEXOTECH LIMITED310, Navyug, 167, Tokersi Jivraj Road,
Sewree, Mumbai - 400015
Designed and Developed
BY Miss. SOUNDARYA SUNDARA RAJAN
Submitted in partial fulfillment ofBachelors Of Science (Computer Science)
UNIVERSITY OF MUMBAI
Thakur College Of Science And CommerceKandivli (East), Mumbai – 400101.
ACADEMIC YEAR 2009-2010
1
2
Thakur Degree College of Science & Commerce Shyamnarayan Thakur Marg, Thakur Village Kandivali (E), Mumbai-400 101
DATE: ________________
COMPUTER DEPARTMENT(2009-2010)
Certificate Of Approval
This is to certify that the project work entitled ‘BILLING SYSTEM’ is prepared by Miss. Soundarya Sundara Rajan, a student of ‘Third Year Bachelor Of Science (Computer Science)’ course of University of Mumbai, which is conducted by our college. This is the original study work and important sources used have been duly acknowledged in the report. The report is submitted in partial fulfillment of B.Sc. (Computer Science) Course as per rules of University Of Mumbai.
_________________ _________________
Project Guide Head Of Department
_________________
External Examiner
3
4
VIBGYOR TEXOTECH LIMITED(AN 100% E.O.U.UNIT)
Regd.Office: 310, Navyug, 167, Tokersi Jivraj Road, Sewree, Mumbai-400015Tel: 91-22-24124221. Fax. 91-22-24138529. E-mail: [email protected]: Minaxi Complex, Bldg. No.2&3, Jeevan Sunder Indl. Estate, 65/2, Balchi Pada, Burma Shell,
Valiv Village, Vasai Taluka, Dist: Thane. Tel: 0250-2480935
TO WHOMSOEVER IT MAY CONCERN
This is to certify that Ms. Soundarya Sundara Rajan has been given permission to make a project relating to Billing System for our Company.
We also assure to cooperate with her in providing necessary information to complete the project.
for VIBGYOR TEXOTECH LIMITED
5
AUTHORISED SIGNATORY
Station: Mumbai 15.Date:15.05.2009.
6
It is rightly said that we are built on the shoulders of others. For so many people have a hand in everything I have achieved, and the success of this project could have been impossible without them.
I express my profound gratitude to the management of Thakur Degree College of Science and Commerce for giving me an opportunity to portray my capabilities through this project.
I express my sincere thanks to the Principal of the college Mrs. C.T. Chakraborty for the resources and cooperation in the completion of the project.
I am also grateful to Mrs. Vinita Gaikwad the Head of Department of Computer Science for her most sincere, useful and encouraging guidance throughout the project span. I would also like to thank heartily the entire faculty of Computer department for the bountiful help rendered.
Most importantly, I thank my family and friends from the bottom of my heart for all the unfaltering support and care that they have given me right to the very end.
7
8
SR.NO. TOPIC PAGE NO.
1 Introduction2 Activity Chart3 GANTT Chart
PLANNING PHASE 4 Organizational Overview5 Current System6 Limitations Of Current System7 Proposed System8 Feasibility Study 9 Fact Finding Techniques
10 System Requirements
ANALYSIS PHASE 11 Event Table 12 Class Diagram13 Use Case Diagram
DESIGN PHASE 14 CRUD Chart15 Sequence Diagram16 State Chart Diagram17 Menu Chart
IMPLEMENTATION PHASE
18 Program Details
9
19 File Structure 20 Database Details 21 Reports Details22 System Coding 23 Screen Layouts 24 Report Layouts 25 Bibliography
10
11
12
13
14
ORGANIZATION OVERVIEW
Vibgyor Texotech Limited was started as an EOU unit in the year 2005 by the Minar Group of Companies. The Company manufactures Top of the Bed products and has introduced the unique Bed in a Bag product which is first of its kind in India.
This unit is the first unit in India to introduce verticalization of manufacturing Comforters, Coverlets, Sheet Sets and Pillows and Shams.
Bed In A Bag - A 7 piece set contains a sheet set consisting of Fitted sheet, a flat sheet and 2 pillow cases and two pillows, 2 neck rolls and a comforter on the lower end of the series and can be increased as per customer’s desire to 12 piece set.
Comforters are poly filled and stitched with designs patterns according to the customer’s requirements are light in weight and are really comfortable while sleeping.
Coverlets are lighter than comforters are used as dust covers over bed when not in use which contains again patterns as per customer’s choice.
The Thread Count decides the fineness of the Cotton Cloth which is unique for the product range of Minar Group. The product range starts from 300 TC to 1200 TC according to the customer’s requirements.
15
CURRENT WORKING
16
The current system makes use of Microsoft Excel.
The customer enquires about the products and its costs knowing what his requirements are.
The organization then provides the customer with a QUOTE with details of Thread Count and the price depending upon the market rates of the cloth,$ value, etc.
Prices vary with the market as $ value and input cloth value keep varying by the day.
For eg. A 300TC Bed in bag with 2 pillows, 2 pillow cases, 2 neck rolls, 1 flat sheet, 1 fitted sheet and a comforter costs $35 while the same with a 400 TC costs about $40.
If the customer then wishes to place an order, he sends an order to the organization.
The organization then generates the invoice and sends it to the customer.
17
LIMITATIONS OF THE CURRENT SYSTEM
18
The current system implements Microsoft Excel which requires thorough knowledge of the application and hence it requires trained staff.
It is not very user friendly and is tedious to work on it.
The system does not check the data for validations.
The system is not flexible and hence it takes some effort to generate invoice and reports.
19
PROPOSED SYSTEM
The new system handles data better as there are Validations to check for errors.
20
It is very user friendly and does not require much knowledge of computers.
Generating reports is easier and faster.
Data redundancy and data inconsistency is reduced.
21
FEASIBILITY STUDY
1.Economic Feasibility As the system is fully automated, the processing speeds
up, thus saving time. Reducing error rates due to validation in automated
system.
22
2.Technological Feasibility The system does not make use of new technology thus
reducing technological risks. Since the system provides a user friendly environment
so even a non-technical user can use the system effectively.
3.Organizational and Cultural Feasibility The current working of organization is computerized
and the company database is maintained in MS-Access. The staff of organization is comfortable with the not-so-complex technology.
Neither does any computer phobia exist amongst the staff of the organization.
Therefore the proposed system will help the organization work efficiently.
23
FACT FINDING TECHNIQUES
INTERVIEW:Information on the working of the system was gathered
through this technique. Questions were asked about the working of the current system.
24
DOCUMENT STUDY:The documents involved in taking up an order were
reviewed. These documents helped gain better understanding of various processes of the system.
OBSERVATION: The current working system was observed. Pros and cons of the system were revealed. This helped to plan a system which would overcome the flaws of the former system.
25
SYSTEM REQUIREMENTS
The software used for the development of the proposed system is:VB.Net 2003 and Microsoft Access 2000.
The Hardware requirement: Pentium – 4 Processor
26
256MB RAM 40GB HD
The software requirement: Back end: Access 2000 Front end: VB.Net 2003
27
28
Event Trigger Source Activity Response DestinationAdding a User Admin Adding a
UserUser added Admin
Modifying a User
Admin Modifying a user
User Modified
Admin
Deleting a User Admin Deleting a User
User deleted Admin
Adding a Client
Client Adding a Client
Client added User
Modifying a Client
Client Modifying a Client
Client modified
User
Deleting a Client Deleting a Client deleted User
29
Client ClientAdding a Product
User Adding a Product
Product added
User
Modifying a Product
User Modifying a Product
Product modified
User
Deleting a Product
User Deleting a Product
Product deleted
User
Adding a Set New order User Adding a Set Set added UserDeleting a Set Order
canceledUser Deleting a
SetSet deleted User
Adding Set Details
Set added User Adding Set Details
Set details added
User
Modifying Set Details
Set added User Modifying Set Details
Set details modified
User
Deleting Set Details
Set deleted User Deleting Set details
Set details deleted
User
Adding Consignment
New order User Adding Consignment
Consignment added
User
Modifying Consignment
Order modified
User Modifying consignment
Consignment modified
User
Deleting Consignment
Ordercanceled
User Deleting consignment
Consignment deleted
User
Adding a Carton
Consignment added or modified
User Adding a carton
Carton added User
Modifying a Carton
Consignment modified
User Modifying a carton
Carton modified
User
Deleting a Carton
Consignment modified/deleted
User Deleting a carton
Carton deleted
User
Adding Details Carton added/modified
User Adding details
Details added User
Modifying Details
Carton modified
User Modifying details
Details modified
User
Deleting Details
Carton deleted
User Deleting details
Details deleted
User
Generating Packing List
Order complete
User Generating packing list
Packing list generated
Client
Generating Packing List User Generating Invoice Client
30
Invoice generate invoice generatedGenerating reports
1 month complete
User Generating reports
Reports generated
Admin
31
32
33
34
Modify User
Delete User
Delete Customer
Add Client
Modify Client
Add Product
Add User
Add Set Details Modify Product
Delete ConsignmentAdd Consignment
Delete ProductModify Set DetailsModify Consignment
Delete CartonDelete Set Details
Modify Carton
Delete SetAdd SetAdd Carton Delete
DetailsDelete Invoice
Add Invoice Modify Invoice
Invoice generatedSummary ReportInvoice UserCarton UserConsignmentUser UserSetUser User
Product
Client
U
User1
User User
Client User
Admin Admin
User UserSet DetailsAdd Details Modify DetailsDetailsUserUser UserUser Client Wise Reports
Monthly Reports
City-Wise Reports
User AdminClientFinal ReportUser
35
36
Table Process
User Client
Product
Set SetDetails
Consignment
Carton
Details
Invoice
37
Login R
AddUser CR
ModifyUser RU
DeleteUser RD
Client R CRUD
Product R CRUD
Set R CRD
SetDetails R R R CRUD
Consignment
R R CRUD
Carton R R CRUD
Details R R R CRUD
Invoice R R CRUD
C-Create R-Read U-Update D-Delete
38
39
:User:btnAdd:btnModify:btnDelete
btnAdd_click()User_load()btnSave_click()btnModify_click()btnDelete_click()Modify()Delete()
:btnSave
Admin
40
Add()
:Client:btnAdd:btnModify:btnDelete
btnAdd_click()btnSave_click()btnModify_click()btnDelete_click()AddClient()ModifyClient()DeleteClient()
:btnSave
User
41
Client_load()
:Product:btnAdd:btnModify:btnDelete
btnAdd_click()Product_load()btnSave_click()btnModify_click()btnDelete_click()AddProd()ModifyProd()DeleteProd()
:btnSave
User
42
User
43
:Set
:btnAdd
:btnDelete
Set_load()
btnSave_click()
btnAdd_click()
btnDelete_click()
AddSet()
DeleteProd()
:btnSave
User
44
:SetDetails
:btnAdd
:btnModify
:btnDelete
btnAdd_click()
SetDetails_load()
btnSave_click()
btnModify_click()
btnDelete_click()
AddSetDetails()
ModifySetDetails()
DeleteSetDetails()
:btnSave
User
45
:Consignment
:btnAdd
:btnModify
:btnDelete
btnAdd_click()
Consignment_load()
btnSave_click()
btnModify_click()
btnDelete_click()
AddConsignment()
ModifyConsignment()
DeleteConsignment()
:btnSave
User
46
:Carton
:btnAdd
:btnModify
:btnDelete
btnAdd_click()
Carton_load()
btnSave_click()
btnModify_click()
btnDelete_click()
AddCarton()
ModifyCarton()
DeleteCarton()
:btnSave
User
47
:Details
:btnAdd
:btnModify
:btnDelete
btnAdd_click()
Details_load()
btnSave_click()
btnModify_click()
btnDelete_click()
AddDetails()
ModifyDetails()DeleteDetails():btnSave
User
48
:Invoice
:btnAdd
:btnModify
:btnDelete
btnAdd_click()
Invoice_load()
btnSave_click()
btnModify_click()
btnDelete_click()
AddInvoice()
ModifyInvoice()
DeleteInvoice()
:btnSave
49