Back to Portfolio

Distribution & Sales Force Automation (SFA) ERP

Admin Dashboard
Admin Dashboard
Comprehensive Customer Management
Comprehensive Customer Management
Comprehensive Order Management
Comprehensive Order Management
Sales Order Management
Sales Order Management
Data Analysis Area
Data Analysis Area

Project Overview

Ceylon Liquor Holdings ERP

A Custom High-Performance Distribution & Sales Force Automation (SFA) Ecosystem

Project Vision

Developed for Ceylon Liquor Holdings (Pvt) Ltd., this ERP is a comprehensive solution engineered to handle the unique complexities of large-scale liquor distribution. The system manages high-concurrency environments, supporting deep hierarchical data structures from national regions down to individual retail outlets.

Engineered for Scale: The architecture is stress-tested to handle massive datasets, including logic for managing over 100,000 concurrent sales orders without performance degradation.

Core Enterprise Modules

Hierarchical Sales Force

Advanced management of sales territories through a multi-tier hierarchy: Region → Area Sales Manager (ASM) → Territory Manager (TM). Enables granular performance tracking and localized logistics.

Intelligent Order Lifecycle

A complete digital workflow from Order Creation (with real-time stock validation) to Multi-Stage Approval, culminating in automated Tax Invoicing.

Inventory & GRN Control

Automated stock management featuring Goods Received Notes (GRN) with instant inventory adjustment. Includes specialized tracking for Capacity (ml) and SKU-level data.

Financial & Tax Logic

Complex financial engine handling VAT-Registered vs. Non-VAT customers, real-time Outstanding Balance tracking, and automated credit limit enforcement.

Analytics & Logistics

The system provides high-level executive visibility through Glassmorphism-styled Dashboards featuring real-time Monthly Sales Performance and Top Product analytics. Logistics are streamlined with dedicated fields for Lorry Numbers, PO Numbers, and Delivery Dates, ensuring that the back office is always in sync with the fleet.

Technical Architecture

PHP 8.x (Robust Backend) MySQL (Optimized Indexing) DataTables (Server-Side Processing) Role-Based Access (RBAC) Automated CSV Export Engine Dynamic Chart.js Analytics