LAN Based Canteen Management System

  • Version
  • Download 1557
  • File Size 2.90 MB
  • File Count 1
  • Create Date May 9, 2018
  • Last Updated May 11, 2018

LAN Based Canteen Management System

LAN Based Canteen Management System


  1. To develop a computerized Canteen Management System required by the company.
  2. Below are the coverage of the System:


  • Direct Sales (POS)
  • Sales Report

Products/Stock Control:

  • Product Categories
  • Product Details
  • Stock Monitoring.
  • Products out of stock
  • Product adjustment

Canteen Stock-in and POS Module
Canteen Stock-in and POS Module


  • Suppliers Details (optional)

Employees (Users):

  • Employee Details
  • Employee Permissions

Accounting System:

  • Accounts Details
  • Bills
  • Customizations may be requested by the client within the period of the system.

Canteen Stock-in and POS Module
Canteen Stock-in and POS Module

Canteen Inventory Module Report
Canteen Inventory Module Report

Database schema

productcategory (foods=0, goods=1)

tblproduct(id, name, description, sellingprice, initialqty, categoryid, supplierid, sflag(0,1))

tblsupplier(id, suppliername, contact, address, sflag(0,1))

tblemployee(id, idno, lastname, middlename, firstname, contact, sflag(0,1))

tblstockin(id, productid, qty, subtotal, total, date, userid)


tblsales(id, productid, employeeid, qty, subtotal, amount, date, payment(cash,credit), userid)


tbluser(id, username, password, fullname, accounttype, sflag(0,1))

Inventory Formula

itemsOnHand = (tblproduct. initialqty + tblstockin.qty) – tblsales.qty


  • Sales report
  • Inventory report
  • Collectibles
  • lowStocks Notification
  • most product sold

Development Tools:

Visual Basic and MySQL (XAMPP)


  1. upload the database to your mysql server (nonecoschemadb.sql)
  2. install mysql connector
  3. install/register the ocx and dll of the project using the regsvr32 command
  4. open the exe file (inventory.exe)

Login Credentials

username: admin

password: admin

please message us if you have questions or problems during the installation process

, , , , , , , , , , , , , , , , , , , , ,

Post navigation

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.