NetSuite provides the option to filter out the transactions created by the user in the last few seconds/minutes/hours. We can also use this method to filter out records on ‘date fields’ storing the exact time. Below is an example of a saved search to fetch the sales orders created in the last few minutes: Criteria… Continue reading Saved search to select transactions created in the last few seconds/minutes/hours
Author: Derin Jose
Methods to connect a Saved Search in NetSuite to a Suitescript
We can create a saved search inside the suite script and run it using the ‘N/search’ module functions. But there can be instances where the search result should be fetched byrunning an existing saved search present in the NetSuite account. This is when the user wants to update the saved search conditions over time without… Continue reading Methods to connect a Saved Search in NetSuite to a Suitescript
Sublist item selection method for items rendered in a custom suitelet page
We can select an item from a sublist using the index. If we use the line index we can use the selectLine() function for this.We can also calculate the index value using the line Id. The line id is usually one value greater than the index value. But this can be different if some items… Continue reading Sublist item selection method for items rendered in a custom suitelet page
Uploading files to Azure cloud server via API in JavaScript
We can upload files to the Azure server through API ‘PUT’ request in JavaScript. Follow the steps: Set up a remote server location in Azure Cloud Server. This can be done through the ‘Microsoft Azure Storage Explorer’ application by creating a blob container. Generate the upload link with the authorization parameter for the ‘Blob container’.… Continue reading Uploading files to Azure cloud server via API in JavaScript
Handle commas in a saved search result from the NSCONCAT function
Recently, I had to fetch some URLs and file names stored in a custom record related to another record. The challenge was to handle the commas inserted using the NSCONCAT function.My solution was to use the string.replace() function to replace commas in the file names with ‘%2C’ and URLs before concatenating the search result and… Continue reading Handle commas in a saved search result from the NSCONCAT function
How to create folders in a NetSuite account through SuiteScript
Folders in the file cabinet are helpful to keep files regarding specific customers or transactions in NetSuite. We can create these folders through the suite script as well.Folders in the file cabinet are a type of NetSuite records and can be created using the ‘record.create()’ function like any other records. Use the ‘N/record’ module for… Continue reading How to create folders in a NetSuite account through SuiteScript
How to avoid search result limit exceeding error in NetSuite saved search
NetSuite has a limit of 4000 results at a time for every saved search result execution (run function). If the search result returns more than 4000 results this can lead to a search limit exceeding the error.The error message will be: ‘SSS_SEARCH_FOR_EACH_LIMIT_EXCEEDED’: This error can be avoided by using a paging function for running the… Continue reading How to avoid search result limit exceeding error in NetSuite saved search
How to run an existing NetSuite Integration React WebApp project in a new system
We might need to edit or update an existing NetSuite Integration React WebApp project in a new system. Here are the steps for that: Clone the repository in VS Code. Choose the correct repository branch before cloning. Open the project directory in cmd. Make sure the correct Node Virtual Machine is installed. Use ‘nvm install… Continue reading How to run an existing NetSuite Integration React WebApp project in a new system
How to show saved search results based on a field value inside a custom record
We can show Saved search results in a custom record. Follow these steps: We have to make a saved search with the required criteria. Now go to the subtab: ‘Available filters’ and add a new filter that needs to be used for checking with the value from the custom record field. Enable the ‘Show in… Continue reading How to show saved search results based on a field value inside a custom record
How to implement a script library file in NetSuite
We can store global variables and functions inside a script library file in NetSuite. This helps to easily use a function or variable in multiple script records without defining the same for each record. For example, we can store global variables such as email addresses and commonly used functions inside a library file and access… Continue reading How to implement a script library file in NetSuite