In many companies undergoing audits, administrators may be tasked with ensuring that reports meet audit and compliance standards, such as documenting when they were generated. Adding a timestamp and the account number where the report was generated to exported PDF reports is an effective way to achieve this. The timestamp indicates when the report was… Continue reading Add a Timestamp and URL to Exported PDF Reports
Author: Hormese Paul
Remove Item Group “parent” line from a Transaction Saved Search
Scenario User needs to remove the Item Group’s “parent” line from a Transaction Saved Search. This is related to an Item Group, with the “REFERENCE START/END LINES ON PICKING TICKETS” checkbox is marked for that item. For example: Item Group 1 Member Item A Member Item B End of Group The requirement is to remove “Item Group 1”… Continue reading Remove Item Group “parent” line from a Transaction Saved Search
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