Create Work Orders by Scripting with Map/Reduce in NetSuite

Starting in NetSuite 2025.1, a new capability has been introduced for creating work orders for configured items through scripting. This enhancement is particularly relevant for users working with NetSuite CPQ Manufacturing, version 1.2.3 and later. By leveraging a map/reduce script, specifically the CPQM-MR-WOC script, developers can automate the work order creation process directly from server-side scripts such as Suitelets, RESTlets, user-event scripts, or scheduled scripts.

Overview of the New Feature

The process of creating work orders can now be integrated into automated workflows. Here’s how it works:

• Server-Side Script Requirement: Before invoking the map/reduce script for work order creation, developers must create any one of the following server-side script types:
  • Suitelet
  • RESTlet
  • User-Event script
  • Scheduled script
• Launching the Map/Reduce Script: Once the server-side script is ready, the developer can launch the CPQM-MR-WOC map/reduce script by calling customscript_cpqm_mr_woc.
• Work Order Creation Handling: This map/reduce script takes care of generating work orders based on the user-defined criteria.

Reconvert Existing Work Orders

If there is a need to update existing work orders with the most recent data, developers can use a script parameter:

• Set custscript_cpqm_force to true to allow the reconversion of up-to-date work orders. This can be particularly useful in maintaining current inventory records.

Important Considerations

• If developers encounter issues with the scheduled script due to the volume of configurable items, it is advised to transition to the CPQM-MR-WOC map/reduce script. Scheduled scripts may not efficiently handle high loads in new implementations.

Who This Affects

This new feature impacts the following roles and modules:

• Administrators: Responsible for implementing scripting solutions.
• Developers: Need to understand how to utilize the new scripting functionality for work orders.
• Inventory Managers: Will benefit from improved work order creation processes within their workflows.

Key Takeaways

• In NetSuite 2025.1, work orders can now be created by scripting using a map/reduce approach.
• Launch the CPQM-MR-WOC script from any supported server-side script types.
• Use the custscript_cpqm_force parameter for reconversion of existing work orders.
• Avoid using scheduled scripts for new implementations involving high volumes of configurable items.
• This feature enhances inventory management capabilities within CPQ Manufacturing.