I want to know itemid,internalid,description,location,lotnumber,quantityonhand,availble columns of inventory item.

AI generated answer (using internal Slack threads):

To retrieve the

itemid

,

internalid

,

description

,

location

,

lotnumber

,

quantityonhand

, and

available

columns of an inventory item, you can use the

search

module in SuiteScript. Here is a sample code snippet:

javascript
var itemSearch = search.create({
    type: search.Type.INVENTORY_ITEM,
    columns: ["internalid", "itemid", "description", "location", "inventorynumber", "quantityonhand", "quantityavailable"],
    filters: ["internalid", "is", skuId],
});
var resultSet = itemSearch.run();

In this code,

skuId

is the internal ID of the item you are searching for. The

run

method executes the search and returns the result set. You can then iterate over the result set to retrieve the values of the columns. Please note that the

inventorynumber

field represents the lot number. The

quantityonhand

and

quantityavailable

fields represent the quantity on hand and the available quantity respectively. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******