• : 1-877-596-8218
  • : sales@aecc.ca
# # #
#

Tag: SavedSearches

Overcome saved search each() function limitation

How to overcome the each() function only loops over the first 4000 results for the saved search results in SuiteScript 2.0 Background: It’s quite common to use the search API in the suiteScript to get data from NetSuite database. We can create a search or load the saved search which is predefined in NetSuite. And … Continue reading “Overcome saved search each() function limitation”

Source Custom Field from Saved Search.

Saved Search in NetSuite is a powerful tool. One can create a custom field and use a Saved Search to auto populate the custom field without the help of scripting. Each time the form contains this custom field is displaying, the saved search will run and populate the field with data from saved search. Today … Continue reading “Source Custom Field from Saved Search.”

How to Create a Sublist on a Custom Record.

The Sublists display relevant data as the list view on the record.If you are working with NetSuite, you must quite familiar with this.For example, on the Sales Order Record, the Item Sublist lists all the items on this Sales Order to be sold to the customer, and on Invoice Record, the Accounting Books Sublist contains … Continue reading “How to Create a Sublist on a Custom Record.”

Advanced Search Using Expressions in SuiteScript.

Saved Search in NetSuite is a powerful feature. In the UI, one can build a saved search using expressions. To do this, check the “USE EXPRESSIONS” box. In the picture, the searching criteria is “Account is A/D Furniture&Fixtures” OR “ Amount is less than 1”. In SuiteScript, we can build the same search that using … Continue reading “Advanced Search Using Expressions in SuiteScript.”