NSC | Get Inventory Detail of Sales Orders Using SuiteScript’s N/search Module

Retrieving which inventory detail information in Sales Orders can be used in different use-cases including streamlining the fulfillment process. Here is a sample code of how you can get the inventory number of line items via SuiteScript.

var transactionSearchObj = search.create({
   type: "transaction",
   filters:
   [
      ["inventorydetail.inventorynumber","noneof","@NONE@"]
   ],
   columns:
   [
      search.createColumn({name: "tranid", label: "Document Number"}),
      search.createColumn({
         name: "inventorynumber",
         join: "inventoryDetail",
         label: " Number"
      })
   ]
});
var searchResultCount = transactionSearchObj.runPaged().count;
log.debug("transactionSearchObj result count",searchResultCount);
transactionSearchObj.run().each(function(result){
   //perform operations for each result
   return true;
});

Got any feedback? Let us know in the comments!