The “Print” option missing from the record typically occurs due to one of the following reasons: 1. Form Customization The current record form might have the Print button disabled. Check the form customization settings: Go to Customization > Forms > Transaction Forms. Locate the form associated with the record Click Edit on the form. Under… Continue reading Display print option in a record
Category: NS Administration
All articles / code related to Netsuite administration
How to Create a Saved Search Showing Sales Orders with only Two Specific Items
Scenario User would like to create a Saved Search that shows Sales Orders containing only two specific items. The saved search results should return Sales Orders with the following items: Item A Item B Item A and Item B If the Sales Order contains different items than those mentioned above, or, if those items are in the… Continue reading How to Create a Saved Search Showing Sales Orders with only Two Specific Items
REGEXP Formula for name format: ABC-1234
Scenario User needs to create a Saved Search to identify all products whose SKUs follow a specific format: “ABC-1234” The first 3 characters are 3 upper case letters Followed by a hyphen and the last 4 characters are 4 digits Solution Use a REGEXP formula in your Saved Search Criteria to filter items based on… Continue reading REGEXP Formula for name format: ABC-1234
REGEXP Formula to Get Email Domain
Scenario User wants to create a Saved Search to extract the domain names from customer email addresses in order to analyze the distribution of email domains among its customer base to better understand its market demographics and tailor marketing strategies accordingly. Solution REGEXP_SUBSTR formula can be used in Saved Search Results to extract the domain name part of… Continue reading REGEXP Formula to Get Email Domain
Saved Search Formula to Extract Characters of a String
Scenario User needs to create a Saved Search formula to extract the first 4 characters of a string.. For example, the string is “netsuite”. The needed result is only “nets”. Solution Use the SUBSTR function to extract the desired substring. Formula: SUBSTR({fieldid}, 1, 4) Explanation: {fieldid}: Represents the field containing the string from which you want to… Continue reading Saved Search Formula to Extract Characters of a String
NVL Function Explained
Overview NetSuite Saved Searches are indispensable for data extraction and analysis. However, dealing with null values can complicate analysis. Enter the NVL function, a powerful tool for substituting nulls with desired values. Understanding the Syntax NVL(expression, substitute_value) The NVL function evaluates ‘expression’ and returns ‘substitute_value’ if ‘expression’ is null; otherwise, it returns the value of ‘expression’ itself. For example:… Continue reading NVL Function Explained
NVL2 Function Explained
NetSuite Saved Searches are vital for extracting and analyzing data, yet handling conditional data scenarios can be challenging. NVL2, a SQL function, offers a solution by providing nuanced handling of null and non-null values, enabling more flexible and accurate analysis. Understanding the Syntax NVL2(expression, value_if_not_null, value_if_null) NVL2 evaluates ‘expression’ and returns ‘value_if_not_null’ if ‘expression’ is not null;… Continue reading NVL2 Function Explained
NULLIF Function Explained
In NetSuite Saved Searches, data inconsistencies can disrupt accurate analysis. Enter the NULLIF function, a powerful SQL tool designed to address such issues by comparing two expressions and returning null if they are equal. This article explores how the NULLIF function can be utilized to handle specific data discrepancies and ensure more reliable analysis results. Understanding the Syntax NULLIF(expression1,… Continue reading NULLIF Function Explained
SUBSTR Function Explained
Overview In NetSuite Saved Searches, efficient data manipulation is key to extracting valuable insights. The SUBSTR function emerges as a fundamental tool in SQL for extracting substrings from strings based on specified criteria. Understanding the Syntax SUBSTR(string, start_position, length) The SUBSTR function retrieves a portion of the ‘string’ starting from the ‘start_position’ and extending for a specified ‘length’. For… Continue reading SUBSTR Function Explained
INSTR Function Explained
Overview In the dynamic landscape of NetSuite Saved Searches, adept utilization of SQL functions is indispensable for seamless data exploration and manipulation. Among these functions, the INSTR function emerges as a pivotal tool for discerning the position of substrings within strings. Understanding the Syntax INSTR(string, substring [, start_position [, nth_occurrence]]) The INSTR function searches for the occurrence of ‘substring’… Continue reading INSTR Function Explained