Scenario: A formula can be used to add hyperlink to your Saved Transaction Searches which directs users to the Item record. Solution: Go to Reports > Saved Searches > All Saved Searches > New. Select Transaction. Click the Results tab.Add a Formula (Text) to the Search columns.Enter this as the formula: ‘<a href="https://.app.netsuite.com/app/common/item/item.nl?id=’ || {item.internalid}… Continue reading User needs to redirect to item record from the transaction saved search.
Tag: Saved search formula result
Saved Search Formula to Get the Decimal Part of a Number
Solution The formula to use to get the decimal places of any given number is: mod({number},1) Note: Change {number} to any field ID of any given number.
Handle commas in a saved search result from the NSCONCAT function
Recently, I had to fetch some URLs and file names stored in a custom record related to another record. The challenge was to handle the commas inserted using the NSCONCAT function.My solution was to use the string.replace() function to replace commas in the file names with ‘%2C’ and URLs before concatenating the search result and… Continue reading Handle commas in a saved search result from the NSCONCAT function
Tip: Saved search by adding available filter as a formula in criteria without any value.
Concern: How to include a formula inside the criteria that will be utilized as the available filter without any value in order to display the entire results. Solution: We will be giving the formula description as “Contains” with value ” “.
Search formula to find the length of a string which contains both char & int together
//Info: NFCC-31 We came across a situation in which we needed to determine the length of an entity record’s external id. The External id field’s value is a combination of characters and integers. By default, in a saved search, selecting Formula(Numeric) as criteria and then adding Function as length, Field, etc. results in LENGTH(char)externalid. The… Continue reading Search formula to find the length of a string which contains both char & int together
To open the link in a saved search result in a new Tab
Scenario: Need to open the link in a new tab of the saved search result. Solution The links can be created using Formula(Text). We can specify the navigation using the <a> tag. You can add target=”_blank” along with the URL. This will make the link to be opened in a new tab when it is… Continue reading To open the link in a saved search result in a new Tab
CREATE A CUSTOM FIELD THAT USES CALCULATED DATA FROM A SAVED SEARCH
Sample: Determine the total quantity of all items on a sales order Step 1: Create Saved Transaction Search For our Results, we only need to include the field that we are calculating on. In this example, it’s the Quantity field. Once we choose the field, we will use SUM as our Summary Type. Set a… Continue reading CREATE A CUSTOM FIELD THAT USES CALCULATED DATA FROM A SAVED SEARCH
Changing Date Format in Saved Search
If you want to change the date format of a date field in Netsuite Saved Search, do the following Open the search and in go to the Result subtab Add Formula (Text) On the Formula field, add TO_CHAR({fieldid},’DateFormat’) For Example : TO_CHAR({trandate},’MM/DD/YY’) Click Add
Unable to Sort Saved Search by Formula Field
Unable to Sort Saved Search by Formula Field
Saved Search formula to avoid Item Hierarchy
In item search to avoid the parent name: For example, When we add field {name} or Name in saved search, the result shows: ‘INVENTORY : 10pc_glass_container_set’ as the item record is saved as the sub item: So in order to display the result with just the item name without hierarchy, (in this case, just ’10pc_glass_container_set’… Continue reading Saved Search formula to avoid Item Hierarchy