inventory management system
TRANSCRIPT
![Page 1: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/1.jpg)
1
A Presentation On
Group No. : 51
Submitted By :Nikhil Chavda (MscIt-sem2)
Inventory Management System
![Page 2: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/2.jpg)
Purpose: Inventory Management System is
used for handling stock of items(Row-Material).
Any organization buy the material from any supplier.
Stock is updated by MRN and MIN. When stock is buy from supplier that
time stock is increased .So, MRN is used.
After then issue the material by any department of organization.
![Page 3: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/3.jpg)
Count ….
Before issue check the condition of 2-level:
1.Re-order level. 2.Safety level. These level are completed after then
issue the material. So,decreased the stock, then used MIN.
![Page 4: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/4.jpg)
Inventory management system is Maintain the stock.
Inserting the supplier,items,etc….when purchase.
Decrease the stock when issue the stock. Generate the three reports:
->Item Summary Report-> MIN Report-> MRN Report
Scope:
![Page 5: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/5.jpg)
5
Data Dictionary
![Page 6: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/6.jpg)
Column_Name Data_Type Constrain Description
Vendor_code Int(8) PK Unique identification number for identifying vendor
Vender_name Varchar(20) Not Null Name of vendor
vendor_Address Varchar(30) Not Null Address of vendor.
Contact_no Varchar(13) NOT NULL Contact number of vendor
Status Int(1) NOT NULL Set the status with vendor current or not.
1.Vendor:
![Page 7: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/7.jpg)
1.Vendor-Data:
![Page 8: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/8.jpg)
Column_Name Data_Type Constrain Description
department_code Int(8) PK Unique Identification number for identifying department
department_name Varchar(20) Not Null Name of department
status Int(1) NOT NULL Status is set after checking department is current or not.
2.Department :
![Page 9: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/9.jpg)
2.Department -Data:
![Page 10: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/10.jpg)
Column_Name Data_Type Constrain Description
Unit_code Int(8) PK Unique number for identifying units
Unit_Name Varchar(20) Not Null Name of unit.
Unit_shortname Varchar(5) Not Null Name of unit short name
status Int(1) NOT NULL Status is check after unit is required or not.
3.Unit
![Page 11: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/11.jpg)
3.Unit-Data
![Page 12: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/12.jpg)
Column_Name Data_Type Constrain Description
Item_code Int(8) PK Unique identification code of item
Item_Name Varchar(20) Not Null Name of item
Item_desc Varchar(30) Not Null Description of item
Unit_code Int(8) FK Code for unit which is referenced to unit table.
Reorder_Level Int(2) NOT NULL Check the stock when issue the item.
Safety_level Int(2) NOT NULL Check the stock when issue the item.
status Int(1) NOT NULL Check the Item.
4.Item
![Page 13: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/13.jpg)
4.Item-Data
![Page 14: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/14.jpg)
Column_Name Data_Type Constrain Description
Item_code Int(8) PK+FK Code of item which is referenced to item table.
Unit_code Int(8) FK Code of unit which is referenced of unit table
Qty_on_hand Int(8) Not Null Available quantity of item as on time.
Update_stock_date
Date Not Null Last update stock date on which qty is received or issued.
5.Stock
![Page 15: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/15.jpg)
5.Stock-Data
![Page 16: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/16.jpg)
Column_Name Data_type Constrain Descripton
MRN_No Int(8) PK Unique identification code of material receipt note.
Po_number Int(8) Not Null Purchase oreder number which is not null.
Vendor_code Int(8) FK Code of supplier referenced to supplier table.
Received_Date Date Not Null Date on which give the request for material.
6.MRN_Header
![Page 17: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/17.jpg)
6.MRN_Header-Data
![Page 18: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/18.jpg)
Column_Name Data_Type Constrain Description
MRN_No Int(8) PK+FK Code of material receipt note referenced to MRN_Header table.
Item_code Int(8) PK+FK Code of item which is referenced to item table.
Unit_code Int(8) FK Code of unit which is referenced to unit table.
Qty_Received Int(8) Not Null Total quantity received.
Price double Not Null Price of each unit of row material.
Amount double Not Null Total amount is quantity.
7.MRN_Detail
![Page 19: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/19.jpg)
7.MRN_Detail-Data
![Page 20: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/20.jpg)
Column_Name Data_Type Constrain Description
MIN_No Int(8) PK Unique number of material issue note.
Request_number Int(8) Not Null This number is not null which won’t be unique.
Department_code Int(8) FK Code of department referenced department table.
Issue_Date Date NotNull Date on which material is issued.
status Int(1) NOT NULL Check the MIN.
8.MIN_Header
![Page 21: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/21.jpg)
8.MIN_Header-Data
![Page 22: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/22.jpg)
Column_Name Data_Type Constrain Description
MIN_No Int(8) PK+FK Code of material issue note referenced to MIN_Header table.
Item_code Int(8) PK+FK Code of item which is referenced to item table.
Unit_code Int(8) FK Code of unit which is referenced to unit table.
Qty_issued Int(8) Not Null Total quantity issued to department.
9.MIN_Detail
![Page 23: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/23.jpg)
9.MIN_Detail-Data
![Page 24: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/24.jpg)
E-R Diagram
![Page 25: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/25.jpg)
VendorVendor_code
Vendor_name Vendor_address
contact_no
send the
material
Stock
check
available stock
no
not issue stock
yes
issueqty> re-order
level
PO Requesst
Department
send request
true
safety level>&&<re-
order level issue the stock
not issue stock
false true
false
department_code department_name
increse stock decrease stock
![Page 26: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/26.jpg)
26
Screen Short
![Page 27: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/27.jpg)
Login Page
![Page 28: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/28.jpg)
Home Page
![Page 29: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/29.jpg)
MRN Page
![Page 30: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/30.jpg)
MIN Page
![Page 31: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/31.jpg)
Supplier Page
![Page 32: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/32.jpg)
Item Page
![Page 33: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/33.jpg)
Department Page
![Page 34: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/34.jpg)
Unit Page
![Page 35: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/35.jpg)
Stock Page
![Page 36: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/36.jpg)
Re-order Level Report
![Page 37: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/37.jpg)
Report Page
![Page 38: Inventory Management System](https://reader035.vdocuments.us/reader035/viewer/2022062320/55d2fc0abb61eb59098b45d7/html5/thumbnails/38.jpg)
Thank You…