Scenario: Users may need to unmark the Make Inventory Available checkbox in a Location record, but encounters this message:
"The Make Inventory Available field cannot be modified while there are open sales order, transfer order, or work orders for this location. In order to modify this field, all transfer and sales orders must be fulfilled or canceled. All work orders must also be completed or closed."
Solution: As per SuiteAnswers ID 94755, this is a standard NetSuite error as system will not allow modifying records with dependent transactions on them.
It is advisable to create a transaction saved search that may aid in double-checking if there are no open orders causing the error. Here is how to create a transaction saved search showing any open orders left.
1.) Go to Reports > Saved Searches > All Saved Searches > New
2.) Choose Transaction
3.) Under Criteria tab > Standard Subtab, enter the following filters:
- Type | is any of Sales Order, Transfer Order, Work Order
- Status | is any of Sales Order: Partially Fulfilled, Sales Order: Pending Approval, Sales Order: Pending Billing, Sales Order: Pending Billing/Partially Fulfilled, Sales Order: Pending Fulfillment, Transfer Order: Partially Fulfilled, Transfer Order: Pending Approval, Transfer Order: Pending Fulfillment, Transfer Order: Pending Receipt, Transfer Order: Pending Receipt/Partially Fulfilled, Work Order: In Process, Work Order: Planned, Work Order; Released
- Location | is select the Location you are trying to unmark the Make Inventory Available checkbox for
4.) Under Results Tab > Columns Subtab, click on Remove All and enter the following fields:
- Type
- Document Number
- Status
5.) Change Search Title and click Save & Run
Hope this helps!