This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Is there any way to get the item `quantityavailable` using N/query SuiteQL? I haven't found anything in the query that supports the available quantity of an item.

You could sum over the locations quantityavailable

quantityavailable is not exposed in the query

you should be able to find details about how to join the item to the `aggregateItemLocation`  in the <https://system.na0.netsuite.com/app/recordscatalog/rcbrowser.nl?whence=#/record_ss/item|records catalog>

if you are very unfortunate, you will have to join `inventoryNumber` and `InventoryNumberLocation`