NetSuite Admin Tip: How to Fix Sales Order "Pending Fulfillment" Status When a Defective Special Order Item Has Been Returned to the Vendor
Sample Scenario: A defective Special Order Item is already returned to the vendor but the related Sales Order still has "Pending Fulfillment" status.
This tip will help the user fix the Sales Order "Pending Fulfillment" status without throwing off the Item quantity to negative. When a Sales Order for a Special Order Item is created, a Purchase Order is automatically created. However, even after the item return process is done in the Purchase Order, this change will not automatically reflect in the Sales Order since they are separate records.
Action Items:
1. Fulfil the Sales Order
2. Process item return on Sales Order, then receive it back
Detailed Steps:
1. Go to the Sales Order record and click on the "Fulfill" button
2. Go back to the Sales Order record, then click on the "Authorize Return" button and Hit "Receive"
Below is the effect of the above transactions on the item qty on hand:
1. Initial Quantity before Fulfillment = 0
2. Quantity after Item Fulfillment = -1
3. Quantity after Item receipt = 0
Another Workaround:
You can also choose to close the Sales Order record instead of processing the return. This would also not throw off the quantity to negative.
To other members, please feel free to share your thoughts on the thread if you have other ways of fixing the Sales Order status without throwing the qty on hand to negative. This will help our users especially the ones in the Buy and Sell businesses that frequently use Special Order items.