var inventorybalanceSearch = nlapiSearchRecord("inventorybalance",null,
[
["item.type","anyof","Assembly"],
"AND",
["binnumber","anyof","8521"],
],
[
new nlobjSearchColumn("item",null,"GROUP").setSort(false),
new nlobjSearchColumn("name","inventoryStatus","GROUP"),
new nlobjSearchColumn("inventorynumber","inventoryNumber","GROUP")
]
);
var result = inventorybalanceSearch[0];
var columns = result.getAllColumns();
var columnLen = columns.length;
nlapiLogExecution('DEBUG','result', result)
nlapiLogExecution('DEBUG','columnLen', columnLen)
for (i = 0; i <= columnLen; i++)
{
var column = columns[i];
var value = result.getValue(column);
resultArray.push(value)
// nlapiLogExecution('DEBUG', 'resultArray', resultArray);
// nlapiLogExecution('DEBUG', 'inventoryStatus', resultArray[1]);
}
var inventoryStatus = resultArray[1]
nlapiLogExecution('DEBUG', 'inventoryStatus', inventoryStatus);
return inventoryStatus