The project titled as “Provision Store Management” is an application which is helpful for a Store manager to maintain the daily activities of the store. A general store is a place where excess commodities are kept which will be used as and when required. Loss of items, deterioration, obsolescence and inadequacy are treated as ‘part of life’. Thus, the store management is an essential process where in these commodities should be received, protected from damage, to sell items in right quantities to the customers at right time and to provide service promptly and at least cost. To maintain a general store is not an easy task when it’s done manually and needs more effort to analyze the growth of business.
General Store Solution is an adaptable software solution to be developed for general stores or any other stores of similar type. This solution should ease the processes such as stock maintenance, billing and report generations.
1.1 Motivation
The project ‘Provision store Management Solution’ allows the store manager to handle day to day activities at the store and reduces the human errors in calculations.
1.2 Objective of the Project
To computerize the store.
Help manager to keep track of all the product at his store.
Billing takes more time and calculation which is to be reduced so that he can server more customers.
Report generation facility provides actionable insights to store manager in decision making by understanding the market trends and customer behaviours to plan great business strategies.
1.3 Problem statement
Non-computerized environment.
Excess commodities at store have to be managed and it’s difficult to keep track of products and introduce new products.
Manual accounting and billing may lead to loss due to human errors in calculations.
It’s difficult to make business strategies and implement in store as more labours need to be maintained for serving customers and billing process takes more time.
Store manager does not know when to refresh his inventory.
Unable to find out the growth in his business.
1.4 Scope of the Dissertation Report
This report is of very much important in order to observe and analyze carefully all the technical aspects of the system thoroughly. The report emphasizes on variety of other features of the system. It is organized in such a manner that each and every common man can understand and study the details of the project. Every features along with system design, database design and snapshots are included in the report to have a clear picturesque description of our project.
1.5 Outline of Dissertation Report
The Project Report is encompassed with 9 chapters in total and it is organized as follows:
Chapter -1
Introduction:
This section gives the introduction of our project “Provision Store Management Solution”.
Chapter- 2
Literature Survey:
This section describes about the Literature Survey.
Chapter 3
Hardware and Software Requirement:
This section gives the information about Requirement Analysis.
Chapter 4
System Design Architecture:
This section gives the information about System Design Architecture.
Chapter 5
Implementation:
This section gives the information about Implementation of my project.
Chapter 6
Testing:
This section gives the information of how testing is done.
Chapter 7
Conclusion and Future Enhancement:
This section gives the information of Conclusion and Future scope.
Chapter 8
Bibliography:
This section gives the information about the references.
Chapter-2
Literature survey
A general store is a place where excess commodities are kept which will be used as and when required. Loss of items, deterioration, obsolescence and inadequacy are treated as ‘part of life’. Thus, the store management is an essential process where in these commodities should be received, protected from damage, to sell items in right quantities to the customers at right time and to provide service promptly and at least cost. To maintain a general store is not an easy task when it’s done manually and needs more effort to analyze the growth of business.
Store management solution is very needy for general stores. This software help them maintain day to day transaction in a computer. The main goal of this application is to maintain the records of Sales and accounts with cash transaction maintenance, billing and report generation that helps the store manager in making business decisions.
To computerize the store.
Help manager to keep track of all the product at his store.
Billing takes more time and calculation which is to be reduced so that he can server more customers.
Report generation facility provides actionable insights to store manager in decision making by understanding the market trends and customer behaviours to plan great business strategies.
Chapter- 3
Hardware and Software Requirement
3.1 Requirement Analysis
Provision Store management solution is very needy for general stores. This software help them maintain day to day transaction on a computer. The main goal of this application is to maintain the records of Sales and accounts with cash transaction maintenance, billing and report generation that helps the store manager in making business decisions.
The scope of this project is to provide the following features:
• To computerize the store.
• To help in managing inventory of the store helps manager to keep track of all commodities.
• To help store manager during bill generation for the commodities sold.
• Report generation can provide actionable insights to store manager in decision making by understanding the market trends and customer behaviors to plan great business strategies.
Modules
• Login: This module is used to login to the existing account.
Input : user name, password.
Output : Authorized page will be displayed.
Processing: If the password or the user name is wrong then appropriate error message will be displayed.
• Home: This module is used to Link all the other feature modules.
Input : Mouse Click on the menus.
Output : Selected module displayed.
Processing: Redirected to the selected module.
• Supplier Master: This module is used to Store details about Supplier.
Input : Supplier Name, tin number, Address and phone.
Output : Supplier details will be added in the list
Processing: if the Supplier detail already exists then error message will be displayed
• Item Master: This module is used to S
tore details about Items.
Input : Category, Item Name, SupplierID, Selling Price, VATRate.
Output : Item will be added in the list.
Processing: if the Item detail already exists then error message will be displayed.
• Category: This module is used to Store Category.
Input : Category Name, Unit of measure.
Output : Category will be added in the list.
Processing: if the Category detail already exists then error message will be displayed.
• Purchase Register: This module is used to Store details about the purchase.
Input: Supplier Name, Tin Number, Item Name, Purchase Price, Quantity.
Output: Purchase details Stored.
Processing: VATRate, VAT Amount and Net Amount Calculated.
• Sales Register: This module is used to Store details about the Sales.
Input: Customer Name, Phone, Item Name, Purchase Price, Quantity.
Output : Sales details Stored.
Processing: VATRate, VAT Amount and Net Amount Calculated.
Reports
• Sales Report: This module is used to display report on date wise Sales transaction.
Input : From Date, To Date.
Output : Sales Report displayed.
Processing: Generate report within the specified date and raise an error message if from-date in greater than to-date.
• Purchase Report: This module is used to display report on date wise Purchase transaction.
Input : From Date, To Date.
Output : Purchase Report displayed.
Processing: Purchase report within the specified date and raise an error message if from-date in greater than to-date.
• VAT Report: This module is used to display report on date wise VAT Report.
Input : From Date, To Date.
Output : VAT Report displayed.
Processing: Generate report within the specified date and raise an error message if from-date in greater than to-date.
3.1.1 Software Requirement Specification
• Front End: Visual C#.Net.
• Backend: Microsoft SQL Server 2014.
• OS: Windows 7, 8 or higher.
3.1.2 Hardware Requirement Specification
• 2GB RAM or more.
• 2GB Hard disk space.
• LCD Monitor.
• Mouse and Keyboard.
Chapter -4
System Design Architecture
4.1 Entity Relationship Diagram
The entity relationship diagram realizes various relationships among entities, by considering each object as an entity.
ER-MODELING consists of:
Entity:
Entity is an object in which we want to store the information. It is an elementary building block of storing information about all the business processes. Entities are distinct thing in the enterprise.
Relationships:
A relationship is an association used to relate two or more entities with some common attributes or meaningful interaction between the objects.
Attributes:
Attributes are properties of the entities and the relationships that are description of the entity. Attributes are elementary pieces of information attached to entity.
4.1 ER-Diagram
Figure-4.1.1
4.2 Data Flow Diagram
LEVEL-0: (Context Flow Diagram)
Figure-4.2.1
LEVEL-1:
Figure-4.2.2
LEVEL-2:
Figure-4.2.3
4.3 Class Diagram
Figure-4.3.1
4.4 Sequence Diagram
Sequence diagram for Admin processing:
Figure-4.4.1
4.5 Use Case Diagram
Figure-4.5.1
4.6 Activity Diagram
Chapter-5
Implementation
Login
Home
Supplier Master
Category
Purchase Register
Sales Register
Sales Report
Purchase Report
VAT Report
Chapter-6
Testing
Testing is the process of running a system with an intention of finding out the errors.
Login Panel Testing
Supplier Register Panel Testing
Category Panel Testing
Purchase Register Panel Testing
Sales Register Panel Testing
Report Panel Testing
Chapter-7
Conclusion and Future Enhancement
The main objective of “Provision Store Management Solution” is to reduce the human work. The system minimizes the tasks performed to a certain extent. Updating information to the system is easy and equipped with an easy interface design. Reporting is one of the features that enhances the capabilities of a store manager to make decisions.
• To the Individual:
Ease of access to the system.
Ease the maintenan
ce of the store.
Less man power needed to serve customers.
• To the Society:
Customers are served quickly and more customers can be handled.
Future scope:
Server centric (data stored in one location).
Mobile centric (accessible through mobile devices).
Thin client and fat server (service oriented approach).
Chapter-8
Bibliography
The Following are the books and the references that were referred during the development period of the project:
Igor Hawryszkiewyez- Introduction to system analysis and design, 4th edition.
Published by Asoke K.Ghosh, Prentice Hall of India Private Limited.
Pankaj Jalote – An integrated approach to software engineering – 1991
Edition- Narosa Publishing House, New Delhi
Simon Robinson – Professional C#, 3rd Edition.
C# Programming Language by E.Balaguruswamy
Bill Evjen, Bill Hollis, Sheldon, Sharkey – Visual Basic 2008.
Wiley Publishing Inc., New Delhi, Visual Basic Studio, working with Windows.