Inventory System

Software Development


Inventory Management Process


User Management
  • Create New User
  • Set Password
  • Assign Rights for different Modules
    • Material Requisition Creation
    • Indent Creation/Updation/Print
    • Indent Authorization
    • P.O. Creation/Updation/Print
    • P.O. Authorization
    • GRN Creation/Updation/Print
    • Report Generation & Printing
  • Change Password
  • Disable Users



 Product Category Master
  • Add a new Category
    • Category Code
    • Category Name
    • Sub-category Name
  • Edit Category
  • Delete Category
    • Only when no products are defined under the given category



  Product Master
  • Add a new Product
    • Item Code
    • Item Name
    • Specification
    • Category
    • Sub-Category
    • Rate
    • Unit Of Measure
    • Opening Stock
    • Tolerance
    • Lead Time
    • Standard Pkg.
    • Edit an Item
  • Search for an Item
  • Delete a Product
    • If no entries have been made related to it.


  Unit Of Measures
  • Add a new UOM
    • UOM Code
    • UOM Name
  • Edit UOM
  • Delete Uom
    • Only when no products are defined with the given UOM



 Supplier Master
  • Add a new Supplier
    • Supplier Code
    • Supplier Name
    • Address details
    • Contact Person Details
    • Contact Details
    • Approval Date
    • Remarks
  • Edit a Supplier
  • Search for a Supplier
  • Delete a Supplier
    • If no entries have been made related to it.


 Indent
  • Indent Creation
    • Indent Code ( Auto generated )
    • Indent Date
    • List of ProductCode,Name,Quantity,UOM,Department
  • Indent Authorization
    • Displays the list of Indents pending for authorization
    • Here you can
      • Approve fully / Partially
      • Make changes in quantity and Approve
      • Reject ( Provide reason for rejection )
  • Pending Indent List
    • List of Indents for which P.O. has not been generated
  • Search for an Indent ( by Indent No/Date / Product Code / Name/Dept. )
  • Cancel an Indent
    • Indent once created cannot be deleted, but canceled.



 Purchase Order
  • P.O. Creation
    • P.O. No. ( Auto generated )
    • P.O. Date
    • Supplier Name
    • Indent No. ( Select from the list of pending indents )
    • List of ProductCode,Name,Quantity,UOM,Rate,Amount
    • Always shown last po rate when make po for product
    • Partially delivery schedule if applicable
  • P.O. Authorization
    • Displays the list of P.O.s pending for authorization
    • Here you can
      • Approve fully
      • Reject ( Provide reason for rejection )
  • Pending P.O. List
    • List of P.O.s for which GRN has not been generated
  • Search for an P.O. ( by P.O. No./Date/ Indent /Supplier /ItemCode / Name )
  • Edit P.O.
  • Cancel an P.O.
    • P.O. once created cannot be deleted, but canceled.


 G.R.N.
  • Creation of a G.R.N.
    • Select Supplier Name
    • Displays the list of P.O.s pending for GRN
    • Select a P.O. (Multiple / Single)
    • This will display the list of Items
    • Modify the quantity of each product
    • Save it.
  • G.R.N.s cannot be deleted or updated.
  • Search by Supplier Name, P.O. No, Item Code/Name.



 Selection of Indent in P.O.
  • While creating a P.O., the system
    • Displays the list of Pending Indents
  • There are two possibilities
  • Create Multiple P.O.s for a single indent
    • In case where we place orders with different parties for products listed in the indent.
  • Create a single P.O. for multiple indents
    • In case where we place a single order for products listed in different indents.


 Material Issue
  • New Material Issue
    • Issue Code ( Auto-generated)
    • Issue Date (Current Date/Time)
    • Department & Employee to whom it is issued.
    • List of Products (Product Code, Name, UOM, Quantity, Rate, Amount, Remarks)
    • In case of multiple rates in GRN, it will display a popup to select the effective price.
  • Search an Issual by Issue Code, Product Code/Name,Department, Employee.
  • Updation and deletion is not allowed.



 Physical Stock
  • Displays the list of products. We can search for a particular item(s) also and Category/Sub-category wise also.
  • Update the stock details and save it.
  • The system will store the username, date-time, old and new stock details.


 Reports
  • Requisition Register
  • Indent Register
  • P.O. Register
  • GRN Register
  • Material Issue Register
  • Stock In Hand Report
  • Stock Ledger
  • Pending Indents
  • Pending Purchase Orders.
  • Item List (All/Category / Sub-category)
  • Supplier List
  • (All the reports will have Search facility on certain criteria and print options)


 Document printing
  • Requisition Print
  • Indent Print
  • P.O. Print
  • GRN Print
  • Material Issue Print