To find items with the same display name but different manufacturers in a NetSuite saved search, you can use a combination of filters and formulas. Here’s how you can approach it: 1. **Create a Saved Search**: – Navigate to **Lists > Search > Saved Searches > New** and select the **Item** record type. 2. **Set… Continue reading How to find all items with the same MPN but different manufacturers in a saved search?
Tag: item search
Need to show most recent invoice date on a saved search
Requirement: I have an item search where I need to see the most recent invoice date, the problem is I cant use summary because iI need all the other fields from the results visible. I have transaction date on the results but the problem is I only want the most recent not all Here is… Continue reading Need to show most recent invoice date on a saved search
Update the item image on search result popup with item record field value
In website setup added the field ‘custitem_large_item_00’ in the field sets, Type Ahead section. To get the field value in context. Extend the view ItemsSearcher.Item.View to update the image. The extension needed to be in shopping , myaccount, checkout section. In js file added the below code // To update the item image on itemsearch modal… Continue reading Update the item image on search result popup with item record field value
Issue with showing empty search results for item search in restlet
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
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