Software Manufacturing

MRP Platform

Material requirements planning for mid-size manufacturers: BOM explosion, demand forecasting, and PO generation in one workflow. Role-based, audit-logged.

Domain
Software Manufacturing
Technology
MRP · BOM · Node.js · PostgreSQL · Manufacturing Software
96+
Screens
46
API Routes
9
Modules
JWT + RBAC
Auth
PostgreSQL
Database
React 18
Frontend
Module 01 · Material & BOM

From demand signal
to every component needed.

The MRP engine explodes multi-level BOMs against demand forecasts and open sales orders, netting available stock and open POs to produce a precise, time-phased procurement plan — automatically.

Multi-Level BOM Explosion
Explodes any finished good through unlimited nesting levels — raw materials, semi-finished, and sub-assemblies — in one pass.
Net Requirements Calculation
MRP engine computes net demand per material, netting on-hand stock and open POs before generating planned orders.
Moving Average Cost
Real-time material valuation using weighted moving average. Every GRN and production issue updates unit cost immediately.
Batch & Lot Traceability
Full trace from supplier lot number to finished goods serial. Recall scopes can be identified in seconds.
Reorder Point Alerts
Min/max levels per material, per warehouse. Triggers procurement suggestions when stock falls below safety stock.
Stock Valuation Report
Point-in-time snapshot of total inventory value. Drill down by category, warehouse, or cost centre.
Module 02 · Production Planning

Schedule every work order.
See bottlenecks before they happen.

Work orders flow from MRP planned orders through scheduling, material issue, shop-floor progress reporting, and final closure — with every step logged and cost-captured in real time.

Work Order Management
Create, schedule, release, and close production orders with full status tracking from planned to closed.
Gantt-Based Scheduling
Visual production schedule across machines and workcenter. Spot conflicts and overloads before they hit the shop floor.
Capacity Planning
Compares planned workload against available machine hours. Identifies bottlenecked workcenters weeks in advance.
BOM-Driven Material Issue
When a work order is released, required components are automatically reserved and issued based on the BOM.
Real-Time Progress Tracking
Shop-floor reporting updates WO completion percentage per operation. Management sees live production status on the dashboard.
Scrap & Rework Logging
Records scrap quantities and rework loops per operation and per work order. Feeds into quality reports and cost variance analysis.
Production Schedule — Live View
MRP System
Dashboard
Material Mgmt
Purchase
Warehouse Mgmt
Asset Mgmt
Production
Sales & Dist.
Finance
HRD
Production Schedule
Week 21 · 20–26 May 2024 · Workcenter: All
4 Active1 Delayed
12
Open WOs
6 this week
87%
On-Time Rate
↑ 4% vs last wk
3
Overdue
need rescheduling
28
Open POs
5 arriving today
Mon 20
Tue 21
Wed 22
Thu 23
Fri 24
Sat 25
Sun 26
WO-2024-038
Pump Body Assy
80%
WO-2024-039
Valve Sub-Assy
35%
WO-2024-040
Motor Bracket
✓
WO-2024-041
Sensor Housing
WO-2024-042
Control Panel
WO-2024-043
Frame Weldment
60%
Module 03 · Procurement & Warehouse

Right material, right location,
right time.

MRP-suggested POs convert to real purchase orders in one click. Receiving, three-way matching, and warehouse putaway are handled by the same system — no data re-entry, no reconciliation spreadsheets.

MRP-Driven PO Generation
One-click conversion of planned orders to purchase orders. Supplier, price, and lead time pulled from vendor master.
Goods Receipt (GRN)
Receives PO quantities per line, updates stock levels and moving average cost in a single transaction.
Three-Way Matching
PO → GRN → supplier invoice reconciliation before any payment is released. Discrepancies flagged for review.
Multi-Location Warehouse
Rack, row, bay, level addressing for precise stock placement. Supports multiple warehouses with independent par levels.
FIFO / FEFO Picking
Enforces first-in-first-out or expiry-date-based picking for every goods issue. Reduces write-offs from expired stock.
Transfer Orders & Audit Trail
Internal stock movements require approval and are fully logged. Every bin change is traceable with timestamp and user.

Built to last without the original team.

Config-driven React frontend — adding a new page is one entry in routes.js. Raw SQL with parameterized queries — no ORM magic, no surprise migrations. JWT + RBAC with per-permission granularity. Audit log on every mutation. Designed so any competent developer can take it over and be productive in one day.

React 18 + Ant Design
Config-Driven Frontend
Single routes.js drives menu, routing, permissions, breadcrumbs, and page titles. No duplicate nav configs anywhere in the codebase.
Node.js + PostgreSQL
Raw SQL, No ORM
Parameterized queries, model abstraction layer, Winston logging, and AJV schema validation. 46 route files, all under 500 lines.
JWT + RBAC
Role-Based Access Control
Per-menu, per-action permission model. Account lockout, rate limiting, token blacklisting on logout, and full audit trail on every mutation.
AVENXOR
ServicesContact
IDStart a project
AVENXOR

Tech & data consultancy. Engineering systems that move the world.

Practices
EmbeddedPLCSoftwareData
Company
WorkProcessContact
Contact
[email protected]Jakarta, Indonesia
© 2026 Avenxor StudioBuilt in Jakarta