Why is NetSuite Inventory On Hand But Not Available for Transactions?

Several factors can contribute to inventory appearing 'On Hand' but not 'Available' for transactions in NetSuite. Consider the following potential causes:

1. Multi-Location Inventory ConfigurationWhen utilizing multi-location inventory, ensure the correct Location is selected on the transaction. Inventory is linked to its specific location. The ability to select a Location at the header or line item level depends on preferences found under Setup > Accounting > Accounting Preferences > General (often found under Classifications or directly on the General subtab). If preferences dictate line item level location selection and the location column is absent, NetSuite may struggle to determine the correct inventory pickup location.

2. On Hand vs. Available InventoryDistinguish between 'On Hand' and 'Available' inventory. 'On Hand' represents the physical quantity in a location, but a portion may be committed to sales orders. The 'Available' quantity is the uncommitted stock in a location, calculated as:

qty On Hand - qty Committed

If all 'On Hand' inventory is committed, no items will be 'Available'.

1. Item Record Account SetupThe setup of accounts on the item record can also render an item unavailable for selection on a line item.

2. OneWorld Subsidiary ConfigurationIn a NetSuite OneWorld environment, an item's unavailability can stem from the subsidiary configuration on its item record, particularly when it does not align with the customer's subsidiary selected on the transaction.

3. Clarifying 'Unavailability'It is important to clarify the nature of 'unavailability': whether the item cannot be selected from the item dropdown on a line item, or if an inventory warning is received preventing fulfillment.