Tag: saved search

List of SQL Functions

NetSuite offers a comprehensive suite of SQL Functions, catering to various data manipulation and analysis needs. Here’s a list of some of the common functions used: Note: The links to the function explanations will be updated as new articles about SQL Functions are posted. Numeric Functions ABS ROUND FLOOR CEIL MOD REMAINDER MOD vs. REMAINDER Character… Continue reading List of SQL Functions

How to retrieve the invoice a customer deposit is applied to via a saved search?

To create a Saved Search that will show Customer Deposits applied to Invoices, follow the steps below: Navigate to Report > Saved Searches > All Saved Searches > New > select Transaction as Search Type Add a Search Title In Criteria tab > Standard subtab, add the following: Type is Deposit Application Main Line is False In Results tab > Columns subtab, add the following: Name Date or Applied To Transaction: Date Applied To Transaction (set Custom Label as Invoice) Created… Continue reading How to retrieve the invoice a customer deposit is applied to via a saved search?

Applying Functions to Search Results Columns

Applying Functions to Search Results Columns For each search results column, you have the option of applying a function to transform its data value into a format most useful for your purposes. To apply a function to a field’s values on the results page: Reference article – NetSuite Applications Suite – Applying Functions to Search… Continue reading Applying Functions to Search Results Columns

Saved search not displayed in the custom field creation page

Scenario: While creating a custom field and trying to set the value of the field through search, the page is not displaying the created search. i.e. A saved earch has been created. But the search is not displaying in the custom field creation page. Solution: Confirm that the search fulfills the following: Apply a valid… Continue reading Saved search not displayed in the custom field creation page

Create a Saved Search to Show Changes Made to a Role

Scenario A user wants to create a Saved Search to show the all the changes made to a role. Solution Navigate to Lists > Search > Saved Searches > New Search Type: Click Role Click Criteria Click Standard Filter: Select Custom Custom: Select Yes Click Set 5. Click Results 6.Click Columns Field: Select Name Select Permission Change Select Permission Change Level Select Permission Change Date 7.Click Available Filters Filter: Select Permission Change Date Show in Filter… Continue reading Create a Saved Search to Show Changes Made to a Role

Suitescript code to display search result in debug console

require([‘N/search’], function (search) {     const checkForParameter = (parameter, parameterName) => {         if (parameter !== “” && parameter !== null && parameter !== undefined && parameter !== false && parameter !== “null”             && parameter !== “undefined” && parameter !== ” ” && parameter !==… Continue reading Suitescript code to display search result in debug console

Using NSCONCAT in NetSuite Saved Search Formulas

When building Saved Searches in NetSuite, you may encounter a need to concatenate multiple values into a single field, such as listing item names for a transaction or aggregating emails tied to a contact. That’s where the NSCONCAT function becomes especially useful. What is NSCONCAT? NSCONCAT is a group function available in formula fields when… Continue reading Using NSCONCAT in NetSuite Saved Search Formulas

Create journal saves search with “to subsidiary” field

Unfortunately, the ability to add ‘To Subsidiary’ column in the journal search is logged as an enhancement in the voting stage [#327120]. Also, the ability to add the Due to/From Subsidiary in the Advanced intercompany journal search is also logged as an enhancement [#471651]. For accounts using the feature ‘CENTRALIZED PURCHASING AND BILLING’ in Enable… Continue reading Create journal saves search with “to subsidiary” field

Create a Saved Search to Send Email Alerts to Purchase Order Approver When a New Transaction Is Created

Scenario: Create a saved search to send email alerts to Purchase Approvers every time a new Purchase Order is created by their subordinates. Solution: Navigate to Lists > Search > Saved Searches > New  Click Transaction Search Title: Enter Title Click Criteria tab Click Standard subtab Filters: Select: Type Select: Any of Select: Purchase Order… Continue reading Create a Saved Search to Send Email Alerts to Purchase Order Approver When a New Transaction Is Created