A multi-tenant SCM application built with Django and Bootstrap 5.
- Backend: Django 4.2 LTS, Python 3.10+
- Database: MySQL (MariaDB via XAMPP)
- Frontend: Bootstrap 5.3, jQuery, Remix Icons
- Multi-tenancy: Shared database with login-based tenant isolation
- Config: python-decouple for environment variables
The technical backbone enabling the SaaS/Multi-tenant nature of the application.
- Tenant Onboarding - Automated provisioning of new tenant environments and databases
- Subscription Management - Management of pricing plans, billing cycles, and feature access per tenant
- Role-Based Access Control (RBAC) - Granular permission settings for users within each tenant
- Theme & Customization - White-labeling options allowing tenants to apply their branding/logo
- Audit Logs & Security - System-wide logs for data access, changes, and security incident monitoring
Manages the purchasing of goods and services to ensure cost-effectiveness and timely delivery.
- Purchase Requisition - Internal requests for goods with approval workflows (draft → pending → approved/rejected), priority levels, and line items with estimated pricing
- Request for Quotation (RFQ) - Creation and distribution of RFQs to multiple vendors, quote comparison matrix, and vendor response tracking
- Purchase Order (PO) Management - Generation, approval, amendment, and cancellation of purchase orders with line item tracking and partial receipt support
- Vendor Portal - Vendor contacts, PO acknowledgement, and shipment status tracking (preparing → shipped → in transit → delivered)
- Invoice Reconciliation - Three-way matching of Purchase Order, Goods Receipt Note (GRN), and Vendor Invoice with automated quantity and price matching
- Vendor Management - Vendor master data with contact details, payment terms, tax ID, and activity tracking
- Item Catalog - Categorized item/service catalog with unit of measure, pricing, and active/inactive status
Manages the full supplier lifecycle from onboarding and qualification through performance evaluation, contract management, and risk mitigation.
- Supplier Onboarding - Structured vendor qualification workflow (draft → in progress → under review → approved/rejected) with qualification questionnaires and due diligence checks (financial verification, legal compliance, quality certification, insurance, reference checks, site inspection)
- Supplier Scorecards - Periodic vendor performance evaluation across four dimensions (delivery, quality, price, responsiveness) with auto-calculated overall scores and ratings (excellent → poor)
- Contract Management - Full contract lifecycle for master agreements, purchase agreements, service agreements, NDAs, and SLAs with milestone tracking, document management, auto-renewal alerts, and multi-currency support (USD, EUR, GBP, PKR, AED, SAR, INR, CNY)
- Supplier Catalog Management - Vendor-specific product catalogs with supplier part numbers, pricing, minimum order quantities, and lead times linked to the procurement item catalog
- Risk Assessment - Comprehensive supplier risk evaluation across financial, geopolitical, compliance, and operational dimensions with likelihood/impact scoring, risk factor identification, and mitigation action tracking with assignments and due dates
Manages stock levels, warehouse operations, and inventory valuation across multiple locations.
- Warehouse Management - Multiple warehouse types (main, branch, transit) with zone-based locations (receiving, storage, picking, shipping)
- Stock Control - Real-time stock tracking per item/warehouse/batch with on-hand, reserved, and available quantities
- Warehouse Transfers - Inter-warehouse stock movement with approval workflow (draft → pending → in transit → received)
- Stock Adjustments - Inventory corrections for write-offs, damage, cycle counts, corrections, and returns with approval flow
- Reorder Automation - Configurable reorder rules with safety stock, lead times, and auto-generated reorder suggestions
- Inventory Valuation - Stock valuation using FIFO, LIFO, or Weighted Average methods with per-item breakdown
Controls the physical operations within the warehouse.
- Bin/Location Management - Granular storage bin tracking within warehouses with zone, aisle, rack, shelf positioning, bin types (bulk, pick, reserve, staging, dock), and capacity/utilization monitoring
- Inbound Operations - Dock appointment scheduling (scheduled → checked in → receiving → completed), receiving order processing with line items and put-away destination, and put-away task assignment with source/destination bin tracking
- Outbound Operations - Pick list management with picking strategies (wave, batch, zone, single) and priority levels (low → urgent), packing order workflow (pending → packing → packed → shipped), and shipping label generation with carrier, tracking, and destination details
- Cycle Counting - Scheduled count plans with configurable frequency (daily, weekly, monthly, quarterly) and count types (ABC analysis, location-based, random sample, full count), individual cycle count sessions with item-level variance tracking
- Yard Management - Yard location mapping (dock doors, parking spots, staging areas, gates) with occupancy tracking, and yard visit management for trucks/trailers with full status workflow (expected → checked in → at dock → loading/unloading → completed → departed)
Centralizes the processing of orders from various sales channels.
- Customer Management - Customer master data with contact details, billing/shipping addresses, credit limits, and order history tracking
- Sales Channels - Multi-channel order capture configuration (website, marketplace, phone, EDI, manual) with channel-specific tracking
- Order Processing - Full order lifecycle management (draft → pending validation → validated → allocated → in fulfillment → shipped → delivered) with priority levels (low → urgent), hold/release/cancel workflows, and line item tracking with automatic total calculation
- Order Validation - Multi-type validation checks (credit check, inventory check, fraud check, address verification) with pass/fail/warning results and audit trail
- Order Allocation - Logic-based assignment of orders to fulfillment centers using configurable methods (nearest warehouse, lowest cost, highest stock, manual) with line-item allocation tracking
- Backorder Management - Automated tracking of out-of-stock order items with fulfillment status (pending → partially fulfilled → fulfilled), expected dates, and cancel workflows
- Customer Notifications - Notification management for order lifecycle events (confirmation, validation, shipping, delivery, backorder alerts, cancellation) via email, SMS, or both with send status tracking
Plans, executes, and optimizes the physical movement of goods.
- Carrier Management - 3PL partner management with carrier types (FTL, LTL, parcel, air/ocean freight, rail, courier), contact details, ratings, and rate cards with multi-currency support and configurable unit pricing
- Rate Cards - Carrier-specific rate management with origin/destination lanes, transport modes, rate per unit (kg, CBM, pallet, container, flat rate), minimum charges, transit days, and validity periods
- Route Planning - Delivery route optimization with origin/destination, distance tracking, estimated travel time, waypoint management, fuel and toll cost estimates, and route activation workflow (draft → active → inactive)
- Shipment Tracking - Full shipment lifecycle management (draft → booked → picked up → in transit → at hub → out for delivery → delivered) with carrier assignment, route linking, GPS/location tracking events, priority levels, and real-time status updates
- Freight Audit & Payment - Freight bill verification against shipments with line-item charge breakdown (base freight, fuel surcharge, handling, insurance, customs, toll, accessorial), audit workflow (draft → pending review → approved/disputed → paid), dispute management, and payment reference tracking
- Load Optimization - Cargo loading plans for vehicles/containers (20ft/40ft trucks, containers, vans, flatbeds, refrigerated, bulk) with weight/volume capacity tracking, utilization percentage calculation, load sequencing, and loading workflow (draft → planned → loading → loaded → closed)
Uses data to predict future demand and align supply accordingly.
- Sales Forecasting - Statistical forecasting based on historical sales data with multiple methods (moving average, exponential smoothing, linear regression, manual entry), approval workflow (draft → submitted → approved → active → archived), line-item forecasts with actual vs. forecasted variance tracking and confidence levels
- Seasonality Analysis - Per-item seasonal demand profiles with 12 monthly adjustment factors, linked promotional events (holiday, promotion, clearance, product launch, seasonal) with configurable demand impact multipliers and date ranges
- Demand Sensing - Short-term demand signal tracking from multiple sources (market trends, competitor actions, weather, economic indicators, social media, customer feedback, POS data), impact level assessment (low → critical), and signal lifecycle management (new → analyzed → incorporated/dismissed)
- Collaborative Planning - Cross-functional planning interface for sales, marketing, finance, and operations teams with plan types (sales/marketing/finance/operations/consensus), approval workflow (draft → submitted → review → approved → finalized), optional forecast linking, line-item planning, and threaded discussion comments
- Safety Stock Calculation - Dynamic buffer stock calculation using multiple methods (fixed quantity, percentage of demand, statistical Z-score, demand-based) with per-item/warehouse inputs (average demand, demand std deviation, lead time, lead time variability, service level), automated safety stock and reorder point computation, and one-click application to inventory reorder rules
Manages the transformation of raw materials into finished goods for manufacturing tenants.
- Work Centers - Machine and workstation registry with types (machine, assembly line, manual station, testing station, packaging), hourly capacity and cost tracking, and active/inactive status management
- Bill of Materials (BOM) - Product component definitions with version control, status workflow (draft → active → obsolete), line items specifying raw materials with quantities, units of measure, and scrap percentage allowances, plus automated component cost and unit cost calculation
- Production Scheduling - Planning of production runs with status workflow (draft → planned → in progress → completed/cancelled), schedule line items linking products to BOMs and work centers with planned start/end times and priority levels (low → urgent)
- Work Order Management - Shop floor work order lifecycle (draft → released → in progress ↔ on hold → completed/cancelled), BOM and schedule linking, planned vs. actual quantity tracking with completion percentage, scrap rate calculation, operation sequencing with per-operation status and efficiency tracking
- Material Resource Planning (MRP) - Automated material requirement calculation that explodes BOMs from active work orders, checks on-hand inventory and open purchase orders, computes net requirements, and generates planned order dates within a configurable planning horizon
- Shop Floor Control - Production activity logging with log types (production, downtime, setup, maintenance, quality check), operator assignment, start/end time tracking, quantity produced vs. rejected, duration calculation, and yield rate monitoring
Ensures products meet quality standards and regulatory requirements.
- Quality Inspection - Reusable inspection templates with configurable criteria (visual, dimensional, functional, chemical, electrical, mechanical), actual inspection records with status workflow (draft → in progress → completed/failed/on hold), per-criteria pass/fail/warning results with measured values, pass rate calculation, and lot number tracking
- Non-Conformance Reports (NCR) - Defect documentation with source tracking (incoming inspection, in-process, final inspection, customer complaint, supplier issue, internal audit), severity levels (minor/major/critical), status workflow (draft → open → under investigation → resolved → closed), disposition management (use as-is, rework, scrap, return to supplier, sort and segregate), and days-open tracking
- Corrective and Preventive Action (CAPA) - Root cause analysis workflows linked to NCRs with type classification (corrective/preventive), priority levels (low → critical), action item management with individual assignments and due dates, verification step, overdue tracking, and completion percentage
- Audit Management - Internal and external audit scheduling with types (internal, external, supplier, process, product, system), status workflow (draft → scheduled → in progress → completed → closed), finding classification (observation, minor/major non-conformance, opportunity for improvement, positive), severity tracking, and corrective action assignment
- Certificate of Analysis (CoA) - Batch compliance certificates with test results (test name, method, specification, measured result, pass/fail), approval workflow (draft → pending review → approved → issued/revoked), production and expiry date tracking, and all-tests-passed validation
Handles the return of products from customers back to the warehouse.
- Return Merchandise Authorization (RMA) - Customer return request workflow (draft → submitted → approved → receiving → received → closed / rejected) with return types (exchange, refund, repair, store credit), reason categories (defective, wrong item, damaged, not as described, changed mind), priority levels (low → urgent), line items with quantity and condition tracking, and approval with date/user audit trail
- Refund Processing - Financial refund lifecycle (draft → pending approval → approved → processing → completed / failed / cancelled) linked to RMAs, with refund types (full, partial, store credit), refund methods (original payment, bank transfer, store credit, check), multi-currency support (USD, EUR, GBP, PKR, AED, SAR, INR, CNY), amount tracking, and transaction reference management
- Disposition Management - Decision logic for returned items with inspection workflow (pending → inspecting → decided → processing → completed), condition assessment (new, like new, good, fair, poor, damaged, defective), disposition decisions (restock, refurbish, repair, scrap, return to supplier, donate), inspector assignment, and inspection/decision notes
- Warranty Claims - Claims against suppliers or manufacturers (draft → submitted → under review → approved → settled / denied → closed) with claim types (manufacturer warranty, supplier warranty, extended warranty), warranty period tracking, claim and settlement amounts, multi-currency support, claim line items with quantity and cost breakdown, and vendor linkage
- Return Portal Settings - Per-tenant configuration for return portal (enable/disable portal, return window days, approval requirements, auto-generate labels, restocking fee percentage, return policy text)
Provides insights into supply chain performance and efficiency.
- Inventory Dashboards - Periodic inventory performance reports with types (turnover analysis, dead stock, aging inventory, stock summary), status workflow (draft → generated → reviewed → archived), aggregate metrics (total items, total value, turnover rate, dead stock count/value, aging 30/60/90/90+ day counts), and per-item/warehouse line item breakdown with movement tracking and dead stock flagging
- Procurement Analytics - Spend analysis and vendor performance reports with types (spend analysis, vendor performance, cost savings, purchase summary), aggregate metrics (total spend, total orders, average order value, on-time delivery rate, rejection rate), and per-vendor line item breakdown with lead time, on-time rate, rejection rate, and cost variance tracking
- Logistics KPIs - Transportation performance scorecards with types (delivery performance, freight cost, vehicle utilization, carrier performance), aggregate metrics (total shipments, on-time/late counts, on-time rate, total freight cost, average cost per shipment, average transit days, vehicle utilization rate), and per-carrier line item breakdown
- Financial Reporting - Gross margin analysis and supply chain cost breakdowns with types (gross margin, cost breakdown, revenue analysis, profitability), aggregate metrics (total revenue, total COGS, gross margin, gross margin percentage, procurement/logistics/manufacturing/warehousing costs), and cost category line items with percentage of total
- Predictive Analytics - AI-driven prediction alerts with types (demand spike, supply disruption, stockout risk, price fluctuation, delivery delay), severity levels (low → critical), status workflow (new → analyzing → confirmed → resolved/dismissed), confidence levels, affected item/vendor tracking, impact description, recommended actions, and resolution tracking
Manages legal agreements and regulatory adherence across the supply chain.
- Contract Repository - Centralized storage for logistics contracts, supplier agreements, and NDAs with document attachments, auto-renewal settings, notice periods, and full contract lifecycle management (draft → active → under review → expired/terminated), multi-currency support (USD, EUR, GBP, PKR, AED, SAR, INR, CNY)
- Compliance Tracking - Monitoring adherence to regulations (FDA, HazMat, GDPR, ISO, Customs, Environmental, Labor, Trade Sanctions) with risk level assessment (low → critical), compliance check items with pass/fail/pending results, responsible person assignment, corrective action tracking, and expiry monitoring
- Trade Documentation - Generation and management of import/export documents (Bill of Lading, Commercial Invoice, Packing List, Certificate of Origin, Customs Declaration, Letter of Credit, Insurance Certificate) with status workflow (draft → issued → in transit → delivered → archived), origin/destination country tracking, line items with quantity and value breakdown
- License Management - Tracking of import/export licenses, transit permits, bonded warehouse licenses, customs broker authorizations, and special permits with status workflow (draft → active → expiring soon → expired/suspended/revoked), issuing authority, country, expiry monitoring, and renewal notes
- Sustainability Tracking - Carbon footprint reporting (total CO2, carbon offset, net carbon calculation), ethical sourcing compliance, waste management, energy consumption, and water usage reports with sustainability scoring (0-100), approval workflow (draft → submitted → reviewed → approved → published), and per-metric tracking with targets and variance analysis
Manages the physical assets used to run the supply chain (trucks, forklifts, machinery).
- Asset Registry - Database of all physical assets with types (truck, forklift, machinery, conveyor, vehicle, equipment, computer, furniture), condition tracking (new → critical), status lifecycle (draft → active → in maintenance → out of service → retired → disposed), specifications with key-value pairs, manufacturer/model/serial tracking, warranty expiry monitoring, location and user assignment
- Preventive Maintenance - Scheduling of regular maintenance tasks with configurable frequency (daily, weekly, bi-weekly, monthly, quarterly, semi-annual, annual), priority levels (low → urgent), status workflow (draft → scheduled → in progress → completed/overdue/cancelled), task checklists with individual status tracking, estimated vs. actual duration and cost comparison, next due date tracking
- Breakdown Maintenance - Logging of unplanned repairs with severity levels (minor, moderate, major, critical), status workflow (reported → assigned → diagnosing → repairing → completed → closed), downtime hours tracking, repair cost recording, root cause analysis, resolution time calculation, spare parts usage linkage
- Spare Parts Inventory - Management of maintenance parts with stock levels, reorder points and quantities, unit cost tracking, stock status (in stock, low stock, out of stock, discontinued), vendor linkage, usage history tracking per asset and breakdown, total inventory value calculation, compatible asset mapping
- Asset Depreciation - Financial tracking with multiple methods (straight line, declining balance, double declining, sum of years, units of production), auto-calculated annual depreciation, accumulated depreciation and current book value tracking, depreciation percentage, status lifecycle (draft → active → fully depreciated → disposed), salvage value and useful life configuration
Optimizes the workforce within warehouses and logistics.
- Labor Planning - Forecasting labor requirements based on inbound/outbound volume with department assignment (receiving, picking, packing, shipping, loading, inventory control), shift scheduling (morning, afternoon, night, flexible), required vs. available headcount tracking, headcount gap analysis, warehouse assignment, status workflow (draft → approved → active → completed/cancelled), and per-role breakdown with hourly rate tracking
- Time & Attendance - Clock-in/out functionality with break tracking (start/end times, duration in minutes), overtime calculation (auto-calculated from net hours vs. standard hours per day), shift assignment, warehouse location tracking, status workflow (clocked in → on break → clocked out → approved → locked), total hours/net hours/overtime computation
- Task Assignment - Assigning specific warehouse tasks (picking, packing, receiving, loading, put away, cycle counting, cleaning, replenishment) to individual workers with priority levels (low → urgent), status workflow (pending → assigned → in progress → completed/cancelled), due date and overdue tracking, estimated vs. actual duration, units to process/processed tracking, error counting, checklist items with completion status, and auto-calculated units per hour and accuracy rate
- Performance Tracking - Measuring worker productivity with period-based reviews, tasks completed count, total units processed, total hours worked, error tracking, auto-calculated units per hour, accuracy rate percentage, and weighted overall score, rating system (exceptional, exceeds expectations, meets expectations, needs improvement, unsatisfactory), reviewer assignment, status workflow (draft → submitted → approved → closed/cancelled), reviewer and worker comments
- Payroll Integration - Aggregating labor data for payroll processing with regular and overtime hours tracking, configurable hourly and overtime rates, auto-calculated regular pay, overtime pay, gross pay (regular + overtime + bonuses), and net pay (gross - deductions), multi-currency support (USD, EUR, GBP, PKR, AED, SAR, INR, CNY), days worked/absent tracking, status workflow (draft → calculated → approved → exported/cancelled), export timestamp tracking
Specialized module for temperature-sensitive logistics (Pharma/Food).
- Temperature Monitoring - IoT sensor registry with types (thermocouple, RTD, thermistor, infrared, data logger), location types (warehouse, truck, container, cold room, freezer), status lifecycle (draft → active → offline → maintenance → retired), calibration tracking with interval configuration, reading range configuration, periodic temperature and humidity readings with in-range validation
- Excursion Management - Temperature deviation alerts with severity levels (minor, moderate, major, critical), status workflow (detected → acknowledged → investigating → resolved → closed), sensor and zone linkage, recorded vs. expected temperature comparison, duration tracking, affected items count, impact description, corrective action documentation, resolution tracking with timestamps
- Cold Storage Inventory - Storage unit registry with types (walk-in cooler, walk-in freezer, reach-in refrigerator, blast freezer, ultra-low freezer, refrigerated container), temperature zone assignment, capacity tracking, current temperature/humidity monitoring, item-level tracking with batch/lot numbers, expiry dates, condition assessment (good, near expiry, expired, compromised), temperature requirement ranges per item
- Compliance Reporting - Automated health/safety audit reports with types (temperature log, excursion summary, storage audit, equipment qualification, regulatory filing), regulatory body tracking (FDA, EMA, WHO, HACCP, GMP, ISO), status workflow (draft → generated → reviewed → submitted → approved), report items with parameter/specification/measured value and pass/fail results, approval tracking
- Reefer Maintenance - Refrigerated unit registry with types (reefer container, refrigerated truck, cold room, display case, transport cooler), refrigerant type tracking (R-134a, R-404A, R-410A, R-290, R-744, ammonia), maintenance scheduling with types (routine inspection, compressor service, refrigerant check, thermostat calibration, defrost cycle, emergency repair), frequency configuration, priority levels (low → urgent), status workflow (draft → scheduled → in progress → completed/overdue/cancelled), estimated vs. actual cost tracking
A dedicated interface for clients (B2B or B2C) to interact with the supply chain.
- Portal Accounts - Customer portal account management linked to OMS customers with display name, portal email, phone, preferred language (English, Spanish, French, German, Arabic, Urdu, Chinese), billing/shipping addresses, payment method configuration (credit card, bank transfer, PayPal, COD, store credit), payment reference tracking, status lifecycle (pending → active → suspended → closed)
- Order Tracking - Real-time order visibility with tracking number auto-generation (OT-XXXXX), portal account and OMS order linkage, TMS shipment integration, carrier name and tracking URL, current status workflow (processing → shipped → in transit → out for delivery → delivered/delayed/returned/cancelled), estimated and actual delivery dates, last known location, days in transit calculation, and per-milestone tracking events with date, location, status, and description
- Document Retrieval - Centralized document access with types (invoice, proof of delivery, contract, packing list, credit note, statement, certificate), portal account and order linkage, file path and size tracking with human-readable display, reference number, status workflow (draft → published → archived), issue and expiry date tracking with auto-expired detection
- Support Ticketing - Customer support system with categories (order issue, delivery issue, billing, product inquiry, return request, general, complaint), priority levels (low → urgent), status workflow (open → in progress → waiting on customer → resolved → closed, with reopen capability), portal account and order linkage, agent assignment, resolution timestamp and notes, auto-calculated response time in hours, threaded messages with sender type (customer, agent, system)
- Catalog Browsing - Product catalog linked to procurement items with portal-specific naming and descriptions, category assignment, unit pricing with multi-currency support (USD, EUR, GBP, PKR, AED, SAR, INR, CNY), stock status tracking (in stock, low stock, out of stock, pre-order, discontinued), available quantity, minimum order quantity, lead time in days, image URL, featured flag, active/inactive status
Specifically for tenants acting as logistics providers for other companies.
- Client Management - 3PL client registry with contact details, contract dates, default currency (USD, EUR, GBP, PKR, AED, SAR, INR, CNY), status lifecycle (draft → active → suspended → terminated), and centralized hub linking to billing, inventory, SLAs, integrations, and rental agreements
- Client Billing - Automated billing with configurable rate types (per storage unit, per transaction, per weight unit, fixed fee), unit of measure and rate amount tracking, invoice generation with billing period, subtotal/tax/total calculation, line items linked to rates, status workflow (draft → sent → paid/overdue/cancelled), due date and issued date tracking
- Client Inventory Segregation - Strict client inventory separation with dedicated/shared storage zones mapped to warehouses, zone capacity tracking (sq ft, sq m, pallets, cubic meters), per-client inventory items with SKU, quantity, weight (kg, lbs, metric tons), unit of measure, and received date tracking
- SLA Management - Service Level Agreement lifecycle (draft → active → breached → expired) with review frequency (weekly, monthly, quarterly), penalty clauses, KPI metrics (on-time delivery %, order accuracy %, turnaround time, damage rate %, custom), target vs. actual value tracking, breach detection and notes
- Client Integration - API configuration per client with API key management, endpoint and webhook URL tracking, sync direction (inbound, outbound, bidirectional), sync frequency (real-time, hourly, daily, manual), status lifecycle (draft → active → paused → error → disabled), integration logs with sync/webhook/error type, records processed/failed counts, request/response payload tracking
- Warehouse Rental Management - Space rental agreements with dedicated/shared space types, warehouse linkage, area size and unit tracking, configurable rate periods (daily, weekly, monthly), multi-currency support, status lifecycle (draft → active → expired → terminated), periodic space usage records with utilization percentage and calculated charges
Connects supply chain operations with financial records.
- Accounts Payable - Vendor invoice management with purchase order linkage, line items with quantity/unit price/tax rate, status workflow (draft → pending approval → approved → partially paid → paid/overdue/cancelled), configurable payment terms (due on receipt, net 15/30/45/60/90), payment recording with method tracking (bank transfer, check, cash, wire, credit card), balance due and days outstanding calculation, aging detection
- Accounts Receivable - Customer invoice management with sales order linkage, line items with quantity/unit price/tax rate, status workflow (draft → sent → partially paid → paid/overdue/cancelled), payment received tracking with method and reference, balance due and days outstanding calculation, overdue detection
- Landed Cost Calculation - Cost sheet creation linked to shipments, purchase orders, and carriers, cost components (freight, customs duty, insurance, handling, inspection, warehousing, brokerage, other), allocation methods (by value, by weight, by quantity, equal), total goods cost and total landed cost calculation, status workflow (draft → calculated → finalized)
- Budgeting - Department-level budget planning with period types (monthly, quarterly, annual), planned vs. actual amount tracking, variance and variance percentage calculation, over-budget detection, budget entries with date/description/amount and generic reference linking, status workflow (draft → active → closed)
- Tax Management - Tax rate configuration with types (sales tax, VAT, customs duty, excise, withholding, other), percentage rate with 4-decimal precision, country/region targeting, effective date ranges, active/inactive status, tax transaction log with collected/paid/refund types, taxable and tax amounts, generic reference linking to any module
- Login, registration, forgot password
- Role-based access (super admin, tenant admin, manager, employee, viewer)
- User invite system with token-based acceptance
- User profiles with avatar, job title, department, bio
- Shared database with
tenant_idon all models - Middleware-based tenant resolution from logged-in user
- Auto-filtered querysets ensure data isolation between tenants
- Subscription plans (Free, Starter, Professional, Enterprise)
- Clean, intuitive and fully responsive design
- Stat cards with tenant-scoped metrics
- Recent users and invites tables
- Quick action shortcuts
- Vertical, Horizontal & Detached layouts
- Light & Dark modes
- Fluid & Boxed width
- Fixed & Scrollable positions
- Light & Dark topbars
- Default, Compact, Small Icon & Icon Hovered sidebars
- Light, Dark & Colored sidebars
- LTR & RTL supported
- Preloader option
- Chrome (Windows, Mac, Linux)
- Firefox (Windows, Mac, Linux)
- Safari (Mac)
- Microsoft Edge
- And other WebKit browsers
- Python 3.10+
- MySQL (XAMPP recommended)
- Git
-
Clone the repository
git clone https://github.com/Navaid-KloneIT/NavSCM.git cd NavSCM -
Create and activate virtual environment
python -m venv venv # Windows venv\Scripts\activate # Linux/Mac source venv/bin/activate
-
Install dependencies
pip install -r requirements.txt
-
Configure environment variables
cp .env.example .env
Edit
.envand update the values for your environment:SECRET_KEY=your-secret-key-here DEBUG=True DB_NAME=navhcm DB_USER=root DB_PASSWORD= DB_HOST=localhost DB_PORT=3306 -
Create MySQL database
CREATE DATABASE navhcm CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-
Run migrations
python manage.py migrate
-
Seed sample data
python manage.py seed_data
7b. Seed procurement data
python manage.py seed_procurement7c. Seed SRM data
python manage.py seed_srm7d. Seed inventory data
python manage.py seed_inventory7e. Seed WMS data
python manage.py seed_wms7f. Seed OMS data
python manage.py seed_oms7g. Seed TMS data
python manage.py seed_tms7h. Seed Demand Planning data
python manage.py seed_demand_planning7i. Seed Manufacturing data
python manage.py seed_manufacturing7j. Seed QMS data
python manage.py seed_qms7k. Seed Returns Management data
python manage.py seed_returns7l. Seed Analytics data
python manage.py seed_analytics7m. Seed Contract & Compliance data
python manage.py seed_contracts7n. Seed Asset Management data
python manage.py seed_assets7o. Seed Labor Management data
python manage.py seed_labor7p. Seed Cold Chain Management data
python manage.py seed_cold_chain7q. Seed Customer Portal data
python manage.py seed_portal7r. Seed 3PL Management data
python manage.py seed_tpl7s. Seed Finance & Accounting data
python manage.py seed_finance-
Run the development server
python manage.py runserver
-
Open in browser
http://localhost:8000
After running seed_data, the following accounts are available:
| Username | Password | Role |
|---|---|---|
| admin | admin123 | Superuser |
| admin_<tenant-slug> | password123 | Tenant Admin |
| All other users | password123 | Various roles |
NavSCM/
├── .env # Environment variables (not in git)
├── .env.example # Environment template for new setups
├── apps/
│ ├── core/ # Tenant model, middleware, context processors
│ ├── accounts/ # Auth, users, roles, profiles, invites
│ ├── dashboard/ # Dashboard views & stats
│ ├── procurement/ # Procurement management module
│ │ ├── models.py # Vendor, Item, PR, RFQ, PO, GRN, Invoice, 3-Way Match
│ │ ├── views.py # All procurement CRUD & workflow views
│ │ ├── forms.py # Forms & inline formsets for all models
│ │ ├── urls.py # URL routing (/procurement/*)
│ │ └── admin.py # Django admin registration
│ ├── srm/ # Supplier relationship management module
│ │ ├── models.py # Onboarding, Scorecard, Contract, Catalog, Risk Assessment
│ │ ├── views.py # All SRM CRUD & workflow views
│ │ ├── forms.py # Forms & inline formsets for all models
│ │ ├── urls.py # URL routing (/srm/*)
│ │ └── admin.py # Django admin registration
│ ├── inventory/ # Inventory management module
│ │ ├── models.py # Warehouse, StockItem, Transfer, Adjustment, Reorder, Valuation
│ │ ├── views.py # All inventory CRUD & workflow views
│ │ ├── forms.py # Forms & inline formsets for all models
│ │ ├── urls.py # URL routing (/inventory/*)
│ │ └── admin.py # Django admin registration
│ ├── wms/ # Warehouse management system module
│ │ ├── models.py # Bin, DockAppointment, ReceivingOrder, PutAwayTask, PickList, PackingOrder, ShippingLabel, CycleCountPlan, CycleCount, YardLocation, YardVisit
│ │ ├── views.py # All WMS CRUD & workflow views
│ │ ├── forms.py # Forms & inline formsets for all models
│ │ ├── urls.py # URL routing (/wms/*)
│ │ └── admin.py # Django admin registration
│ ├── oms/ # Order management system module
│ │ ├── models.py # Customer, SalesChannel, Order, OrderItem, OrderValidation, OrderAllocation, AllocationItem, Backorder, CustomerNotification
│ │ ├── views.py # All OMS CRUD & workflow views
│ │ ├── forms.py # Forms & inline formsets for all models
│ │ ├── urls.py # URL routing (/oms/*)
│ │ └── admin.py # Django admin registration
│ ├── tms/ # Transportation management system module
│ │ ├── models.py # Carrier, RateCard, Route, Shipment, ShipmentItem, ShipmentTracking, FreightBill, FreightBillItem, LoadPlan, LoadPlanItem
│ │ ├── views.py # All TMS CRUD & workflow views
│ │ ├── forms.py # Forms & inline formsets for all models
│ │ ├── urls.py # URL routing (/tms/*)
│ │ └── admin.py # Django admin registration
│ ├── demand_planning/ # Demand planning & forecasting module
│ │ ├── models.py # SalesForecast, ForecastLineItem, SeasonalityProfile, PromotionalEvent, DemandSignal, CollaborativePlan, PlanLineItem, PlanComment, SafetyStockCalculation, SafetyStockItem
│ │ ├── views.py # All demand planning CRUD & workflow views
│ │ ├── forms.py # Forms & inline formsets for all models
│ │ ├── urls.py # URL routing (/demand-planning/*)
│ │ └── admin.py # Django admin registration
│ ├── manufacturing/ # Manufacturing / production module
│ │ ├── models.py # WorkCenter, BillOfMaterials, BOMLineItem, ProductionSchedule, ProductionScheduleItem, WorkOrder, WorkOrderOperation, MRPRun, MRPRequirement, ProductionLog
│ │ ├── views.py # All manufacturing CRUD & workflow views
│ │ ├── forms.py # Forms & inline formsets for all models
│ │ ├── urls.py # URL routing (/manufacturing/*)
│ │ └── admin.py # Django admin registration
│ ├── qms/ # Quality management system module
│ │ ├── models.py # InspectionTemplate, InspectionCriteria, QualityInspection, InspectionResult, NonConformanceReport, CAPA, CAPAAction, QualityAudit, AuditFinding, CertificateOfAnalysis, CoATestResult
│ │ ├── views.py # All QMS CRUD & workflow views
│ │ ├── forms.py # Forms & inline formsets for all models
│ │ ├── urls.py # URL routing (/qms/*)
│ │ └── admin.py # Django admin registration
│ ├── returns/ # Returns management (reverse logistics) module
│ │ ├── models.py # ReturnAuthorization, RMALineItem, Refund, Disposition, WarrantyClaim, WarrantyClaimItem, ReturnPortalSettings
│ │ ├── views.py # All returns CRUD & workflow views
│ │ ├── forms.py # Forms & inline formsets for all models
│ │ ├── urls.py # URL routing (/returns/*)
│ │ └── admin.py # Django admin registration
│ ├── analytics/ # Supply chain analytics module
│ │ ├── models.py # InventoryAnalytics, InventoryAnalyticsItem, ProcurementAnalytics, ProcurementAnalyticsItem, LogisticsKPI, LogisticsKPIItem, FinancialReport, FinancialReportItem, PredictiveAlert
│ │ ├── views.py # All analytics CRUD, dashboard & workflow views
│ │ ├── forms.py # Forms & inline formsets for all models
│ │ ├── urls.py # URL routing (/analytics/*)
│ │ └── admin.py # Django admin registration
│ ├── assets/ # Asset management module
│ │ ├── models.py # Asset, AssetSpecification, PreventiveMaintenance, MaintenanceTask, BreakdownMaintenance, SparePart, SparePartUsage, AssetDepreciation
│ │ ├── views.py # All asset management CRUD & workflow views
│ │ ├── forms.py # Forms & inline formsets for all models
│ │ ├── urls.py # URL routing (/assets/*)
│ │ └── admin.py # Django admin registration
│ ├── contracts/ # Contract & compliance management module
│ │ ├── models.py # Contract, ContractDocument, ComplianceRecord, ComplianceCheckItem, TradeDocument, TradeDocumentItem, License, SustainabilityReport, SustainabilityMetric
│ │ ├── views.py # All contract & compliance CRUD & workflow views
│ │ ├── forms.py # Forms & inline formsets for all models
│ │ ├── urls.py # URL routing (/contracts/*)
│ │ └── admin.py # Django admin registration
│ ├── labor/ # Labor management module
│ │ ├── models.py # LaborPlan, LaborPlanLine, Attendance, TaskAssignment, TaskChecklistItem, PerformanceReview, PayrollRecord
│ │ ├── views.py # All labor management CRUD & workflow views
│ │ ├── forms.py # Forms & inline formsets for all models
│ │ ├── urls.py # URL routing (/labor/*)
│ │ └── admin.py # Django admin registration
│ ├── portal/ # Customer portal module
│ │ ├── models.py # PortalAccount, OrderTracking, TrackingEvent, PortalDocument, SupportTicket, TicketMessage, CatalogItem
│ │ ├── views.py # All portal CRUD & workflow views
│ │ ├── forms.py # Forms & inline formsets for all models
│ │ ├── urls.py # URL routing (/portal/*)
│ │ └── admin.py # Django admin registration
│ ├── cold_chain/ # Cold chain management module
│ │ ├── models.py # TemperatureSensor, TemperatureReading, TemperatureZone, TemperatureExcursion, ColdStorageUnit, ColdStorageItem, ComplianceReport, ComplianceReportItem, ReeferUnit, ReeferMaintenance
│ │ ├── views.py # All cold chain CRUD & workflow views
│ │ ├── forms.py # Forms & inline formsets for all models
│ │ ├── urls.py # URL routing (/cold-chain/*)
│ │ └── admin.py # Django admin registration
│ ├── tpl/ # 3PL management module
│ │ ├── models.py # Client, BillingRate, BillingInvoice, BillingInvoiceItem, ClientStorageZone, ClientInventoryItem, SLA, SLAMetric, IntegrationConfig, IntegrationLog, RentalAgreement, SpaceUsageRecord
│ │ ├── views.py # All 3PL CRUD & workflow views
│ │ ├── forms.py # Forms & inline formsets for all models
│ │ ├── urls.py # URL routing (/3pl/*)
│ │ └── admin.py # Django admin registration
│ └── finance/ # Finance & accounting module
│ ├── models.py # APInvoice, APInvoiceItem, APPayment, ARInvoice, ARInvoiceItem, ARPayment, LandedCostSheet, LandedCostComponent, Budget, BudgetEntry, TaxRate, TaxTransaction
│ ├── views.py # All finance CRUD & workflow views
│ ├── forms.py # Forms & inline formsets for all models
│ ├── urls.py # URL routing (/finance/*)
│ └── admin.py # Django admin registration
├── config/ # Django settings, URLs, WSGI, ASGI
├── static/
│ ├── css/style.css # Custom theme CSS (blue & white)
│ └── js/app.js # Theme engine & UI JavaScript
├── templates/
│ ├── base.html # Master layout
│ ├── partials/ # Sidebar, topbar, footer, preloader, theme settings
│ ├── auth/ # Login, register, forgot password
│ ├── dashboard/ # Dashboard index
│ ├── accounts/ # User list, invite, profile
│ ├── procurement/ # Procurement templates
│ │ ├── vendor_*.html # Vendor list, form, detail
│ │ ├── item_*.html # Item catalog list, form
│ │ ├── category_*.html # Category list, form
│ │ ├── requisition_*.html # Purchase requisition list, form, detail
│ │ ├── rfq_*.html # RFQ list, form, detail
│ │ ├── po_*.html # Purchase order list, form, detail
│ │ ├── grn_*.html # Goods receipt list, form, detail
│ │ ├── invoice_*.html # Vendor invoice list, form, detail
│ │ └── reconciliation*.html # 3-way match dashboard & form
│ ├── srm/ # SRM templates
│ │ ├── onboarding_*.html # Supplier onboarding list, form, detail
│ │ ├── question_*.html # Qualification question list, form
│ │ ├── period_*.html # Scorecard period list, form
│ │ ├── scorecard_*.html # Supplier scorecard list, form, detail
│ │ ├── contract_*.html # Contract list, form, detail
│ │ ├── catalog_*.html # Supplier catalog list, form, detail
│ │ └── risk_*.html # Risk assessment list, form, detail
│ ├── inventory/ # Inventory templates
│ │ ├── warehouse_*.html # Warehouse list, form, detail
│ │ ├── stock_*.html # Stock item list, detail
│ │ ├── transfer_*.html # Warehouse transfer list, form, detail
│ │ ├── adjustment_*.html # Stock adjustment list, form, detail
│ │ ├── reorder_*.html # Reorder rules & suggestions list, form
│ │ └── valuation_*.html # Inventory valuation list, form, detail
│ ├── wms/ # WMS templates
│ │ ├── bin_*.html # Bin list, form, detail
│ │ ├── dock_*.html # Dock appointment list, form, detail
│ │ ├── receiving_*.html # Receiving order list, form, detail
│ │ ├── putaway_*.html # Put-away task list, detail
│ │ ├── picklist_*.html # Pick list list, form, detail
│ │ ├── packing_*.html # Packing order list, form, detail
│ │ ├── label_*.html # Shipping label list, form, detail
│ │ ├── plan_*.html # Cycle count plan list, form, detail
│ │ ├── count_*.html # Cycle count list, form, detail
│ │ ├── yard_location_*.html # Yard location list, form, detail
│ │ └── yard_visit_*.html # Yard visit list, form, detail
│ ├── oms/ # OMS templates
│ │ ├── customer_*.html # Customer list, form, detail
│ │ ├── channel_*.html # Sales channel list, form
│ │ ├── order_*.html # Order list, form, detail
│ │ ├── validation_*.html # Order validation list, detail
│ │ ├── allocation_*.html # Order allocation list, form, detail
│ │ ├── backorder_*.html # Backorder list, detail
│ │ └── notification_*.html # Customer notification list, detail
│ ├── tms/ # TMS templates
│ │ ├── carrier_*.html # Carrier list, form, detail
│ │ ├── rate_*.html # Rate card list, form, detail
│ │ ├── route_*.html # Route list, form, detail
│ │ ├── shipment_*.html # Shipment list, form, detail
│ │ ├── tracking_*.html # Tracking event list, form, detail
│ │ ├── freight_*.html # Freight bill list, form, detail
│ │ └── load_*.html # Load plan list, form, detail
│ ├── demand_planning/ # Demand planning templates
│ │ ├── forecast_*.html # Sales forecast list, form, detail
│ │ ├── seasonality_*.html # Seasonality profile list, form, detail
│ │ ├── event_*.html # Promotional event list, form
│ │ ├── signal_*.html # Demand signal list, form, detail
│ │ ├── plan_*.html # Collaborative plan list, form, detail
│ │ └── safety_stock_*.html # Safety stock calculation list, form, detail
│ ├── manufacturing/ # Manufacturing templates
│ │ ├── workcenter_*.html # Work center list, form, detail
│ │ ├── bom_*.html # Bill of materials list, form, detail
│ │ ├── schedule_*.html # Production schedule list, form, detail
│ │ ├── workorder_*.html # Work order list, form, detail
│ │ ├── mrp_*.html # MRP run list, form, detail
│ │ └── log_*.html # Production log list, form, detail
│ ├── qms/ # QMS templates
│ │ ├── template_*.html # Inspection template list, form, detail
│ │ ├── inspection_*.html # Quality inspection list, form, detail
│ │ ├── ncr_*.html # Non-conformance report list, form, detail
│ │ ├── capa_*.html # CAPA list, form, detail
│ │ ├── audit_*.html # Quality audit list, form, detail
│ │ └── coa_*.html # Certificate of analysis list, form, detail
│ ├── returns/ # Returns management templates
│ │ ├── rma_*.html # Return authorization list, form, detail
│ │ ├── refund_*.html # Refund list, form, detail
│ │ ├── disposition_*.html # Disposition list, form, detail
│ │ ├── warranty_*.html # Warranty claim list, form, detail
│ │ └── portal_settings.html # Return portal settings
│ ├── analytics/ # Supply chain analytics templates
│ │ ├── dashboard.html # Analytics overview dashboard
│ │ ├── inventory_*.html # Inventory analytics list, form, detail
│ │ ├── procurement_*.html # Procurement analytics list, form, detail
│ │ ├── logistics_*.html # Logistics KPI list, form, detail
│ │ ├── financial_*.html # Financial report list, form, detail
│ │ └── alert_*.html # Predictive alert list, form, detail
│ ├── assets/ # Asset management templates
│ │ ├── asset_*.html # Asset registry list, form, detail
│ │ ├── pm_*.html # Preventive maintenance list, form, detail
│ │ ├── bm_*.html # Breakdown maintenance list, form, detail
│ │ ├── spare_*.html # Spare parts list, form, detail
│ │ └── depreciation_*.html # Asset depreciation list, form, detail
│ ├── contracts/ # Contract & compliance templates
│ │ ├── contract_*.html # Contract list, form, detail
│ │ ├── compliance_*.html # Compliance record list, form, detail
│ │ ├── trade_doc_*.html # Trade document list, form, detail
│ │ ├── license_*.html # License list, form, detail
│ │ └── sustainability_*.html # Sustainability report list, form, detail
│ ├── labor/ # Labor management templates
│ │ ├── plan_*.html # Labor plan list, form, detail
│ │ ├── attendance_*.html # Time & attendance list, form, detail
│ │ ├── task_*.html # Task assignment list, form, detail
│ │ ├── performance_*.html # Performance review list, form, detail
│ │ └── payroll_*.html # Payroll record list, form, detail
│ ├── portal/ # Customer portal templates
│ │ ├── account_*.html # Portal account list, form, detail
│ │ ├── tracking_*.html # Order tracking list, form, detail
│ │ ├── document_*.html # Portal document list, form, detail
│ │ ├── ticket_*.html # Support ticket list, form, detail
│ │ └── catalog_*.html # Catalog item list, form, detail
│ ├── cold_chain/ # Cold chain management templates
│ │ ├── sensor_*.html # Temperature sensor list, form, detail
│ │ ├── zone_*.html # Temperature zone list, form, detail
│ │ ├── excursion_*.html # Temperature excursion list, form, detail
│ │ ├── storage_*.html # Cold storage unit list, form, detail
│ │ ├── compliance_*.html # Compliance report list, form, detail
│ │ ├── reefer_*.html # Reefer unit list, form, detail
│ │ └── reefer_maint_*.html # Reefer maintenance list, form, detail
│ ├── tpl/ # 3PL management templates
│ │ ├── client_*.html # 3PL client list, form, detail
│ │ ├── billing_rate_*.html # Billing rate list, form, detail
│ │ ├── billing_invoice_*.html # Billing invoice list, form, detail
│ │ ├── storage_zone_*.html # Storage zone list, form, detail
│ │ ├── client_inventory_*.html # Client inventory list, form, detail
│ │ ├── sla_*.html # SLA list, form, detail
│ │ ├── integration_*.html # Integration config list, form, detail
│ │ └── rental_*.html # Rental agreement list, form, detail
│ └── finance/ # Finance & accounting templates
│ ├── ap_invoice_*.html # AP invoice list, form, detail
│ ├── ap_payment_*.html # AP payment list, form, detail
│ ├── ar_invoice_*.html # AR invoice list, form, detail
│ ├── ar_payment_*.html # AR payment list, form, detail
│ ├── landed_cost_*.html # Landed cost sheet list, form, detail
│ ├── budget_*.html # Budget list, form, detail
│ ├── tax_rate_*.html # Tax rate list, form
│ └── tax_transaction_*.html # Tax transaction list, form, detail
├── media/ # User uploads
├── manage.py
└── requirements.txt
All configuration is managed via the .env file using python-decouple. See .env.example for all available variables.
| Variable | Default | Description |
|---|---|---|
SECRET_KEY |
- | Django secret key (required) |
DEBUG |
False |
Enable debug mode |
ALLOWED_HOSTS |
* |
Comma-separated allowed hosts |
DB_ENGINE |
django.db.backends.mysql |
Database engine |
DB_NAME |
navhcm |
Database name |
DB_USER |
root |
Database username |
DB_PASSWORD |
(empty) | Database password |
DB_HOST |
localhost |
Database host |
DB_PORT |
3306 |
Database port |
A high-level overview of planned modules for the NavSCM platform. Each module will follow the same multi-tenant architecture, design patterns, and UI conventions established in the existing codebase.
| # | Module | Description | Status |
|---|---|---|---|
| 1 | Multi-Tenant Administration (Super Admin) | Tenant onboarding, subscription management, RBAC, theme customization, audit logs & security | Done |
| 2 | Procurement Management | Purchase requisitions, RFQs, purchase orders, vendor portal, invoice reconciliation, vendor & item management | Done |
| 3 | Supplier Relationship Management (SRM) | Supplier onboarding, scorecards, contract management, supplier catalogs, risk assessment | Done |
| 4 | Inventory Management | Warehouse management, stock control, warehouse transfers, stock adjustments, reorder automation, inventory valuation | Done |
| 5 | Warehouse Management (WMS) | Inbound/outbound operations, bin/location management, cycle counting, yard management | Done |
| 6 | Order Management (OMS) | Order capture, validation, allocation, backorder management, customer notifications | Done |
| 7 | Transportation Management (TMS) | Route planning, freight audit, carrier management, shipment tracking, load optimization | Done |
| 8 | Demand Planning & Forecasting | Sales forecasting, seasonality analysis, demand sensing, collaborative planning, safety stock calculation | Done |
| 9 | Manufacturing / Production | Bill of materials (BOM), production scheduling, work orders, MRP, shop floor control | Done |
| 10 | Quality Management (QMS) | Quality inspection, non-conformance reports, CAPA, audit management, certificates of analysis | Done |
| 11 | Returns Management | RMA workflows, refund processing, disposition management, return portal, warranty claims | Done |
| 12 | Supply Chain Analytics | Inventory dashboards, procurement analytics, logistics KPIs, financial reporting, predictive analytics | Done |
| 13 | Contract & Compliance | Contract repository, compliance tracking, trade documentation, license management, sustainability tracking | Done |
| 14 | Asset Management | Asset registry, preventive/breakdown maintenance, spare parts inventory, asset depreciation | Done |
| 15 | Labor Management | Labor planning, time & attendance, task assignment, performance tracking, payroll integration | Done |
| 16 | Cold Chain Management | Temperature monitoring (IoT), excursion management, cold storage inventory, compliance reporting, reefer maintenance | Done |
| 17 | Customer Portal | Order tracking, account management, document retrieval, support ticketing, catalog browsing | Done |
| 18 | 3PL Management | Client billing, inventory segregation, SLA management, client integration, warehouse rental | Done |
| 19 | Finance & Accounting Integration | Accounts payable/receivable, landed cost calculation, budgeting, tax management | Done |
| 20 | Integration & API Gateway | ERP connectors (SAP, Oracle), e-commerce integration, IoT gateway, EDI, webhooks | Planned |