Design and Implementation of an Electronic Invoicing System

Design and Implementation of an Electronic Invoicing System

Project / Seminar Material
Reference ID: PS-5153-TM

DEDICATION

This research material titled “Design and Implementation of an Electronic Invoicing System” is dedicated to God for his enabling grace, and to all computer enthusiasts who contributed to make life a pleasant experience during my research documentation.

ACKNOWLEDGEMENT

I extend my sincere gratitude to all those who contributed to the completion of this project. Special thanks to my Supervisor (Name of your Supervisor), the Head of Department (Name of your HOD), the Lecturers in the department of Computer Science (CS), Book Authors and Profound Scholars of existing or related project material on “Design and Implementation of an Electronic Invoicing System” for their invaluable guidance, support, and expertise throughout the journey.

I am also grateful to your study area (mention any funding organizations, if applicable) for their financial assistance. This research would not have been possible without the encouragement and assistance of some stakeholders (mention any mentors, teachers, or colleagues). Additionally, I would like to acknowledge the understanding and patience of my family and friends during this endeavor. Your unwavering support has been a constant source of motivation. Thank you all for being part of this meaningful endeavor.


Design and Implementation of an Electronic Invoicing System

TABLE OF CONTENTS

PRELIMINARY PAGES


CHAPTER ONE

INTRODUCTION

  • 1.1 Introduction
  • 1.2 Background of Study
  • 1.3 Statement of the Problem
  • 1.4 Aim and Objectives of the Study
  • 1.5 Significance of Study
  • 1.6 Scope of Study
  • 1.7 Limitations of the study
  • 1.8 Definition of Terms
  • 1.9 Organization of Study

CHAPTER TWO

LITERATURE REVIEW

  • 2.1 Introduction
  • 2.2 Theoretical Framework
  • 2.2.1 Sales and Inventory Management
  • 2.2.2 Motivation for Sales Order and Inventory Management System
  • 2.2.3 Importance of Inventory
  • 2.2.4 Types of Inventory
  • 2.2.5 Inventory Classification Models
  • 2.2.5.1 ABC analysis
  • 2.2.5.2 Critical value analysis
  • 2.2.6 Inventory Cost
  • 2.2.7 Symptoms of Poor Sales And Inventory System
  • 2.2.8 Advantages of Sales and Inventory System
  • 2.2.9 Disadvantages of Sales and Inventory System
  • 2.3 Literature Survey
  • 2.4 Summary of Knowledge Gaps

CHAPTER THREE

SYSTEM ANALYSIS AND DESIGN

  • 3.1 Methodology Adopted
  • 3.1.1 Problem Identification Using SSADM
  • 3.2 Analysis of the Existing System
  • 3.2.1 Dataflow of the Existing System
  • 3.2.2 Disadvantages Of The Existing System
  • 3.2.3 Weakness of the existing System
  • 3.3 Analysis of the Proposed System
  • 3.3.1 Data Flow Diagram of the Proposed System
  • 3.3.2 Advantages of the Proposed System
  • 3.3.3 Justification of the Proposed System
  • 3.4 Functional Requirements
  • 3.4.1 Use Case Diagram Of The Admin / User Privileges
  • 3.5 Data Requirements
  • 3.6 High Level Model of the Proposed System

CHAPTER FOUR

SYSTEM DESIGN AND IMPLEMENTATION

  • 4.1 Objectives of the Design
  • 4.2 Cohesion and Decomposition High level Model
  • 4.3 Control Center / Overall Dataflow Diagram
  • 4.3.1 Proposed System Operation Flowchart
  • 4.4 System Specification and Design
  • 4.4.1 Input and Output Specification
  • 4.4.2 Database Specification and Design
  • 4.4.3 Data Dictionary
  • 4.5 Choice and Justification of Programming Language
  • 4.6 Program Documentation
  • 4.7 Implementation Techniques
  • 4.8 Programming Module Specification
  • 4.8.1 Installation
  • 4.9 Computer Hardware Minimum Requirement
  • 4.10 Software Requirement
  • 4.11 Personnel / User Training

CHAPTER FIVE

SUMMARY, CONCLUSION AND RECOMMENDATION

  • 5.1 Introduction
  • 5.2 Summary
  • 5.3 Conclusion
  • 5.4 Recommendation

REFERENCES

APPENDIX A - “SOURCE CODE”

APPENDIX B - “OBJECT PROGRAM”

ABSTRACT

An Electronic Invoicing System is a software-based business solution used to provide quick retrieval of customer’s invoice records on site or case of loss of original invoice. The aim of the application is to develop an computerized invoicing software to carryout tedious work and activities performed by human beings, in which they end up misplacing and discarding some important files and costumers records. In achieving this aim, the following specific objectives were laid out to design a web based invoicing system to replace some extent of human role in cases of unavailability of job, provide quick retrieval of customer’s invoice records on site or case of loss of original invoice and model a computerized invoice system to enable proper invoice generating for customers and control this records. The motivation that led to the implementation of the proposed system is as a result of the Time wastage in writing down everything bought by some customers, and Inefficiency of some members of staff due to laziness in searching of the invoice. The methodology adopted in this study is the structured system analysis and design methodology (SSADM) which is a technical approach for analyzing and designing an application or system by applying object throughout the software development process. The programming language used is HTML, CSS, JAVASCRIPT, PHP, SQL and JQUERY. The reason why web programming languages was used is because, it is platform independent and it is a web based application. This project will be of benefit to: Enterprises, and Shopping Malls/Supermarkets. The expected result is an electronic sales order system that will process customer’s selected items in a shopping mall or supermarket, and the system will generates an accurate invoice for payment purpose.


Design and Implementation of an Electronic Invoicing System

CHAPTER ONE

1.1 Introduction

An Electronic Invoicing System is a software-based business solution used to provide quick retrieval of customer’s invoice records on site or case of loss of original invoice. Computerized sales help provide better insight into which products are most popular. It also allows for enhanced marketing, stocking and oversight of critical sales objectives. Computerized sales and inventory systems save time for businesses by speeding up transactions while raising accuracy. This allows for confidence in accounting and accountability among employees as it is easy to verify how much money and what time transactions took place. They also allow for consistent experiences in terms of customer service. People know there is always a uniform interaction at the register that requires tendering payment, taking a receipt and transition of ownership of products and services. This generates confidence in a business and ensures ongoing consumer relationships. Computerized systems are the most common method of inventory control and sales processing in retail markets.

As a prelude to other parts of this study, this chapter will discuss the background upon which this study was initiated, the statement of problems that led to this study, the Aim and Objectives of the study. Others are Significance of the study, Scope of work, Limitations of the Study and Definition of technical terms.


1.2 Background of Study

The company Beverly Hills Supermarket is a small store that is managed by one person, the owner. The business sells different items or products like household equipment, drinks, grocery and other items that we can see everywhere. Like some other convenience store, the business does their physical counting of stocks manually. Technically, Beverly Hills Supermarket is only using a manual system that may cause to duplication of documents and work redundancy. The business is just depending on their manual listing of products and inputs of data which is possible to commit errors. The business cannot view their proper records of sales or income in a given time of the year. It also does not have its proper listings of product. In some instances, lost items are just being ignored by the owner. Beverly Hills Supermarket does not have any extra employee today. But before, the business had one cashier on that time. And basically, introduced the income and force to remove employees. How, the owner is the one who does all work in the business.


1.3 Statement of the Problem

Investigation reveals the problems of the existing Electronic Invoicing System, which entails that the Manual invoicing record keeping has resulted in many setbacks to the expected standard. The setback encountered includes:

  1. Time wastage in writing down everything bought by some customers.
  2. Partial or total loss of invoice by both business and customers.
  3. Under recording of invoice analysis.
  4. Inefficiency of some members of staff due to laziness in searching of the invoice.
  5. As a result of these problems, the manual system of invoice record information storage, input and retrieval is very clumsy: inefficient and unbelievable.

1.4 Aim and Objectives of the Study

The aim of the application is to develop an computerized invoicing software to carryout tedious work and activities performed by human beings, in which they end up misplacing and discarding some important files and costumers records. In achieving this aim, the following specific objectives were laid out as follows:

  1. To design a web based invoicing system to replace some extent of human role in cases of unavailability of job.
  2. To provide quick retrieval of customer’s invoice records on site or case of loss of original invoice.
  3. To model a computerized invoice system to enable proper invoice generating for customers and control this records.

1.5 Significance of Study

The significance of this study is to Beverly Hills that will provide easy-to-use and easy-to-use and easy accessed system thus transactions will be more reliable and faster that they do not have to hire another employer to do the job. It gives more accurate and secure records of sales and list of products.

Admin: manages the adding of stocks, updating the inventory, and determining the users of the system.

Customers: have the benefits of the printed receipts right after purchasing an item.

Future Researchers: would see the possibilities of upgrading the system.

Researcher: student, teacher, programmer and web-developer can benefit in this system through a detailed document


1.6 Scope of Study

The researcher is concerned with an electronic invoice system. It covers all the operations of companies and businesses in issuing receipts to customers which is the case study. It deals with the digitalizing business processes of issuing of receipts to customers for the services rendered or bought.


1.7 Limitations of the Study

During the course of this study, many things militated against its completion, some of which are:

  1. Time Constraint: The time frame given to accomplish this project was very short due to school academic calendar and it was carried out under pressure which made the researcher not to implement some necessary features.
  2. Establishment Policies: Establishment policies posed a serious limitation as most staffs are not ready to release information needed for this project work. There were lots of information needed from the staffs of this institution to enhance the study which took them time to release or they did not release at all for security purposes, hence the scope was reduced.
  3. Research material: availability of research material is a major setback to the scope of the study.
  4. High programming technique: The programming aspect of this project posed a lot of problematic bugs that took us some days to solve. Problem such as database connections using PHP, MySql, posed a lot of challenging.
  5. Financial Constraint: Insufficient fund tends to impede the efficiency of the researcher in sourcing for the relevant materials, literature or information and in the process of data collection (internet).

1.8 Definition of Terms

Customers: a person who buys goods or services from a shop or business.

Hardware: the physical tangible parts or component of a computer such as the cabinet, central processing unit, speakers and motherboard.

Inventory: is the goods and materials that a business holds for the ultimate goal of resale.

Inventory management: a discipline primarily about specifying the shape and placement of stocked goods.

Inventory Management system: the combination of technology(hardware and software) and processes and procedure that oversees the monitoring and maintenance of stocked products.

Sales: an exchange of goods or services for currency or credit.

Software: A set of instruction, data or programs used to operate computer and execute specific tasks.

Staff: A group of people who works for an organization

Transaction: An agreement between a buyer and a seller to exchange goods, services or financial instruments

Database: A collection of different files in a specialized way for easy retrieval and update.

Invoice: A nonnegotiable commercial instrument issued by a seller to a buyer. It identifies both the trading parties and list describes and quantifies the items sold, show the date of the shipment and mode of transport, prices and discounts (if any) and delivery and payment terms.

Computerized: Convert (information) to a form which is stored or processed by computer.

Customer: A person who buys goods or services from a shop or business.

Electronic: Controlled by or connected to a computer and as an activity or service this is “available on or performed using the Internet or other computer network”.

Record: Document that memorializes and provide objectives of activities performed, resulted achieved, or statement made.

CHAPTER TWO

2.0 Literature Review

2.1 Introduction

This chapter focuses on the review of related literature. A literature review includes the current knowledge as well as theoretical and methodological contributions to a particular topic. It documents the state of the art with respect to the topic you are writing. It surveys the literature in the topic selected. In this research work the literature review includes the …

Summary Headlines for Design and Implementation of an Electronic Invoicing System