VERSICH
Auto-Creation of POs from MRP Planned Orders with Custom Approval Routing

Background - The Client Challenge
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:
- Automatic Conversion to Purchase Orders (POs) - Users had to manually convert every planned order into a real PO.
- Custom Approval Routing - The client’s procurement process required approval routing based on department, amount, or item category—something NetSuite doesn’t natively apply to MRP outputs.
This manual process was slowing down procurement, increasing the risk of missed purchase timelines, and bypassing their internal approval policy.
Our Objective
We designed a SuiteScript-based automation to:
- Convert MRP Planned Purchase Orders into actual POs automatically after MRP runs.
- Apply custom approval logic before the PO is submitted for processing.
Our Solution - Script Workflow
We implemented a Scheduled Script that runs daily after the MRP process completes:
- Identify Planned Orders
- Runs a Saved Search to pull all MRP-generated Planned Orders for items requiring purchasing.
- Create Purchase Orders Automatically
- For each Planned Order, the script loads item/vendor details.
- Creates a new Purchase Order (
record.Type.PURCHASE_ORDER
). - Populates fields such as item, quantity, location, and vendor directly from the Planned Order.
- Apply Custom Approval Routing
- Sets approver dynamically based on department, PO amount, or item category.
- Routes the PO through the client’s established internal workflow.
- Error Handling & Reporting
- Logs any errors and emails a summary report to procurement and operations teams
Code Snippet

Business Impact
- Time Savings: Eliminated manual PO creation from Planned Orders, saving hours of admin work each week.
- Policy Compliance: Enforced custom approval rules without requiring user action.
- Operational Speed: Accelerated procurement cycle immediately after MRP runs, ensuring production deadlines are met.