Scenario
User wants to know what caused the negative inventory in their account.
Solution
This could happen if your preference setup allows the system to push through with Sales Orders or other inventory reducing transactions to push through even if the current Quantity on Hand is Zero or Lower than what will be deducted.
This preference is the Fulfill Based on Commitment. To see this you navigate to Setup > Accounting > Accounting Preferences > Order Management Fulfillment.
Depending on the Fulfill Based on Commitment preference, a company may experience having negative inventory. This is usually encountered when the preference is set to either Allow Uncommitted or Ignore Commitment and not to Limit to Committed.
We have available Saved Searches and Reports to show negative inventory and check transactions that might have caused them. Here are some of the available articles:
• 79003 - Item Saved Search to Show Negative Inventory Quantity per Location
• 65286 - Negative Location Quantity On Hand Saved Search
But NetSuite also has an easier way to identify if there are negative inventory values. Just navigate to Transactions > Inventory > Review Negative Inventory. Try it now and have a quick check if you have any negative inventory values you might not be aware of. You can make use of the above search/report to identify and correct transactions if needed.
To avoid having negative inventory, you can check SuiteAnswers ID 28074 - Avoiding Underwater Inventory.
-----
If you find this information useful, let us know by reacting or commenting on this post!