Discussions
Workflow to automatically detect committed quantity on backorder sales order
Our current setting in Netsuite for DEFAULT COMMIT OPTION ON SALES ORDER is Available Quantity. And we created a custom field called "To Sync" to control the sales order that needed to be sync over to external WMS system for fulfillment.
The default value for To Sync is Yes
At the moment, when the sales order is approved and become Pending Fulfilment, the integration program will pick up this sales order and fulfiled it via WMS. Once fulfiled, the To Sync tagging in sales order will be set to 'Completed'.
This works fine for full fulfilment.
However for partial fulfilment, when there's inventory replenishment, the same sales order's backorder quantity is being automatically committed, hence I need a way to set the To Sync back to Yes so that it will be picked up by the integration program for fulfilment. Anyone got idea on how to tackle this? Thanks!