The challenge
Critical customs and inventory data lived in a decades-old IBM i system that only a few people could use. The business needed modern screens and reports without risking or replacing the system of record.
Case study
Manufacturing, IoT & warehousing
Web
Customs & Inventory Tracking System with IBM i (AS400) Integration
Modern web workflows on top of a legacy retail ERP
A customs and inventory tracking system that connects a modern Laravel application to a retailer's IBM i (AS400) ERP, so customs, stock and movement data can be worked in a web interface instead of green screens.
- Laravel
- IBM i (AS400) DB2
- MySQL
- Tailwind CSS
- REST & EDI
What we built
We built a Laravel application that reads and syncs data from IBM i DB2 tables, following a written integration specification, and keeps its own tables for the new workflows. Custom migration commands rebuild the application tables while leaving the AS400-linked tables untouched, so development and testing never touch production ERP data.
Key features
What the product does.
- IBM i (AS400) DB2 data integration
- Customs and inventory tracking workflows
- Separate application tables alongside the ERP data
- Migration tooling that preserves AS400-linked tables
- REST and EDI data exchange endpoints
Under the hood
Architecture and engineering highlights.
- 1 Integration designed from a consolidated technical specification
- 2 Safe local and test environments that never touch the system of record
- 3 Foundation later grown into a wider modular ERP (see the retail ERP modernisation project)
Product screens
A look at the main workflows.
Illustrations of the main screens. Client data and branding are left out.
-
Tracking dashboard
Customs and stock records from the ERP in a web table.
Services for projects like this
Let's talk
Building something similar?
We have already solved many of the hard parts in manufacturing, iot & warehousing. Tell us about your idea and get a clear plan within 24 hours.
-
1
We reply within 24 hours
A real person reads your message and replies on the next business day at the latest.
-
2
Free 30-minute call
We talk through your goals, users, and budget, and answer every question.
-
3
Proposal & fixed quote
You get a written scope, timeline, and price. No obligation.
contact@daydecoder.com
Ahmedabad, India
Get a free consultation
Takes under a minute. No spam, no obligation.