DESIGN AND IMPLEMENTATION OF AN ELECTRONIC BILLING SYSTEM

TABLE OF CONTENTS

CHAPTER ONE: INTRODUCTION

1.1            Background of the Study

1.2            Statement of the Problem

1.3            Objectives of the Study

1.4            Methodology

1.5            Significance of the Study

1.6            Scope of the Study                                                                                   

CHAPTER TWO: LITERATURE REVIEW

2.1    Brief History of Online Warehouse/ Stores

2.2     Overview of Online Warehouse/Store

2.3      Logistics of Online Warehouse/Store

2.4      Payment

2.5      Shopping Cart System

2.6      Review of Past Work

2.7      The Place of the Proposed System

CHAPTER THREE: SYSTEM ANALYSIS AND DESIGN

3.1      Advantages and Disadvantages of the Current System

3.2      System Design

3.3      Database Design    

3.4      User Interface Design

3.5      Non-Functional Requirement    

3.6      Unified Modeling Language

CHAPTER FOUR: SYSTEM IMPLEMENTATION AND DOCUMENTATION

4.1      Programming Language Choice

4.2      Choice of Database

4.3      Description of E-Billing System

4.4      System Testing

4.5      System Implementation  

4.6      Hardware and Software Specification

4.7      Sample of Screen Shots of the System

CHAPTER FIVE: SUMMARY, CONCLUSION AND RECOMMENDATION

5.1      Summary of Finding

5.2      Limitation of Study           

5.3      Conclusion  

5.4      Recommendation 

References

LIST OF FIGURE

Table 3.1       -           E-billing system actors     

Fig 3.1           -           Use case for E-billing system      

Fig 3.2           -           Class diagram for E-billing system

Fig 3.3           -           Product master sequence diagram

Table 3.2       -           Bill table                   

Table 3.3       -           Bill details table      

Table 3.4       -           Client master table

Table 3.5       -           Company master table    

Table 3.6       -           Product master table

Table 3.7       -           User master table  

Fig 4.1           -           Home screen

Fig 4.2           -           Product master screen

Fig 4.3           -           Bill invoice screen  

Fig 4.4           -           Invoice report

Fig 4.5           -           Print bill screen

Fig 4.6           -           Product master report

Fig 4.7           -           Change password  

CHAPTER ONE

INTRODUCTION

1.1            BACKGROUND OF THE STUDY

Billing is the act of issuing bills for goods or services rendered. A bill is a printed or written statement of the money owed for goods or services rendered.

Billing system can be done in two ways, namely manual method andelectronic method. In a billing System, where the storage of data is done manually i.e. information is entered into record books. This is inefficient as a number of problems can arise from this:

·        The information has to be access from one point i.e. where the record is kept.

·        In order to get information anywhere, duplicate copies have to be made.

·        Changes made in one record might not be updated in a duplicate.

·        Loss of records to natural disasters.

·        Anybody can access any report and any sensitive data.

·        No report to find out the sales volume, stock list and summary report.

Because of the above reasons listed above it is unreasonable to maintain billing System on record books in this age of computer based information system. The E-billing System is developed to solve these problems.

E-billing is the act of issuing bills (that is a printed or written statement of the money owed for goods and services rendered.) electronically or automatically via computer. E-billing system is a networked database application. A database application is defined literally, as an application that collects data from users through an interface and stores it in a data file (on memory), to process, manipulate and retrieve for decision making.

1.2            STATEMENT OF PROBLEM

The manual method of billing, storage and retrieval of customer’s information and computation could be strenuous and time-consuming. It may involve dedicating a person, people or department of the firm to handle this task. Performance computation on the part of staff could be stressful. The E-billing System focuses on how to ease the problems of retrieval of customers’ data when billing is made.

1.3            OBJECTIVES OF THE STUDY

The aim of this project is to create acomputerized bill generation process and invoice, whereby customers’ details will be maintained on a database. It will also help the firm to maintain their product lists, customer lists, and print the invoice. Also it is possible to share the data from multiple systems in a multi-user environment.

The study focuses on the following objectives:

·        To make sure data is not duplicated.

·        To give security to the sensitive data of the firm.

·        To be able to access data from any computer system connected to the database server.

·        To keep records of sales volume, stock list and summary report.

·        Store data as long as possible.

·        To be able to find and print previously saved invoices.

·        Provide easy backup of data which can be used at another location.

·        To curb every error made in a manual or handwritten billing system.

1.4            METHODOLOGY OF THE STUDY

In this project we make use of UML (Unified modeling language) to design the processes of the application and the user interaction with the system.

The System is a Microsoft window based application that runs on the .NET platform. It is developed using Visual Basic .NET. VB.NET is built on the Windows Server System to take major advantage of the OS and which comes with a host of different servers which allows for building, deploying, managing and maintaining Windows Based solutions. The Windows Server System is designed with performance as priority and it provides scalability, reliability.

The advantage of VB.NET includes;

·        Rapid Application Development (RAD) Support.

·        Powerful Windows-based Applications

·        Simplified Deployment

·        Powerful, Flexible, Simplified Data Access

·        Improved Coding

·        Direct Access to the OS Platform

·        Object-Oriented Constructs

·        COM Interoperability

The system uses Microsoft access 2007 as the database server. MS Access is desktop RDMS support small application with all features like relational query, different data types, joins, and query. Its benefits include;

·        Easy to use and easy to deployment.

·        Integration with Windows OS

·        Scalability

·        Import and Export of data in all major database system.

·        Centralized Management

·        Reliability

·        Automating Tasks i.e. no need of manual updating.

1.5            SIGNIFICANCE OF RESEARCH

The significance of this study is to use object oriented development processes and techniques in the automation of a billing system. Formal analysis and design were used to give adequate understanding to the object-oriented technique used. The major quest is to ease the problem and stress encountered in billing of customers and keeping records of stock list, customer lists, sales volume, and summary report.

In addition the application is window based making it usable by most systems in this part of the world which makes use of Microsoft windows operating system.

This project will be of benefit to:

·        Enterprises

·        Shopping Mall/Supermarket

1.6     SCOPE OF THE STUDY

The study is limited to the human and material resources available to the organization of study.