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

inventory item "quantityAvailable" does not appear to always be present/valid? i have some items for example that instead seem to have a body field "price1quantity1". what's this mean, where do i find it in the docs? how do i reliably get the number of items available?

`quantityavailable` is not a field on the <https://tstdrv1555136.app.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2023_2/script/record/inventoryitem.html|Inventory Item record>, so it is not accessible via the Record API. It is a Search Column in the <https://tstdrv1555136.app.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2023_2/script/record/item.html|Item table>, so it is accessible via the Search API.

i _am_ using searches, but i'm not getting values for some records

i was <https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2016_2/schema/record/inventoryitem.html|looking at these docs> which google sent me to, and it's just not the same thing as the one you linked i assume

That link is:
• for version 2016.2
• to the Schema Browser, which only applies to the SOAP API

any idea why some would just be returning null? even though if i click view on the item it shows some data (in this case, 0) in the warehouse

How to Records Browser: <https://stoic.software/articles/records-browser/>

(on hand, committed both = 5 here, for the only location)

might not actually be null - i'll have to redo my test with the search api

i'll follow up if i can't figure it out :sweat_smile:

```{internalid: Array(1), quantityAvailable: ''}
internalid: [{…}]
quantityAvailable: ""```


<https://www.reddit.com/r/Netsuite/comments/jsd9wo/quantity_available_is_blank_instead_of_zero/>

i guess it just reports 0 as an empty string for some awful reason

although this post is 4 years old, at least it confirms that this is expected rather than unexpected