In Javascript, the date object does not store any specific timezone value. The time is stored in the value of the local timezone relative to GMT(Greenwich Mean Time). If we print the time object, we can see that the time is represented as a value with a sign and offset from the UTC(Coordinated Universal Time)… Continue reading How to display a date object as a date value in another timezone
Author: Derin Jose
Different Timezone Abbreviations and Time Offset values for Date Object Creation
Following is a list of country codes, their timezone identifiers, the timezone offset in each of these regions with respect to UTC, and the standard Timezone abbreviations for each location. These are very useful when you want to convert the time object value in a specific time zone to a time object value in a… Continue reading Different Timezone Abbreviations and Time Offset values for Date Object Creation
Saved search to select transactions created in the last few seconds/minutes/hours
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
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