-
SuiteTip: Discover the Key to Advanced Data Analysis with SQL Functions
Welcome back to SuiteTip, where we empower you to master NetSuite's capabilities! In this installment, we emphasize the importance of understanding SQL Functions, which can be seen as the 'Excel Formulas' of your NetSuite database. Why Learn SQL Functions? Some users, especially those who are new users of NetSuite, often…
-
NSC | Show More Rows in NetSuite Saved Searches
Users can control how many records appear at once in NetSuite list views and saved searches, making it easier to browse and locate data without constantly moving between pages. By default, NetSuite often displays only 50 records at a time, but this limit can be increased through personal preferences. Adjusting the number…
-
Saved Search Formula Tip: Create Button-Style Links in Saved Searches
In this article, we will discuss how to create button-style links in NetSuite Saved Searches using Formula (HTML) fields. This technique helps make Saved Searches more interactive and easier to use by turning plain text links into visually styled action buttons. Solution: Using Formula (HTML) Field By combining HTML links…
-
Saved Search Formula Tip: Create Clickable Email Links with mailto:
In this article, we will discuss how to create clickable email links in NetSuite Saved Searches using the mailto: hyperlinks. This technique allows users to launch their default email application directly from a Saved Search result, making it easier to contact customers, vendors, employees, or leads without copying email…
-
Saved Search Formula Tip: Create Clickable Phone Number Links with tel:
In this article, we will discuss how to create clickable phone number links in NetSuite Saved Searches using the tel: hyperlinks. This tip is especially useful for support teams, sales representatives, and customer service users who frequently call customers directly from search results. Solution: Using Formula (HTML)…
-
SuiteTip: Use Main Line Correctly in Transaction Searches
Welcome back to another SuiteTip! If you’ve ever created a transaction saved search and noticed duplicate rows, missing transactions, or unexpected totals, there’s a good chance the issue is related to the Main Line filter. Understanding how the Main Line field works is one of the most important skills for building…
-
Saved Search Formula Tip: Show a Progress Bar Using Formula (HTML)
When reviewing saved search results, numeric percentages can be difficult to interpret quickly. A simple progress bar built using a Formula (HTML) field can significantly improve readability by adding a visual indicator directly in the results. This technique is especially useful for tracking metrics like completion rates,…
-
Saved Search Formula Tip: Open Hyperlinks in a New Tab Using target="_blank"
Saved Searches in NetSuite are powerful for surfacing actionable data, and one common thing users do is adding clickable hyperlinks directly in results. By default, these links open in the same tab, which can disrupt user's work and momentum. Yes, users can middle-click or right-click and choose “open in a new tab”, but…
-
How to View Creation Details for Withholding Tax Types Using Saved Search
When opening a Withholding Tax Type record, you may notice that there is no System Notes tab available to show when the record was created or who created it. This can make it difficult to track record history directly from the form. As a workaround, you can create a Saved Search to retrieve these details. The steps below…
-
SQL Essentials: Why RANK and DENSE_RANK Can't Be Used in Saved Search Criteria
RANK() and DENSE_RANK() are SQL window functions used to assign rankings to records within a dataset. While these functions are powerful for ordering data, they have specific limitations when used in NetSuite's Saved Searches. Understanding the Limitation NetSuite currently restricts the use of window functions like RANK()…
-
SQL Essentials: RANK vs. DENSE_RANK
Both the RANK and DENSE_RANK functions are utilized to assign ranks to rows within a result set based on specified ordering criteria. While they serve similar purposes, they handle ties differently, leading to variations in the ranking sequence. Let's explore the distinctions between these two functions: RANK Function:…
-
SQL Essentials: KEEP Function Explained
Overview The KEEP() function in SQL is used in conjunction with aggregate functions to return specific values from a group of rows based on a defined ordering. In simpler terms, it allows you to extract a particular value (such as the first or last entry) within a grouped dataset, according to a specified sort order. This…
-
SQL Essentials: DENSE_RANK Function Explained
Overview The DENSE_RANK function assigns a unique rank to each row within a partition of a result set, based on the values in specified columns. Unlike the RANK function, DENSE_RANK does not leave gaps between rank values when there are ties; consecutive ranks are assigned without skipping any numbers. In simpler terms,…
-
SQL Essentials: RANK Function Explained
Overview The RANK function is an analytic SQL function that assigns a unique rank to each row within a partition of a result set, based on the order specified in the ORDER BY clause. Rows with equal values receive the same rank, and the next rank is skipped accordingly. In simpler terms, the RANK function helps you order…
-
SQL Essentials: TRUNC(DATE) vs. TO_DATE
In NetSuite's Saved Searches, effective date manipulation is crucial for accurate reporting and analysis. Two essential functions that assist in this process are TRUNC(DATE) and TO_DATE. While both deal with date values, they serve different purposes and are used in distinct scenarios. TRUNC(DATE) Function: Definition: The…
-
SQL Essentials: TRUNC(NUMBER) vs. TRUNC(DATE)
In NetSuite's Saved Searches, the TRUNC function is a versatile tool that can be applied to both numerical and date values, allowing users to truncate numbers to a specified decimal precision or dates to a specific component. Understanding how to use TRUNC effectively can enhance data analysis and reporting accuracy. TRUNC…
-
SQL Essentials: TRUNC(NUMBER) vs. ROUND
In NetSuite's Saved Searches, understanding how to manipulate numerical data is crucial for accurate reporting and analysis. Two essential functions for this purpose are TRUNC(NUMBER) and ROUND. While both deal with adjusting numerical values, they serve different purposes and yield distinct results. TRUNC(NUMBER)…
-
SQL Essentials: TRUNC(NUMBER) Function Explained
Overview The TRUNC(NUMBER) function in Saved Search Formula is used to truncate a number to a specified number of decimal places, effectively removing the fractional part without rounding. In simpler terms, it allows you to shorten a number by cutting off digits after a certain decimal point, which is particularly useful…
-
SQL Essentials: TRUNC(DATE) Function Explained
Overview The TRUNC(DATE) function in Saved Search Formula is used to truncate a date to a specified unit, effectively setting all smaller units to their default values. In simpler terms, it allows you to round down a date to the beginning of a specific time period, such as the start of a month or year. This is particularly…
-
SQL Essentials: NEXT_DAY Function Explained
Overview The NEXT_DAY function returns the date of the first specified day of the week that occurs after a given date. In simpler terms, it helps you find the next occurrence of a particular day of the week following a specific date. For example, if today is Monday and you want to find the date of the next Friday, the…
-
SQL Essentials: MONTHS_BETWEEN Function Explained
Overview The MONTHS_BETWEEN function calculates the number of months between two dates, returning a decimal value that represents the full months and fractional months between them. In simpler terms, it helps you determine the exact number of months (including partial months) separating two dates, which is particularly…
-
SQL Essentials: LAST_DAY Function Explained
Overview The LAST_DAY function in SQL returns the date of the last day of the month for a given date. In simpler terms, when you provide a specific date, LAST_DAY will tell you the date of the month's final day. This is particularly useful in NetSuite when you need to determine month-end dates for reporting or scheduling…
-
SQL Essentials: ADD_MONTHS Function Explained
Overview The ADD_MONTHS function is a date manipulation function that returns a date value after adding a specified number of months to a given date. In simpler terms, it allows you to move forward or backward in time by a set number of months from a specific date. For example, if you have a project start date and want to…
-
SQL Essentials: Regular Expressions Explained
Overview Regular Expressions, often abbreviated as Regex, is a powerful tool in Saved Search Formulas that allows you to search and manipulate text using pattern matching. It provides a flexible way to find, replace, or extract specific text patterns within your data. In simple terms, it's like a search-and-replace…
-
SQL Essentials: REGEXP_REPLACE Function Explained
Overview REGEXP_REPLACE is a function in Saved Search Formulas that enables users to manipulate text using regular expressions, offering a powerful tool for data transformation and extraction. The function's basic purpose is to search and replace text within a string based on a specified pattern. However, the real…
-
SQL Essentials: REGEXP_INSTR Function Explained
Overview REGEXP_INSTR is a text-searching function in Saved Search Formulas that uses regular expressions to find the position of a substring within a text field. It returns the starting position of the first occurrence of the specified pattern in the text. This function is particularly useful when you need to locate…
-
SQL Essentials: REGEXP_SUBSTR Function Explained
Overview REGEXP_SUBSTR is a string function that allows you to extract substrings from a text field based on a regular expression pattern. Regular expressions, often abbreviated as regex, are a sequence of characters that define a search pattern. This function is particularly useful when you need to search for specific…
-
SQL Essentials: TO_CHAR vs TO_DATE
Overview In NetSuite Saved Search Formula, the TO_CHAR and TO_DATE functions are essential tools for manipulating and converting data types, especially when dealing with dates and strings. Let's explore each function and understand their unique purposes. TO_CHAR Function: Definition: TO_CHAR converts a date or number to a…
-
SQL Essentials: TO_DATE Function Explained
Overview TO_DATE is an SQL function that converts a date represented as a string or a number into a date data type. In simpler terms, it transforms date information from one format to another, making it consistent and easier to work with in your NetSuite data. For instance, you might have dates stored as text, like…
-
SQL Essentials: TO_CHAR Function Explained
Overview TO_CHAR is an SQL function that converts a date, time, or numeric value into a formatted string. It allows you to customize the display of these data types according to your preferences or specific requirements. In simpler terms, TO_CHAR helps you transform numbers and dates into text formats that are more…