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

var invBalanceSearch = search.create({
    				type : search.Type.INVENTORY_BALANCE,
    				filters : [
    				           ['item.internalid','anyof',itemName],
							   'and',['location','anyof',locationName],
    				           'and',['onhand','greaterThan',0]
    				           ],
    				columns : [
    				           search.createColumn({name : 'onhand'}),
    				           search.createColumn({name : 'inventorynumber'}),
							   search.createColumn({
								name: "expirationdate",
								join: "inventorynumber",
								sort: search.Sort.ASC
							   })
    				          ]
    			});