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.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
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