When I create and fulfill a Sales Order, the on-hand quantity does not decrease immediately, but the available quantity remains unchanged on current sales order. For example: • Item ABC has 40 on hand and 40 available. • After creating and fulfilling a Sales Order for 2 units, it still shows 38 on hand, but the available quantity remains 40. • However, when I create a new Sales Order afterward, it correctly shows 38 on hand and 38 available. Why is the available quantity not updated immediately after fulfillment, and what might be causing this behavior?

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** The behavior you're observing is due to how NetSuite handles inventory quantities. The 'On Hand' quantity represents the total physical inventory you have for an item, while the 'Available' quantity is the 'On Hand' quantity minus any quantities that are committed to other transactions (like Sales Orders, Transfer Orders, etc.). When you create and fulfill a Sales Order, the 'On Hand' quantity decreases immediately because you've physically shipped out the item. However, the 'Available' quantity does not decrease immediately because NetSuite still considers the item as 'committed' to the Sales Order until the order is fully processed and closed. This is why you're seeing the 'Available' quantity remain unchanged immediately after fulfillment. When you create a new Sales Order afterward, NetSuite updates the 'Available' quantity to reflect the new 'On Hand' quantity because the previous Sales Order has been fully processed and closed, and the item is no longer 'committed' to it. This behavior is designed to prevent overselling of items. If the 'Available' quantity decreased immediately upon fulfillment, you could potentially sell more items than you physically have on hand if you have multiple Sales Orders being processed at the same time. If you're seeing this behavior consistently and it's causing issues, you may want to review your inventory management processes and settings in NetSuite. For example, you could consider using the 'Perform Item Commitment After Transaction' setting, which can help ensure that the 'Available' quantity is updated more promptly after fulfillment.