Multi-Tenant ERP — Label Manufacturing
The multi-tenant ERP for label manufacturers, which offers real-time order management, automated production scheduling and machine load balancing, is production-ready.
The Problem
Label manufacturers had multiple office locations with production orders tracked in spreadsheets, no real-time visibility into the production order status and cross-company data was not isolated.
The Solution
Multi-tenant ERP, with each company and location completely separate, with production orders automatically scheduled according to current machine load (no manual dispatch required) and role-based access so that each user sees only what they're authorised to.
What I Built
Designed a multi-tenant data architecture using Row Level Security policies which provide full tenant isolation at the database level, built an automated scheduling engine that considers machine load, order priority and shift availability, and added real-time order board updates and CSV reporting.
Outcome
The client has completely replaced manual scheduling and now has real-time visibility across all locations which has minimised production delays throughout the introduction of the system from order intake to dispatch through to production.
Future Scope
Machine maintenance alerts based on usage patterns, mobile application to update order status in real time, integration with supplier systems for automatic raw material re-ordering.