A client asked us to look into an inventory issue in NetSuite where they knew they had items available in a Bin, but the item record didn't show an equal number as available. If they tried to fulfill or transfer that item, there is no Inventory Detail option.
Couse of the Error: Item Fulfillment in a Closed Sales Order in NetSuite
After some troubleshooting, we could see that this was because the item had an item fulfillment in a closed sales order. An example of this is when Jacob orders an item from Amazon. The sales order is created, and then someone releases the order in a wave for fulfillment. It was picked up and packed, but it has not been shipped.
NetSuite Saved Search to Find These Item Fulfillments
Here is a handy NetSuite saved search to find out when this has happened.
Create a new Transaction search called AG |Closed SO Lines with Ifs
Use the following Criteria:
Display the following results:
Save and run! This search now will show any Sales Orders that have Item Fultillments that are not finished and will lock inventory.
Item SCH164500 - shows Bin R3-54A has two on hand and one available. That is because the above Item Fulfillment is holding that item.
Additional Steps to Manage The Locked Inventory Items in NetSuite
Now, you will be able to see item fulfillments that need to be deleted and the inventory transferred to the correct Bin!
To prevent these from being overlooked in the future, we recommend emailing the results to the warehouse manager so they can take timely action. It can also be helpful to add this as a reminder to the appropriate NetSuite dashboards.
Author: Dominick Meyer
Got stuck on a step in this article?
We like to update our blogs and articles to make sure they help resolve any troubleshooting difficulties you are having. Sometimes, there is a related feature to enable or a field to fill out that we miss during the instructions. If this article didn't resolve the issue, please use the chat and let us know so that we can update this article!
Oracle NetSuite Alliance Partner & Commerce Partner
If you have general questions about SuiteCommerce or more specific questions about how our team can support your business as you implement NetSuite or SuiteCommerce, feel free to contact us anytime. Anchor Group is a certified Oracle NetSuite Alliance Partner and Commerce Partner equipped to handle all kinds of NetSuite and SuiteCommerce projects, large or small!
