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.
