SupplyNet - Supply Chain Management System

12 Unique Dashboards

One tailored dashboard per role — Admin, Executive, Manager, Procurement, Warehouse Manager, Warehouse Staff, Finance, Sales, Logistics, Supplier Portal, Customer Portal, plus a generic fallback.

KPI Cards

Key metrics displayed as coloured cards: totals, active counts, outstanding values, alert counts — updated from live database queries.

Chart.js Charts

Executive dashboard: 30-day sales vs procurement bar chart. Finance: AR/revenue doughnut. Sales: 4-week order trend line chart.

Live Low-Stock Alerts

Procurement and Warehouse dashboards show real-time list of products below minimum stock level with direct links to raise POs.

Approval Queue

Manager and Admin dashboards display all pending approvals sorted by overdue status, with one-click links to review.

Quick-Action Buttons

Role-appropriate action buttons on every dashboard — e.g. New PO, New Sales Order, Start Cycle Count, Adjust Stock.

Portal Dashboards

Supplier and Customer portals show only data relevant to that specific company: their own POs, their own orders, their balance.

Multi-Warehouse

Manage any number of warehouses such as Main, Retail, Transit, and Returns. Each warehouse is configured with its own address, assigned manager, and independent stock zones.

Zone Management

Each warehouse can be divided into operational zones including Receiving, Storage, Picking, Shipping, and Quality. Every zone is assigned a unique code and functional type for structured workflow management.

Bin Locations

Zones can be further subdivided into bin locations using aisle, bay, level, and position coding. Each bin supports capacity management with defined weight and volume limits to optimize storage efficiency.

Default Warehouse

A single warehouse can be designated as the default for all new transactions, ensuring consistent stock movement routing across the system.

Negative Stock Control

Warehouse-level configuration allows administrators to either permit or block negative stock transactions based on operational policy and control requirements.

Location Barcodes

Every bin location can be assigned a unique barcode, enabling fast scanning during picking, receiving, and stock movement operations for improved accuracy and speed.

Count Sessions

Create counting sessions per warehouse with a specific count date. Sessions automatically pre-populate with all current stock lines.

Counting Sheet

Digital counting sheet with keyboard navigation (Enter key moves to next line). Auto-save every 2 minutes to prevent data loss.

Real-Time Variance

Variance column updates instantly as quantities are entered. Colour-coded: green for surplus, red for shortage.

Progress Tracker

Progress bar shows percentage of lines counted. Lines not yet counted are highlighted.

Variance Report

After completion, a full variance report lists all discrepancies grouped by impact. Exact matches shown separately.

Post to Stock

Posting a completed count creates inventory adjustment transactions to align stock levels with counted quantities.

Purchase Requisitions

Staff raise purchase requisitions that go through approval before converting to a PO. Includes priority, justification, and preferred supplier.

Purchase Orders

Full PO lifecycle: Draft → Submitted → Approved → Ordered → Partially Received → Received → Invoiced → Closed.

Supplier Price Comparison

SupplierProducts table stores each supplier's price, lead time, and minimum order quantity for each product.

Multi-Currency POs

Create POs in supplier's currency (e.g. USD, EUR) with automatic exchange rate capture.

Goods Receipt Notes (GRN)

Record goods received with quantity accepted, quantity rejected, and quality notes. GRNs update stock on posting.

Quality Check

GRN quality status: Passed, Failed, Partial Pass. Failed items go to the Returns warehouse.

3-Way Matching

PO → GRN → Invoice matching. Invoice status tracked: Pending, Partial, Invoiced.

Approval Workflow

POs above a configurable value threshold require manager/finance approval before being sent to supplier.

Supplier Performance

Track quality score, delivery score, and price score per supplier. Updated based on GRN outcomes.

Customer Database

Full customer master with contact details, addresses, payment terms, credit limit, and current balance.

Sales Orders

Complete SO lifecycle: Draft → Confirmed → Picking → Partially Shipped → Shipped → Delivered → Invoiced → Closed.

Sales Channels

Tag sales orders by channel: Manual, Online, Phone, Import. Useful for sales channel reporting.

Sales Representative

Assign a sales rep to each order. Sales dashboard shows rep's own orders and revenue only.

Customer Portal

Customers log in to see their own orders, delivery status, invoices, and outstanding balance — no internal data exposed.

Delivery Orders

Generate delivery orders from confirmed sales orders. Track carrier, tracking number, expected and actual delivery dates.

Customer Price Lists

Apply specific price lists to customers: Retail, Wholesale, VIP. Volume pricing with minimum quantity breaks.

Credit Control

Credit limit and current balance tracked per customer. Warning shown on new orders when limit is near.

Customer Contacts & Addresses

Multiple contacts and delivery addresses per customer. Mark one as default for each transaction type.

Supplier Master

Full supplier profile including code, name (EN/AR), tax number, payment terms, currency, credit limit, and lead time.

Supplier Types

Classify suppliers as Regular, Preferred, or Blacklisted. Preferred suppliers shown first in selection lists.

Contacts Management

Multiple contacts per supplier with job title, email, and phone. Mark primary contact.

Address Management

Billing and shipping addresses per supplier with default flag.

Supplier Products

Link products to suppliers with supplier-specific SKU, price, minimum order, and lead time. Mark preferred supplier per product.

Performance Scores

Quality, Delivery, and Price scores (0–10) tracked per supplier, updated from GRN outcomes.

Multi-category Hierarchy

Products organised in a two-level category tree (e.g. Electronics > Smartphones). Categories support Arabic names.

Product Variants

Support for product variants (size, colour, etc.) with individual variant codes, names, and additional cost per variant.

Multiple UOM

Three separate units of measure per product: stocking UOM, sales UOM, and purchase UOM, with conversion factors.

Barcode & QR Generation

Generate barcodes (Code128, EAN, UPC) and QR codes directly from the product page. Print-ready barcode labels.

Lot & Serial Tracking

Configure per-product whether to track by lot number, serial number, or expiry date. Full traceability from receipt to dispatch.

Image Upload

Upload and display product images. Supported formats: JPG, PNG, GIF, WebP.

Reorder Rules

Set minimum stock, maximum stock, reorder quantity, and lead time per product for automated low-stock alerts.

Costing Methods

Support for FIFO, LIFO, Weighted Average, and Standard costing per product.

Bulk Actions

Select multiple products to activate, deactivate, or export as CSV in a single action.

Price Lists

Multiple named price lists (Retail, Wholesale, VIP) with per-product pricing, minimum quantities, and date ranges.

Real-Time Stock Levels

Live view of on-hand, reserved, in-transit, and available quantities per product per warehouse. Computed columns for availability.

Stock Movements Log

Full audit trail of every stock movement: receipts, issues, transfers, adjustments. Filterable by product, warehouse, date, and movement type.

Multi-Warehouse Stock

Track stock independently per warehouse. Consolidated view across all warehouses with drill-down capability.

Low Stock Alerts

Dedicated page listing all products below their minimum level. Configurable email notifications sent to Warehouse and Procurement roles.

Inventory Adjustments

Create correction, write-off, and opening balance adjustments with a full variance report. Requires approval before posting.

Adjustment Workflow

Adjustments go through Draft → Pending → Approved → Posted. Posting updates stock levels and records the variance cost.

Average Cost Tracking

Weighted average cost updated automatically on every goods receipt. Used for inventory valuation and profit reporting.