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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
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!
Refer a Member to the Community | Earn the Answer Accepter Badge | Vote for the contents you'd like to see
Tagged:
0