Scenario: The User wants to get the list of items, the name of the items ends with (-MR). Create an Item saved search: Go to Lists > Search > Saved Searches > New. Select “Item” as the record type for the saved search. Give a name to the saved search and click on the “Criteria”… Continue reading How to List Items with Name ends with (xxx)
Tag: saved search formula
Commission calculation based on employee contribution
The user can calculate the commission payable to employees for every invoice based on the contribution percentage of employees. Create transactions saved search Go to Lists > Search > Saved Searches > New Select type as Transactions Set the title of your saved search (e.g. “Commission Calculation by Employee Contribution“). In the Criteria tab, add… Continue reading Commission calculation based on employee contribution
Show the required format for the date in the saved search result.
Under saved search results, select Formula Text. Type the formula as shown.
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
How to find Number of months between two given dates
If we want to set Yes if the Customer placed an order within last 24+ months and set No if the Customer placed an order within last 24 months in a Transaction saved search.
Using TRIM, LTRIM, and RTRIM for Formula functions
This article gives examples on using some common string functions that can be used for NetSuite search formulas via user interface or script, and on custom formula fields. TRIM: Removes leading or trailing characters (or both) from a character string Syntax: TRIM([ { { LEADING | TRAILING | BOTH } [ trim_character ]| trim_character}FROM ]trim_source)… Continue reading Using TRIM, LTRIM, and RTRIM for Formula functions
Item Saved Search Throws an Error: “Your formula contains a reference to a field for which you do not have a permission”
Item Saved Search Throws an Error
Script to convert date to another time zone and add days to the date using single saved search formula
Script to convert date to another time zone and add days to the date using single saved search formula
Extract Month and Year from Date field
The formulas for extracting Months and Year from a date field in saved searches TO_CHAR({datecreated},’MONTH’) – displays month name (Character) as result. Ex: Aprilinstead of ‘Month’ we can specify the format in which the month should be displayed.MON – Jan, Feb, etcMM – a numeric month from 1 to 12 TO_CHAR({datecreated},’YYYY’) – displays year in… Continue reading Extract Month and Year from Date field