/** *@description Available bin search – This function will return object of bin name and their quantity * @param itemName Name of the item * @return {Object} */function availableBinSearch(itemName) { try { var itemSearchObj = search.create({ type: “item”, filters: [ [“name”, “is”, itemName.toString()], “AND”, [“inventorydetail.binnumber”, “noneof”, “@NONE@”], “AND”, [“binonhand.quantityavailable”, “greaterthan”, “0”] ], columns: [ search.createColumn({… Continue reading Item search for getting available Bins for an item
Tag: item search
Multiple item names in item search criteria
Function /** * @description Multiple item names can be included in a single search limit is 1000 names per search via suitescript. * @param {Array} itemNameArray Array of item names (1000 item names) * @return {Object} */ function itemSearchforVendorUpdate(itemNameArray) { try { var b = “”; if (itemNameArray.length > 0) { for (var i =… Continue reading Multiple item names in item search criteria
Set Multiple Item Names as a criteria filter in an Item Saved Search
Set Multiple Item Names as a criteria filter in an Item Saved Search Navigate to Reports> Saved Searches> All Saved Searches> New 2. Select Item as Search Type 3. Assign a name on the Search Title field 4. On the Criteria tab > Standard sub tab> Filter column, add the following: a. Formula (Numeric) is equal to 1 then b. Formula = Case when {name}=’XXXX’ OR {name}=’XXXX’ then 1 else 0 end… Continue reading Set Multiple Item Names as a criteria filter in an Item Saved Search