Case study
Custom ERP for a Specialised Organisation
A Low-Code Custom ERP tailored to localised business operations across 5+ companies, with external integrations, business intelligence, and self-service portals for employees, clients, and suppliers. 13 years in production with 350+ users.
- Years in production
- 13+
- Concurrent users
- 350+
- Companies served
- 5+
- Localisation
- Oman + multi-currency
Technologies
What we were actually solving.
- Disconnected systems across Finance, HR, Inventory, Procurement, and Sales running on separate tools or manual processes across 5+ companies.
- No single source of truth, management lacked real-time visibility into stock, finance, or employees across 6+ showrooms.
- Off-the-shelf ERPs could not be configured to match local payroll, tax, and trading practices without expensive vendor customisation.
- No self-service for employees, clients, or suppliers, every interaction routed through the central admin team.
- High external-vendor quotes for customisation and ongoing support at 350+ users.
How we worked the problem.
-
Phase 01
Requirements gathering & business analysis
Deep-dive sessions with Finance, HR, Warehouse, Procurement, and Sales teams. Mapped manual processes, Omani-specific compliance requirements, and designed multi-company / multi-division architecture for future growth.
-
Phase 02
Low-code custom platform architecture
Delivered as a Low-Code Custom ERP: .NET runtime, SQL Server data layer, and an admin-driven configuration layer that lets the business reshape forms, fields, modules, taxes, currencies, and approval workflows without code changes. Multi-tenant by design, multi-company, multi-currency, and multi-locale from day one.
-
Phase 03
Modules and self-service portals
Core modules: Inventory & Stock, Financial Accounting, HR & Payroll, Procurement, Sales & Pricing, Reporting & Analytics, System Configuration, Reference Data. Plus three self-service portals: Employee (payslips, leave, attendance), Client (orders, invoices, statements), and Supplier (POs, GRN visibility, payment status).
-
Phase 04
External integrations
Integrated to n8n for approvals and exceptions, Power BI for executive dashboards, attendance hardware, SMTP and SMS gateways, bank file templates, and downstream reporting tools. Configurable connectors so the business can extend without engineering involvement.
-
Phase 05
Business intelligence
Power BI dashboards layered on the ERP data model. Real-time stock, finance, and HR views for executives. Automated management reports replaced days of manual compilation. Forecasting and ageing analytics built into the standard reporting suite.
-
Phase 06
Localisation & compliance
Omani salary structure, tax percentage calculations, 78-city master, board-level staff records, and multi-currency support baked into the core, not bolted on.
-
Phase 07
Continuous improvement
416 version iterations over 13 years with built-in audit logging, every modification tracked with date, version, type, detail, and reason. Four database environments (dev/test/UAT/prod).
What shipped, and what it does.
- Low-Code Custom ERP that the business can reshape via configuration: forms, fields, taxes, currencies, salary components, approval workflows, all admin-editable.
- Employee self-service portal: payslips, leave applications, attendance review, profile updates, request submissions.
- Client portal: orders, invoices, statements, document downloads, payment status.
- Supplier portal: purchase orders, GRN visibility, payment status, invoice and document submission.
- External integrations: n8n workflows, Power BI dashboards, attendance hardware, SMTP, SMS, bank file templates.
- Business intelligence layer: real-time Power BI dashboards on stock, finance, HR, and operations.
- 15,000+ products tracked with real-time stock across 11 centres.
- Omani-compliant payroll for 107 employees, including board-level staff records and attendance integration.
- 13 company profiles supporting multi-tenant configurations (name, address, tax, bank, currency, logo, watermark).
- 416 version log entries providing full audit trail.
The numbers.
- 13+ yrs
- System longevity
- 416
- Iterations shipped
- 350+
- Active users
- 5+
- Companies served
- 3
- Self-service portals
- Configurable
- External integrations
- Power BI
- BI layer
- 0
- External vendors
Beyond the metrics.
Operational transformation
- Eliminated data silos, single source of truth across 5+ companies and a board-level entity.
- Real-time Power BI dashboards for stock, finance, and employees.
- Automated payroll integrated with attendance, reducing manual errors for 100+ employees.
- Self-service portals removed admin bottlenecks for employees, clients, and suppliers.
- Automated reporting replaced days of manual compilation via Power BI + n8n.
Cost savings
- Zero external ERP licensing, avoided six-figure vendor fees for 350+ users.
- Zero ongoing vendor costs, business-driven configuration replaced annual change requests.
- n8n workflows compressed day-long processes to minutes.
Capability building
- Proved a Low-Code Custom ERP can match a localised business better than off-the-shelf at scale.
- Foundation for subsequent BI, analytics, and automation initiatives.
- Multi-tenant architecture scaled cleanly across 5+ companies and a board-level entity.
What transfers to your situation.
- Deep business understanding beats feature checklists. 13 years of production use came from building what the business needed, not what vendors said it should have.
- Low-code customisation beats off-the-shelf when localisation is the differentiator. Configurability across companies, currencies, taxes, and salary components is what kept the platform alive for 13 years.
- Self-service portals are not a side feature, they are the productivity multiplier. Employees, clients, and suppliers transacting directly removes the central-admin bottleneck.
- Multi-tenant from day one, designing for multiple companies upfront avoided costly rearchitecture.
- Localisation is core design, not a bolt-on. Omani salary structure and board-level staff records had to be first-class.
- Integrations amplify value. n8n + Power BI + attendance turned a transactional ERP into an intelligent automation platform.
What was under the hood.
- Platform
- Low-Code Custom ERP, .NET runtime + SQL Server, admin-configurable layer
- Data architecture
- Multi-company, data-warehouse-first design, analytics-ready data model, row-level security
- Tenancy
- Multi-tenant, multi-company, multi-currency, multi-locale
- Portals
- Employee self-service, Client portal, Supplier portal
- Integrations
- n8n, Power BI, attendance hardware, SMTP, SMS, bank file templates
- BI
- Power BI dashboards on the ERP data model
- Security
- RBAC, row-level security, license-key system, session management
- Scale
- 350+ concurrent users, 5+ companies + board-level entity
Could this work for you?
If your situation rhymes with this case study, the shortest path is a discovery call.