SD
Back to Projects

Case Study

Jaya Traders ERP System

Trading ERP

Developed a comprehensive ERP with 20+ dashboard modules including POS billing, stock operations, logistics, accounting, and reporting for a multi-branch trading company.

Next.js.NET 8EF CorePostgreSQLQuestPDFDockerGitHub Actions

Role

Full-stack engineer with domain workflow ownership across sales, stock, and logistics.

Business Problem

A multi-branch trading company was running operations on spreadsheets and disconnected tools. They needed real-time stock visibility across branches, automated inter-branch transfers, lot tracking for perishables, and a POS system that worked offline-capable with thermal printer support — all while generating Sinhala-language invoices.

Key Decisions

  • Implemented lot-number tracking at the stock level to support FIFO for perishable goods, with automatic lot assignment during sales.
  • Built a custom invoice template designer (drag-and-drop) so the business could create their own invoice layouts without developer involvement.
  • Designed loading/unloading sheet workflows for logistics with route-based tracking and driver assignment.
  • Used QuestPDF with Sinhala font support (NotoSansSinhala) for generating bilingual invoices and reports.

Architecture

  • Built a Next.js dashboard with invoice template design and role-aware experiences across 20+ modules.
  • Implemented .NET services for invoicing, purchase flow, stock transfer/adjustment, and lot tracking.
  • Delivered logistics operations for loading/unloading sheets and route tracking with driver assignment.
  • Built automated stock transfer jobs for inter-branch replenishment based on configurable thresholds.

Outcomes

  • Improved end-to-end operational visibility across inventory, finance, and route activity.
  • Enabled faster day-to-day billing with POS mode and thermal printer integration.
  • Eliminated manual stock reconciliation through automated lot tracking and transfer workflows.

Measurable Impact

  • 20+ operational modules covering the full trading workflow
  • Multi-branch stock visibility with automated inter-branch transfers
  • Bilingual invoice generation (English + Sinhala) with custom template designer
  • 11 report types including profit/loss, stock valuation, and sales analytics