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

Hi Everyone - Trying to get Available Qty for an Item at a Location by Status... ie 3 New, 2 Used of Item A at Location B... I feel like the only way is to load an INVENTORY_BALANCE saved Search from the UI.... I'm struggling with guessing what the the filters need to be. I tried several combinations of... `["inventorynumber.internalid","anyof",serialID],"AND", ["location.internalid","anyof",locationID]`... etc.

build the search in the ui first, load it in code, then log its filter expression

Amazingly simple. :grinning: Greatly appreciated.