Consolidating 6 Fragmented Spreadsheets into a Unified ERP System
How one of Karachi's leading textile export houses digitized manufacturing & stock operations.
Before SoftSys, Al-Hamd Textile operated with separate, unlinked files. Sales, Yarn Stock, Weaving Progress, Dyeing Log, Dispatch, and Finance each maintained their own Excel books. Discrepancies were found daily, causing production delays, over-purchasing of raw materials, and billing delays that slowed cash flow.
SoftSys designed and deployed a tailored ERP solution on the Frappe framework. We centralized master tables for Yarn, Dyeing chemical codes, and finished Fabric. We configured automated BOM calculators and integrated real-time barcodes across the shop floor. Finally, we enabled a single finance ledger that dynamically triggers alerts.
All 6 separate spreadsheets were retired. The management team now accesses a real-time dashboard displaying active production lines, accurate inventory buffers, and clear billing statuses. Stock auditing is now completed in 2 hours rather than taking 9 full calendar days.
Metrics Performance
Select a metric tab below to visualize the performance optimization.
Yarn Audit Days
Slashed by ~99%This performance metric was gathered during user-acceptance testing post-deployment.