Masterkey Inventory Management System

The system will also provide various reports to get details relating to the inventories.

Below you can find the complete details of what the application does.

Product Summary:

The whole application is divided into six major modules.

• Administrative / Master Entry Section Module
• Managers Dashboard Module
• Transaction Module
• Reporting Module
• Queries Module
• Email Alert System Module

01. Administrative / Master Entry Section Module

In this section the application helps to control all the work of an Administrator like managing users and providing different access permissions, managing vendors, categories etc. The major heads that we will consider in this development under the heading of Administrative Entries / Master Entries are as follows:

• Users
• Departments (within the Banks)
• Vendors
• Category Set Up
• Unit Type Set Up
• Packing Type Set Up
• Stores Set Up
• Inventory Set Up

02. Managers Dashboard Module

The privilege of this section is given to the Managers of the Bank who have the authority to monitor the total process. In this section we will work on a web page that will be called as Manager’s Dashboard. The reason to separate this as a different module is that, the graphical representation of whole data of an inventory management system requires some time to be complete.

Though this module is stated as number 2, but we will implement this module at the final stage of the project. Because unless and until we have a whole set of data ready the implementation of this module will not be feasible and achievable.

03. Transaction Module

This section will be dealing with all the transactions related events like purchasing new inventory, issue, return, damaged and expired inventory and updating the store or more than one store as required. The activities that will be done in this section are as follows.

• Department Request / Response (Acknowledgement)
• Purchase Order
• Items Received
• Record Inventory
• Issue Items
• Item Return
• Update / Amend Inventory Details
• Returned Inventory
• Damaged Inventory
• Destroyed Inventory
• Expired Inventory

04. Reporting Module

This section will do all the reporting parts of project, with export and print option available. The complete details of the reports that will be covered and generated by the system are as follows.

• Full Inventory Report - For the entire Inventory information that GSD may choose any Inventory to get the full information about it.
  
  
• Inventory History Report - GSD will be able to view all the movement of the Inventory, from the store to the departments, along with any returns from the departments and returned to Vender.
  
  
• Inventory Status Report - That will show all the status of the Inventory (Sent to Vender / Returned from Department / Damaged in Store / Destroyed / Expire) with a detailed history of the dates and previous status.
  
  
• Stores Report - This report will show all the details of the stores and the inventories in each store, with its location.
  
  
• Low Level Inventory Report - This report will be used to view the entire Inventory that reached the low level, and need to be re – ordered.
  
  

• Re – Ordered Inventory Report - To view all the details of the Inventories that had been re – ordered from the vender.
  
  

• Category Report - This report will allow GSD to view all the Categories that are registered in the system.
  
  

• Brands Report - This report will allow GSD to view all the Brands that are registered in the system.
  
  
• Request Report (Departments Report) - To view all the requests that had been sent from the departments, and to show all the information related to that request.
  
  
• Request Status Report - This report will show all the Request status (Available in Store / Pending /Canceled / Ordered / Delivered) with a detailed history of the dates and previous status.
  
  

• Purchase Report - To view all the Purchase orders details that GSD will be able to see all the Information of the Purchases that had been generated for the Bank.
  
  

• Vender Report - This report is to show the details of the Venders along with the full details of the inventories that had been purchased from them.
  
  
• Pricing Report - This report is to show the prices of the inventories that have been purchased, along with the prices of each Department order.
  
  
• Unit Type, Pack Type Report - These reports will allow GSD to view all the Unit Types / Pack Type that are registered in the system.
  
  
• Item Stocks - These reports will allow GSD to view all Items with stock information
  
  
• User Activity Report - These reports will show all the activities of a particular user for a particular period.

05. Queries Module

In this section the users will be allowed to retrieve information and records history from the system, and the information that will be generated is as follows.

• Department Information
• Department Order Information
• Inventory Information
• Inventory Ordering Details
• Department Request Information
• Inventory Status Information
• Purchase Order Information
• Category Information
• Unit Type Information
• Pack Type Information
• Store Information
• Vendor Information

06. E-Mail Alert System Modules

In this section different alerts will be sent to the email id of different users specifying / notifying the details of the alert that has been generated by the system.
The following are the conditions when an email alert will be sent to the Supervisor.

• When the stores clerk issue an item (To Supervisor)
• When the stores clerk return an item (To Supervisor)
• When the stores clerk adjust an item (To Supervisor)
• When User places a purchase order (To Supervisor)
• When purchase order is approved (To user who placed the order)
• On user request for a particular item in the store (To Supervisor)
• When an item in the stores reaches its threshold value (danger level) (To Supervisor)

Product Description:

In total there are 7 types of users who runs the application. The complete application process is handled by these users like some pages are accessible by some users and some are not. One can say there are in total 4 types of section which completes the total application life cycle.

• Master Entry Section
• Transaction Section
• Reports Section
• Queries Section

The following are the types of users available with the system.

• Admin
• Manager
• Department Supervisor
• Department User
• Store Supervisor
• Store Clerk
• Read Only User

Master Entry Section:

In this section the user generally creates all the master entries of the application like department, store, vendor, item etc. This section is accessible by Admin and Store Supervisor.

Transaction Section:

This section deals with item purchase request, item issue request, to mark an item as damaged, destroyed, expired etc. This section is accessible by all users except Admin and Read Only User.
The in depth analysis of transaction section will be analyzed later on.

Reports Section:

This section meant for all types of reports viewing that are discussed above. Users can view the reports, can print them and also can export the data to an excel sheet if needed.

Queries Section:

This section is also like report. But this is only for viewing. No print or export option is there.