ISSUE There was an issue that item search from a restlet script showed empty results for a specific role used for integration. When the search is executed in UI, results are present but when run through restlet script it shows empty results. SOLUTION The issue was with the subsidiary restriction permission issues. The custom role… Continue reading Issue with showing empty search results for item search in restlet
Tag: item search
create a Saved Item Search Showing Inventory by Location
create a Saved Item Search Showing Inventory by Location
Item saved search to fetch the item details by passing an array of items
Jira Code : MICL-351 Description The below item search defines how to pass an array of item codes in the search criteria to fetch its details. We can pass a maximum of 1000 item names in the Search criteria Solution
Function to search for the list of items with no sales description
Function to check if the item exists or not with a unique item name
Function to check if the item exists or not with a unique item name
Saved Search to Show the Last Item Receipt Date per Item and its Age as of Today
1. Navigate to Lists > Search > Saved Searches> New > Item. 2. Under Criteria tab, enter the following: a. Type: Inventory Item b. Transaction Fields..Type: Item Receipt 3. Under Results tab, enter the following: a. Name| Summary Type: Group b. Display Name | Summary Type: Group c.Transaction Fields..Date | Summary Type: Maximum d.Formula (Text) | Summary Type = Maximum | Formula = round({today}-{transaction.datecreated},0) 4. Enter a Search Title and hit Save.
Saved Search to Show the First Item Receipt Date per Item
Jira Code : BGGN-615 Solution
Item search for getting available Bins for an item
/** *@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
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