In our NetSuite account we had an inventory item recently created, and there was a Purchase Order and an Item Receipt to receive one bottle in a location. for some reason the item showed 1 on hand, 1 available, 1 backordered, and -1 committed. If we add a Sales Order for this one bottle, the committed goes to 0, Available stays at 1, and backordered stays at 1. We quarantined the item by creating a copy and making an inventory adjustment to the new item. Now this messed up item show 0 on hand, 0 available, 1 backordered, and -1 committed.

I was just wondering if this would be caused in NetSuite's database? I'm more worried about it happening again to another item since I can quarantine this item, so I want to make sure to avoid it in the future.