netsuite查询货品库存

		//单品可用数量获取var inventorySearch = search.create({type: 'inventoryitem',filters: [['internalid', 'is', lineItem2.nsSkuId] // 根据 SKU ID 进行筛选],columns: [search.createColumn({name: 'locationquantityavailable',summary: 'SUM'}) // 获取可用库存总和]});var resultSet = inventorySearch.run();var results = resultSet.getRange({start: 0,end: 1}); // 假设只获取第一个结果if (results && results.length > 0) {var availableQtySum = results[0].getValue({name: 'locationquantityavailable',summary: 'SUM'});// if (availableQtySum>lineItem2.qty) {//   lineItem2.qty=0;// }else{//   lineItem2.qty=lineItem2.qty-availableQtySum;// }lineItem2.nsSkuAvailableStock=availableQtySum;} else {lineItem2.nsSkuAvailableStock=0;}