This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi,

I am trying to get the inventory lot number, inventory on hand and inventory status field of an lot numbered item in specific location using suite script (The same information under inventory detail tab for an  item and sublist name is Inventory Detail).
I have created an search Inventory Balance record and obtained the expected values but it seems that the record is supported by suitescript

inventorydetail sublist is not present in record browser so it cant invoke using N/record module

var ItenRecord = record.load({
    type: 'lotnumberedinventoryitem',
    id: id
});
var sublistFieldValue = ItenRecord .getSubrecord({
    fieldId: 'inventorydetail'
});

Please share if any workaround
Thank you

Could you take your search, load it in script, add in the items/ location etc to the criteria, run the search and extract the search result data?

Thank you for the insight

Its worked when loading the search

let searchObj = search.load({id: savedSearchId,
type: search.Type.INVENTORY_BALANCE});

The only think that we need to mention the search type as the as a mandatory option(due to the Inventory Balance being a standalone search)

Suite Answer : 78232

Thank you