Project Summary

This customisation split Sales Order imported into NetSuite from Shopify if there were a mix of Pre-Order items and items which were in stock. This allowed for better order management, and allowed items which were in stock to be shipped completely before the Pre-Order items.

The Child Orders would be related to the original imported Sales Order, which would become the Parent Order. The Parent Order would have a minimum of 2 Child Orders, the Pre-Order items and the in stock items. The Pre-Order items would also be split and grouped based on their Pre-Order date. All Child Orders would be visibile under a new custom subtab called "Child Orders" under the "Related Records" subtab of the Parent Order.

Project Components

• User Event Script - Script to mark incoming Sales Order for splitting (due to a delay in the Customer Deposit coming into NetSuite, the splitting could not be done in this script)
• Map Reduce Script - Script which would split the Sales Order into separate Child Orders
• Map Reduce Script - Script which would approve the Pre-Order Child Orders to be fulfillable with 3PL Partner
• Saved Search - Saved Search for all Sales Orders pending splitting process
• Saved Search - Saved Search for all Child Orders which relate to the Parent Order
• Custom Fields - Numerous custom fields which would contribute to the functionality