Design and Implementation of Cash Receipt Generating System for a Supermarket

Design and Implementation of Cash Receipt Generating System for a Supermarket

ABSTRACT

This project was centered on a cash receipt generating system. The current process of cash receipt generation is being operated manually and due to this procedure, numerous problems are been encountered. A design was taken to computerize the manual process to check this problem. The problems were identified after a series of interviews and examination of documents after which analysis was made and a computerized procedure recommended. This project will also suggest how to successfully implement the computerized procedure and to overcome the obstacle that would hinder the successful implementation of the system. The new system was designed using PHP (Hypertext Preprocessor) and MySQL. This language was chosen because of its object-oriented features and wealth of class libraries for developing-based applications.

TABLE OF CONTENTS

Title Page

Dedication

Acknowledgment

Abstract

Table of content

CHAPTER ONE

Introduction

Statement of the problem

Purpose of the study

Aim and Objectives

Scope Delimitation

CHAPTER TWO: REVIEW OF LITERATURE

2.1 History of On-line Cash transaction

2.2 Concept of Online Shopping

2.2.1 Concept of Computer Networking and The Internet

2.2.2 Internet Access

2.2.3 Concept of Internet Gateways

2.2.4 The World Wide Web and Its Benefits

2.3 Merchant Account

CHAPTER THREE: RESEARCH METHODOLOGY, SYSTEM ANALYSIS, AND DESIGN

3.0 Introduction

3.1 Research Methodology

3.2 Analysis of Case Study

3.2.1 Organizational Structure

3.2.2 Sources of Data

3.3 Problems Associated With The Current System

3.4 New System Design

3.4.1 System Proposal

3.4.2 Design Objectives

3.4.3 Input/Output Specifications

CHAPTER FOUR: SYSTEM DEVELOPMENT AND IMPLEMENTATION

4.0 Introduction

4.1 Main Menu

4.2 Web Development

4.2.1 Language Development

4.2.2 System Flowchart

4.3 Program Hardware Requirements

4.4 Documentation

CHAPTER FIVE: SUMMARY, CONCLUSION, AND RECOMMENDATION

5.0 Introduction

5.1 Summary

5.2 Conclusions

5.3 Recommendations

Appendix

References

CHAPTER ONE

1.0 INTRODUCTION

The cash receipt generating system is a viable source in any business organization and venture and so on, its main purpose is to maintain more reliable records of money going in and out from the firm. This is looked upon the view that the business organization must have business associates that exchange market with each other. It is a sure fact that the most have been a contract of which, there is an obligatory task that stands the terms of the agreement, it could be a payment to their client or partners or from their client who pays into their account. Another thing matters whether it will be cash without remark balance or install mental, and how many installments it is going to be.

This is clearly stated in the organization’s activities and manner of operation. Whenever there is payment, there is also the issuing of receipts this is centered on the writing of what each party has in stock.

1.1 JUSTIFICATION OF THE PROJECT

For there to be a computerized business operation, the business must be looked upon in a new way of existence. Not only being concerned with customers, prices output and so forth one should also consider the fact that data forms, but the information also flows procedures, etc. it is momentous on the basic that computers are used as a co-existing element to information system. This application is effective and productive because it enhances to process more a better information system. (Automated)

In this work, we shall look upon the possibility of outlining an orderly model of designing effect change. The process of changing the system is systematic such that it is a repetition process. It is a fact to say that every system has what is called a life cycle especially an information system. By reviewing and modifying them, we say,

It is a system development cycle. The routine is always cyclical. It is on the system development that the familiar input processing output-feedback pattern of all systems. The system development contains the output which consists of various organization information systems. The feedbacks components help evaluate the effectiveness of the systems in terms of changing requirements.

IN THE PROCESSING COMPONENTS WE HAVE THREE PARTS

System analysis

System design

System implementation.

None of these parts can be considered apart from the other two. To be courtesy, I would say that the activities involved in system development are interlinked set.

1.2 DEFINITION OF PURPOSE

The rate of accepting different sources of receipt by the topic of this project paper into an organization, keeping track of the files can at any operate the organization and client’s financial report.

1.3 PROBLEM DEFINITION

Cash receipt system of Rorban Stores LTD. Is to keep records of all receipts of purchases and sales made.

By so doing, they keep information concerning each transaction such as the name of the client, address, date of transaction, description of goods. Quantity of goods, model number of the goods, the amount of the goods.

Inside this record, the company can know the financial reports of both the client and the organization itself.

1.3 SCOPE (DELIMITATION) OF THE PROJECT

This project is restricted to Rorban Stores LTD, as a case study for the project paper. Looking at Rorban stores, the cash receipts system is restricted only to the.

1. Purchase receipts and/or invoice

2. Sales receipts and/or invoice

Other organizations may run a different receipts system. In this project paper, we shall base only on sales and purchases.

SCOPE OF PURCHASES

Out of this interview with the accountant and sales manager of Rarban stores LTD, I discovered that the organization does not keep any record on credits when purchases are made. Therefore the term paper nullifies the idea of computing credit in the purchase.

It will be right to say that Urban stores do not go into purchasing on credit to avoid keeping many records that most often conflict matters.

SCOPE OF SALES

There is a particular sales file for all buyers and dealers (companies that buy from them) that buy on cash. It also maintains separate buyer’ sales creditors files, and separate buyers sales debtors files, that are kept by the company.

Therefore the term paper is basically on the above mention area as in sales. By this, the company maintains one purchase database file and three sales database files, a total of four database files.

DEFINITION OF TERMS

ACQUIRING BANK: This is a bank or financial institution that accepts payments for the product or services on behalf of a Merchant.

PHP(Hypertext Preprocessor): This is a powerful server-side scripting language for creating a dynamic and interactive website.

COMPUTER: This is an electro-mechanical device that is capable of accepting data as inputs, storing it, processing the data, and outputting it as a result of information.

CREDIT CARD: It is a payment mechanism that enables consumers to make their purchases.

DATA: Data are raw facts that undergo processing and become information. They are also the simplest unit of information that can stand on its own.

DIGITAL CERTIFICATE: It is a certificate that enables a merchant to do online business and it is been issued by a corporate body.

GATEWAY: This is a device that connects two computer networks that cannot be connected in any other way.

HYPERTEXT DOCUMENTS: They are documents written with HTML, ASP, ASP.NET, PHP, JAVASCRIPT PAGES (JSP), CODE FUSION, and PROGRAMMING LANGUAGES.

INTERNET: It is an interaction of computer networks connecting other networks from computers, companies, houses, etc.

ISP: (Internet Service Provider): This is a company(s) that provides internet access to homes or business users.

MERCHANT ACCOUNT: It’s a contract under which an acquiring bank extends a line of credit to a merchant who wishes to accept payment card association brand

MYSQL: This is a relational database server that is ideal for both small and large applications.

ONLINE SUPERMARKET: It is a representation of material or real shop on the internet or the web.

ONLINE SHOPPING: This is the buying and selling of products through the internet or web.

PROGRAM: A program is a sequence of instructions written on a computer to execute a certain task and solve a problem. A program must possess clarity, be specific, effective, and user friendly.

WWW (World Wide Web): It is a multimedia interface that connects us to resources such as documents, e-mails, chat, web sites that are available on the internet with the computer.