Auto-Creation of POs from MRP Planned Orders with Custom Approval Routing
100%Manual PO Creation Eliminated
DailyMRP Automation Frequency
CustomApproval Routing Logic
ZeroMissed Procurement Deadlines
A manufacturing client approached us with a pain point in their NetSuite MRP process.
While NetSuite's MRP engine could generate Planned Orders, it lacked two critical features:
This manual process was slowing down procurement, increasing the risk of missed purchase timelines, and bypassing their internal approval policy.
We designed a SuiteScript-based automation to:
We implemented a Scheduled Script that runs daily after the MRP process completes.
var po = record.create({
type: record.Type.PURCHASE_ORDER,
isDynamic: true
});
po.setValue({ fieldId: 'entity', value: vendorId });
po.setValue({ fieldId: 'location', value: locationId });
po.selectNewLine({ sublistId: 'item' });
po.setCurrentSublistValue({ sublistId: 'item', fieldId: 'item', value: itemId });
po.setCurrentSublistValue({ sublistId: 'item', fieldId: 'quantity', value: qty });
po.commitLine({ sublistId: 'item' });
// Set custom approver
po.setValue({ fieldId: 'custbody_custom_approver', value: approverId });
var poId = po.save();
Eliminated manual PO creation from Planned Orders, saving hours of administrative work each week.
Enforced custom approval rules without requiring user action.
Accelerated the procurement cycle immediately after MRP runs, ensuring production deadlines are met.
We hired Versich to rebuild our analytics stack after an internal project stalled. They came in, assessed the situation quickly, and delivered production-ready Power BI dashboards within weeks. Their DAX knowledge and data modelling skills are exceptional.
Versich understood our finance workflows from day one. They built dashboards that connected directly to our ERP and gave our leadership team real-time visibility into cash flow, margins, and budget vs actuals. The quality of the work and the speed of delivery were both outstanding
Before Versich, our reporting was scattered across spreadsheets with no single source of truth. They built us a Power BI environment that connects our warehouse, finance, and sales data in one place. Our operations team now makes decisions in hours instead of days
