I'm using inventorybalance to look at the quantities. I never had a problem but this morning. I'm adding all qty on hand - qty allocated and the qty it return is different than the qty on the item in the app. here is my select SELECT sum(quantityonhand), max(committedqtyperlocation) from inventorybalance where inventorybalance.item = 2152 and location = 119 it return 4685 but on the item in Netsuite, I see 2574 Thanks in advance

Try:

SELECT sum(quantityonhand-committedqtyperlocation)  from inventorybalance where inventorybalance.item = 2152  and location = 119