Skip to content

Instantly share code, notes, and snippets.

@W3BGUY
Last active January 25, 2023 15:20
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save W3BGUY/ecf874b078d8db5ae07c746d8eebade4 to your computer and use it in GitHub Desktop.
Save W3BGUY/ecf874b078d8db5ae07c746d8eebade4 to your computer and use it in GitHub Desktop.
NetSuite SuiteScript 2.0 - Search for Inventory Items and return an array of all active items.
require(['N/search','N/record'],function(search,record){
function buildItemArray(){
var itemArray=[];
searchItems();
itemArray=runSearch(itemArray);
deleteSearch();
log.debug(itemArray);
}
function searchItems(context){
var itemSearch=search.create({
type:search.Type.INVENTORY_ITEM,
title:'Inventory_Item_Search',
id:'customsearch_inventory_item_search',
columns:['internalid','itemid'],
filters:['isinactive','is','F']
});
itemSearch.save();
}
function runSearch(itemArray){
var mySearch=search.load({id:'customsearch_inventory_item_search'});
mySearch.run().each(function(result){
var item={};
item.itemID=result.getValue({name:'itemid'});
item.internalID=result.getValue({name:'internalid'});
itemArray.push(item);
return true;
});
return itemArray;
}
function deleteSearch(){
search.delete({id:'customsearch_inventory_item_search'});
}
buildItemArray();
});
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment