× Close

📚 Project Proposal Topics PDF Department List & Materials for Google Scholars
Accounting Topics
Civil Engineering Topics
Computer Science Topics
Economics Topics
Economics Education Topics
📚 List of Project Proposal Topics and PDF Materials for (2025) Students

Search for Project and Seminar Topics Post Market Item or Services for Free
Design and Implementation of a Computerized System for Sales Order Accounting

Design and Implementation of a Computerized System for Sales Order Accounting

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

DEDICATION

This research material titled “Design and Implementation of a Computerized System for Sales Order Accounting” 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 a Computerized System for Sales Order Accounting” 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.

TABLE OF CONTENTS

PRELIMINARY PAGES


CHAPTER ONE

INTRODUCTION


    CHAPTER TWO

    LITERATURE REVIEW

    • 2.1 Introduction

    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 Feasibility Study
    • 3.3.1 Economic Feasibility
    • 3.3.2 Technical Feasibility
    • 3.3.3 Operational Feasibility
    • 3.4 Analysis of the Proposed System
    • 3.4.1 Data Flow Diagram of the Proposed System
    • 3.4.2 Advantages of the Proposed System
    • 3.4.3 Justification of the Proposed System
    • 3.5 Functional Requirements
    • 3.5.1 Use Case Diagram Of The Admin / User Privileges
    • 3.6 Data Requirements
    • 3.7 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.7.1 System Testing
    • 4.8 Programming Module Specification
    • 4.8.1 Installation
    • 4.9 Computer Hardware Minimum Requirement
    • 4.10 Software Requirement
    • 4.11 Personnel / User Training
    • 4.12 File Maintenance Module

    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

    Computerized sales order accounting is a software-based business solution used to simultaneously track and process sales activity and inventory. The aim of the application is to design and implement a computerized system for sales order accounting. In achieving this aim, the following specific objectives were laid out as follows to develop an application software that will provides a computer base-online and interactive software packages Accounts Master and accurately and efficiently record all such data and information. The motivation that led to the implementation of the proposed system is that in the existing system there is only one point of entry of data at which the accuracy of data can be controlled the point of entry of data in to the system. If the system accepts inaccurate data, the chance to discover and correct the error before it contaminates all files documents, and reports is lost.

    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. The significance of this study is to Beverly Hills that will provide easy-to-use and easy-to-use and easy accessed system thus6 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. This project will be of benefit to: Enterprises, and Shopping Malls/Supermarkets. The expected result is an electronic sales order system that will manage and process sales orders and generate accurate bill for payment purpose.


    Design and Implementation of a Computerized System for Sales Order Accounting

    CHAPTER ONE

    1.1 Introduction

    Computerized sales order accounting has come a long way over the years passing through some changing processes such as manual process. As the sales development indicates managing competencies, setting competencies, components of sales development process. What is frequently lacking in sales training in managing to be successful; sales people must manage the interface between the organization and the customers, since so much of sales involves working dependently, sales people must also engage in self management of and other resources.

    Situational selling provides the frame work by which people can integrate their products and selling competencies. This section outline the process involved in a manual system and a real time system processing sales order accounting.

    Once the company have received an / most industrial firms will transmit some form of documentary acknowledgement to the customer. It is commonly a duplicate copy of the customer's purchase order.

    The sales order contains basically the same data as the invoice except for such things as item extensions (price times quantity calculation) shipping charges, taxes, invoice total and credit terms in cases where the quantity delivered is less than the quantity ordered, the extra units are back ordered.

    Its notation is made in the finished goods file so that when the stock is replenished the goods will be automatically shipped to the customer many firms, particularly those in which back ordering is not common, do not use a separate sales order document. Instead the begin to prepare the sales invoice immediately upon receipt of orders, and use extra copies of the invoice in place of the several copies of the sales order one copy of the sales order in filed numerically in the sales order department.

    Three other copies are sent to the finished goods storeroom or warehouse. If the customer's credit is not established the sales order may be routed through the credit department where a credit check is performed before shipment is authorized. In the finished goods storeroom the product ordered are retrieve from available stock the sales order serves as an authorization to release the goods to the shipping departments and is used as a source document to post shipments to the finished goods inventory file. It any goods ordered, and one copy is filed by storeroom personnel for future reference.

    Those goods which are in stock are assemble and the shipping department, along with two copies of the sales order. To acknowledge the transfer of shipping, an employee of shipping will sign a copy shipped of the sales order indicating the exact quantities to be shipped. This copy will then be sent to billing.

    The remaining copy of the sales order may be enclosed as a packing ship with the goods as they are shipped to the customer. In the billing department, the sales order evidencing the transfer of goods to shipping provides the basis for preparation of the invoice. After the invoice is prepared, the first (and often a second) copy is sent to the customer.

    Another copy is sent to accounts receivable department where it is used to post the billing department. The keying of the relevant data into the system using a terminal credit checking is done automatically and all of the files are updated in one process, without reloading and resorting of tapes.

    The separate procedures being required basically, the real time system accomplishes, in a requiring manual intervention, in the batch processing system.

    The real-time system does have a major disadvantage with respect to control of data accuracy: there is only one point of entry of data at which the accuracy of data can be controlled the point of entry of data in to the system. If the system accepts inaccurate data, the chance to discover and correct the error before it contaminates all files documents, and reports is lost.

    However, in another sense, this fact is an advantage. It means that the control of data accuracy can be focused at a single point, the point of data entry, with the assurance, that if all errors are prevented there, no subsequent errors are likely.

    The first essential control feature of a real-time sales order processing system is the assignment of a unique user code to each sales persons. The user code numbers of each salesperson should be known only to that person. Each time the salesperson desire access to the system, the user code number is the item of data to be entered.

    The system should check the validity of the user code number before accepting any further instructions or data from sales person. Furthermore, each salesperson's user defines the transactions he or she is authorized to initiate and the files to which he or she is authorized to have access. A salesperson should be restricted to initiating only sales orders and inquiring only into the account receivable and finished goods inventory files.

    Another control feature over data entry into a real-time system is simplicity of operator data entry procedures. This might be affected by displaying an invoice format for the salesperson to fill in or by writing questions on the terminal that ask the sales persons for each required item of data.

    The system there by guides the salesperson through the data entry process and will not accept the order until all of the required data have been entered.

    One major form of data control which is lost in a real time is the batch total. Since transactions are entered one at a time as the occur, there is no such thing as a time as they occur, there is no such thing as a batch of input records in a real-time system. Responsibility for controlling the accuracy of data input in a real-time system therefore shift more heavily to data editing routines programmed in to the system.

    With respect to sales order data, the first of these should be a validity check on the customer account member and on the inventory stock number, of each item ordered. The system should accept orders from new customer's to whom no account number has been as signed, but should not initiate shipping papers until a credit check is performed.

    To assure that the salesperson does not enter a valid but incorrect account number or stock number, a redundant data check may be used. This would require that the salesperson also enter the first few letter of the customer name and the item description.

    The system could then check whether the number letters provides by the salesperson match with those in the customer name and item descriptions from the files and display these data back to the salesperson's terminal for verification.


    1.2 Statement Of The Problem

    This is actually faced with two major problems. They are:

    Designing and implementing an accurate, flexible and efficient sales recording system and designing and implementing a suitable, effective and adaptable accounting system for the organization.

    Both systems are interrelated by this; I mean that they cannot really be separated. The accounting system is like a sequel to the sales system. This is because all sales transactions must be brought and recorded in the account system.

    However, in this study, for the purpose of clarity and analysis, we shall treat them as two subsystems combining to make up the main system sales and accounting system.

    Within the context of these two major problems help to resolve the major problems placemeal. The includes:

    1. Analyzing and procedures for sales order and accounts information recording.
    2. What is the volume of business transactions being carried out by the company and how they can be accurately recorded?
    3. What data on sales and accounts will be required by management?

    1.3 Purpose Of The Study

    Due to the varied business transactions of the manufacturing companies, they needs to have and maintain an accurate and efficient sale order accounting record system. this need however is made impractical because of problems and inadequacies of the traditional manual recording and file system which is predominant in these companies.

    The purpose of this study is to provides a computer base-online and interactive software packages Accounts Master, that will accurately and efficiently record all such data and information. It will be computer-base so as to eradicate the numerous problems associated with the manual techniques.


    1.4 Delimitation

    Due to financial and time constraints, I restricted my work to Benny Brothers Electronics which is located in Ogui Road Enugu of all the various departments in the company, only three department were used in the research work. These are the accounting department sales department and computer department.


    1.5 Limitation Of Study

    Most companies do not comply to giving information about their business transactions due to security purposes. Also as a result of company regulations and policy, only special individuals are allowed access in to their computer section. Even when visitors are allowed access into this department, it must be an order from the management.


    1.6 Assumptions

    It is assumed that the software to be designed for this study will help companies a great deal in computing their sales accounts for the purpose of accountability.

    Finally, it is assumed that by computerizing sales accounts, companies will be better equipped to handle their day-to-day business transaction in a better and more organized manner.


    1.7 Definition Of Terms

    Business:

    Dealing commercial activity, a commercial or business concern.

    Company:

    Persons associated for trade, belonging to relating to or associated with a commercial company

    Compute:

    To ascertain by mathematical calculation estimate numerically, reaction also to take account of, consider

    Accounting:

    The act of recording classifying and summarizing commercial transactions in monetary terms.

    Sales:

    The act of selling, the exchange of real or personal property for money or its equivalent.

    Transaction:

    To conduct, to negotiate, to perform, to deal with to have to do with

    Transaction:

    The piece of business performed

    Ledger:

    This is the principal book of accounts of the organization or company, in which all the transactions or each day are entered under appropriate headings so as to show at a glance the debits and credits of each account.

    Invoice:

    A description list sent to a purchaser, or customer containing the items or goods together with the pieces and charges sent or to be sent to him.

    Credit limit:

    The amount above which a customer or client may not be given credit facility credit is to sell loan on trust

    Sales Forecast:

    Predicted or calculated statement of the probable sale for the month or year.

    Catalogue:

    It list or enumeration of goods generally in alphabetical order with their specification and explanatory additions.

    Balance Brought Forward:

    This is the amount brought forward from the previous transactions.

    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 a Computerized System for Sales Order Accounting



      NEED HELP? CALL US 24/7:
      +234 803 051 1988