Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Advanced Bin Search - On hand greater than zero
I'm stuck building a search to show items with quantity on hand greater than zero with the advanced bins feature on.
It only seems to fail when I use a search filter expression (which I have to use because I am using the 'OR' between expressions.
So, the following works:
var filter = new nlobjSearchFilter('quantityonhand', 'binonhand', 'greaterthan', 0); var results = nlapiSearchRecord('item', null, filter);But, as an expression, it fails with "Code: INVALID_SEARCH_OPERATOR Details: You need to provide a valid search field operator."
Here is what the expression search looks like:
var filter = ['quantityonhand', 'binonhand', 'greaterthan', 0]; var results = nlapiSearchRecord('item', null, filter); 0