Inventory Management System Project: Sales, Purchase, Stock Details

This document presents an Inventory Management System (IMS) project designed for small to medium-sized organizations. The project addresses the need for efficient stock management, sales, and purchase tracking. The system utilizes a desktop-based application developed using Visual Basic and the .NET framework. The project includes a detailed problem statement, outlining the challenges of existing inventory management systems and the project's objectives, such as creating an easily managed and secure system covering all IMS areas. The document covers system design specifications, including use case diagrams, context diagrams, information flow diagrams, and an Entity-Relationship Diagram (ERD). Screen designs, hardware specifications, and sample code are provided, including code snippets for order records and form designs. The implementation details include form designs, and code for key functions like loading data, filtering records, and user authentication. The project's scope is limited to organizations with a single point of authority and offers security features, with the warehouse details can be added as per the requirement.

Running Head: Inventory Management System
Institution
Date
Name
Introduction

2
1. Problem Statement
After analyzing many existing Inventory Information Management Systems, we
pretty have a clear vision of the kind of the project we can develop to carter all the
existing problems in the field of keeping and selling stock in any business. Before we
started to build this project our team has made intense research on technology and
business (Coffman, Vanderveen & Schlotterbeck, 2017). There were several
constraining factors encountered in the development process of the system despite its
completion. These factors included:
Time consuming: A lot of time is spent especially during data collection,
development and completion of this project and learning of visual basic as the
programming language in use.

3
Cost-the cost of materials that are important to the development and completeness
of the project, especially in coming up with this proposal are enormous. The overall
development and design of the system is costly as evidenced in the budget.
The targets however were:
To make desktop based application of IMS for a small business.
To make the system easily managed and can be secured.
To cover all the areas of IMS like purchase details, sales details and stock
management.
Current state of Technology/Literature Review
Software products are considered as the business assets for any organization. This
incorporates dealing with the products with fitting approach to audit whenever
according to the company's prerequisites. Subsequently it is vital to have a PC based
IMS which can produce reports, keep up the equalization of the stock, insights
regarding the purchases and sales in the association. Before building up this
application we thought of 2 Stock Management System existing in the market, which
gave us the learning for the advancement of our venture (Zelm, Doumeingts &
Wollschlaeger, 2018). These applications we checked were being utilized by the vast
organizations however, we developed one which can be utilized by the little
organizations for the administration of their stock in the Warehouses. In the wake of
breaking down the other stock administration frameworks we chose to incorporate a
few of normal and key highlights that ought to be incorporated into each stock
administration framework. So we chose to incorporate those things that assistance the
little association in a way or another.

4
Objectives
Primary objectives
The primary objectives of the project are mentioned below:
To fulfill the requirement for achieving the Bachelor’s degree of Computer
Information System
To know the fundamentals of the .Net Technology and Visual Studio with
the .Net Framework
Secondary objectives
The secondary objectives of this project are mentioned below:
To develop an application that deals with the day to day requirement of any
production organization
To develop the easy management of the inventory
To handle the inventory details like sales details, purchase details and balance
stock details.
To provide competitive advantage to the organization.
To provide details information about the stock balance.
To make the stock manageable and simplify the use of inventory in the
Organization Scope and Limitation
This Inventory Management System (IMS) is targeted to the small or medium
organization

5
which doesn’t have many godwom or warehouses i.e. only to those organization
that has single power of authority. Some of the scope are:
Only one person is responsible in assigning the details or records
It is security driven.
The warehouse can be added as per the requirement.
2. System Design Specification
Use Case Diagram
Its motivation is to show a graphical outline of the usefulness given by a system
as far as performing artists and their objectives.
The fundamental reason for an utilization case chart is to demonstrate what
framework capacities are performed for which on-screen characters See beneath

6
Context Diagram
Information Flow Diagram
Process Flow Diagram or Flowchart is a chart which utilizes geometric images
and bolts to characterize the connections. It is a diagrammatic portrayal of the
calculation (Mehta, Puranik & Sharma, 2016).The Process stream Diagram for the
data flow of our Inventory System application is appeared as follows.
ERD

7
3. System Implementation
Screen Design

8
Orders

9
Order Records
Hardware Specification
Windows: We suggest Windows 8.1 or later* however the framework has been
effectively conveyed on variants as ahead of schedule as Windows 7. NOTE: Some
customers utilizing Windows XP and Vista might encounter issues with equipment
drivers (Laudon, 2016).
CPU: Windows - Pentium 4 or better. Macintosh - Any x86 processor or better.
Slam: 2GB least, 4GB suggested.
Capacity: At least 1GB of hard circle space.
Ports: At least one USB 2.0 or better port*. It isn't prescribed to attempt and
utilize equipment that associates by sequential port or parallel port with our
framework.
Internet connection: A broadband association speed with respect to no less than 5
- 10 Mbps is recomended when sharing the system remotely. You can test your

10
association speed by going to SpeedTest.net. Be mindful so as to keep away from
notices; the catch that begins the test says Begin Test.
Sample code
Creates a form For all order Records and Search
Imports System.Data.OleDb
Imports Excel = Microsoft.Office.Interop.Excel
Public Class frmOrderRecord1
Dim rdr As OleDbDataReader = Nothing
Dim dtable As DataTable
Dim con As OleDbConnection = Nothing
Dim adp As OleDbDataAdapter
Dim ds As DataSet
Dim cmd As OleDbCommand = Nothing
Dim dt As New DataTable
Dim cs As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|
DataDirectory|\BackUp\Sample.accdb;Persist Security Info=False;"
Private Sub frmOrderRecord1_FormClosing(ByVal sender As Object, ByVal e
As System.Windows.Forms.FormClosingEventArgs) Handles Me.FormClosing
Try
Me.Dispose()
frmOrder.Show()
Catch ex As Exception

11
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK,
MessageBoxIcon.Error)
End Try
End Sub
Private Sub frmOrderRecord1_KeyDown(ByVal sender As Object, ByVal e
As System.Windows.Forms.KeyEventArgs) Handles Me.KeyDown
e.SuppressKeyPress = e.Control
If e.KeyCode = Keys.Enter Then
SendKeys.Send("{tab}")
End If
End Sub
Private Sub frmOrderRecord1_Load(ByVal sender As System.Object, ByVal e
As System.EventArgs) Handles MyBase.Load
fillCustomerName()
fillorderNo()
fillProductName()
End Sub
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button2.Click
Try
con = New OleDbConnection(cs)
If con.State = ConnectionState.Open Then

12
con.Close()
End If
con.Open()
cmd = New OleDbCommand("SELECT (OrderInfo.OrderNo)as [Order
No],(OrderDate)as [Order Date],(OrderStatus) as [Order Status],(CustomerName) as
[Customer Name],(ProductCode) as [Product Code],(ProductName) as [Product
Name],(Length) as [Length],(Height) as [Height],(Area) as [Area],(AreaUnit) as
[Area Unit],(Quantity) as [Quantity],(UnitPrice) as [Price],
(OrderedProduct.TotalAmount) as [Total Amount] from orderinfo,orderedproduct
where orderinfo.orderno=orderedproduct.orderno and OrderDate between '" &
dtpOrderDateFrom.Value & "' and '" & dtpOrderDateTo.Value & "' order by
orderinfo.OrderNo,OrderDate", con)
Dim myDA As OleDbDataAdapter = New OleDbDataAdapter(cmd)
Dim myDataSet As DataSet = New DataSet()
myDA.Fill(myDataSet, "OrderInfo")
myDA.Fill(myDataSet, "OrderedProduct")
DataGridView1.DataSource =
myDataSet.Tables("OrderInfo").DefaultView
DataGridView1.DataSource =
myDataSet.Tables("OrderedProduct").DefaultView
con.Close()