Negative Quantity Committed on Sales Orders
Every few months, we have a problematic order that will cause an inventory item to show negative quantity committed. I’ve contacted Support about this and they offer no solution for preventing it, and advise that we wait for NetSuite to flush out the erroneous quantity, which generally happens within a week of the incident.
In the case of the last one, we started out with the kit version of an item (we carry both the components to create the inventory version and the inventory version itself) and switched it to the Inventory version to get the order out earlier.
I’ve tried to replicate this in Sandbox and cannot get it to do this. I’m not really sure how unshared inventory would affect committed quantity, but perhaps I’m missing something.
Any ideas and strategies we can adopt to avoid this in the future? Is this something you run across with your inventory?
It turns out, for some key items, we carry the components for and also the entire unit for some products. Sometimes, if our entire unit inventory item is low in stock, we will create a Kit from components. In this process, we swap out one type for the other. The process the team was using did not properly flush the items out of committed, resulting in a negative quantity committed.
We have since identified a proper procedure for such changes.