While using Save Search, we generally use Criteria to filter our search. But if we want to see only selected records where you can’t do this using criteria, like say I wanna see the List of Customer Name and the Internal Id of the latest Sales Order record created by the corresponding Customer. Lets say […]

In this tip i am going to create a button on a record. Clicking the button retrieves the necessary data from the current record and creates a PDF file. The created PDF will then be shown in a seperate window by using a Suitelet. 1.   Create a suitelet with the following code to generate a pdf […]

To Create a folder and file in Netsuite’s file cabinet using suitescript. In this tip i am going to show how to create a folder and file inside Netsuite’s file cabinet. Nomally we can create a folder and upload files inside the same using Netsuite’s UI. But to do this in suitescript, we have to […]

Generally, when we create a suitelet page, we add the script(a suitelet script which is going to be called from another suitelet) to the button of another suitelet page, by which clicking that button from the first suitelet, we can redirect to another suitelet page. But that will be possible, if either we don’t need […]

Some APIs & methods(of Netsuite) and its use in Netsuite Suite Script There are some APIs and Methods in Netsuite Suite Script that we all Netsuite Developer may know , but we may not know where they can be used and where they can’t . Here are some APIs and methods with their usability which […]

How to create a simple form for a new customer in NetSuite account (using Suitelet script) and then redirect to the newly created customer record? I want to create a suitelet form for a new customer record in Netsuite account using some common APIs. And, after creating the record form will be redirected to that […]

I want to add a new tab in a ‘case record’ of a Netsuite account using user-event script. And, there a link is given. After clicking that link, it will  be moved to another form,which will be created by Suitelet script. And,a sublist will be added in that tab. There is 3 different types in […]

First, I will add a button in ‘BeforeLoad’ event of ‘user-event script’.  Here, nlapiResolveURL(type, identifier, id, displayMode) API is used to create a URL on-the-fly by passing URL parameters from within SuiteScript.  nlobjForm.addButton(name, label, script) is used to create a button. nlapiLogExecution(type, title, details) logs an entry in the  script Execution Log subtab, which appears on the Script Deployment page. […]

REQUIREMENT:- Here is a scenario in which you have a Suitelet form (lets say the parent form) and it has a feature in it, to open a pop-up window displaying another Suitelet form (lets say the child form). And you have a necessity of passing some data from this child Suitlet to the parent Suitelet […]

I am trying to present two tips in this single tip as both needs the same concept. 1.How to show alert message for a suitelet page after clicking an Submit button 2.How to show an alert message if a suitelet page with sublist containing checkbox as one of the field in sublist The below content […]

Hello SuiteScript coders! Here we are, with a small plugin, which will help you save some of your valuable coding time in finding out and writting the SuiteScript APIs while, creating scripts using Visual Studio or similar Javascript editors like Aptana/NetBeans. Lets find out how.. >> First of all “click here” to download the JS […]

  Let say, there is a script(SetValueAtSaveRecord.js) deployed for all records present in netsuite. But, there is a function(SetLocation() ) in that script which should be applied for a particular record(like transaction record). How to do this?   First, we should check the common word comes in the url of that particular record loading page. […]

Sometimes we have created a custom checkbox field and checked the “Default Checked” field in the custom field page and applied in the desired record, so that the field will be checked by default when a new record will be opened. But the checkbox is not checked. Have you faced such situation? If yes, here […]

In NetSuite, assistants contain a series of steps that users must complete to accomplish a larger task. With some assistants, users must complete the steps sequentially. In others, steps are non-sequential, and they do not all have to be completed. In these assistants, steps are provided only as guidelines for actions users might want to […]

In this tip, I have focused on troubleshooting some of the common Netsuite Odbc connector issues. I was trying to connect Excel sheet via NS Odbc connector, using my NS SDN account and some other production account also but, I went through a handful of issues before making it work perfect, however. In NS help […]

Situation: While working in Netsuite, we always have to write same functions for multiple scripts. Solution: We can create a commom script file and use in all required scripts. Here is how: 1.Utility.js Create a common script file say Utility.js which will include all your reusable functions. Then in Nesuite account, create a client script […]

I was trying to find out the internal id of the item sublist in Site Category screen. But wasn’t able to find any solution from the NS help center. After a little bit of research, found “presentationitem” will be the sublist internal id instead of “item”. And also for the item column. Code:- var loadCategory […]

In NetSuite you can generate the pdf, along with that you can also add form elements in your document like text box, drop-down list, and radio buttons to make your pdf more interactive. Also you can run JavaScript’s on your generated pdf. Here in this tip you would come to know how to run it. […]

In order to create or update a custom record through SuiteTalk, we need to first create an object of the ‘CustomRecord’ class and assign the internal id of the record type, we are going to work on, to it. CustomRecord customRecord = new CustomRecord(); Now we assign the internal id of the custom record to […]

In this tip, we will see ‘how to set different columns of a table in a particular order’. In my project, there was a requirement like: Suppose, there is a suitelet script ‘CreatePriceListPdf.js’ to create a pdf file. In the pdf file, data is being displayed with different 4 columns (‘Item #’,’Item Name’,’Tax Schedule’,’Base Price’). […]

While creating a custom record we may be required to check if the newly created record overlaps the time period with any existing custom record of same type. In Custom record we have 2 fields called “Start Date” and “End Date” which specifies the time period.   So on save record, we need to check these […]

In ‘Sales Order’ record, Total is calculated by adding Subtotal and Shipping Cost (as shown in the picture below): But, in our project, there was a requirement that Total should be the same as Subtotal. So, we need to set the Shipping Cost zero. In this tip, we will see how to set the Shipping Cost. […]

In new release, Netsuite allows to use Filter Expression for advance search. Earlier we had to use nlobjSearchFilter API to filter a search which makes filtering records as per our requirements much easier. To start we have to check the Use Expressions checkbox to set advance criteria a feature previously not available in suitescript. Now we can […]

REQUIREMENT Suppose there is a Transaction Column Field with the following details:- Lable: My Column ID: custcol_my_column Type: List/Record Applied To: Sales Item Display Type: Disabled And only for few of the Sales Order records we need to set the display type of this column as ‘normal’. SOLUTION– Create a “Before Load” User Event script. […]

While showing any PDF report or any HTML form in netsuite, we need css style in our code. There we generally add css style in the same .js file.   After doing some research, I found that we can also use a .css file which contains all the styles and attach that .css file to […]

Here I am explaining how can we add a file (like XML, JAVASCRIPT, PDF,IMAGE etc.) to a specific folder in the filecabinet through suitetalk webservice . 1)First we need to browse the file using asp:FileUpload control. Here is the code :- <div> <asp:FileUpload ID=”fileupload” runat=”server” /> <asp:Button ID=”btnUpload” runat=”server” Text=”UPLoad” onclick=”btnUpload_Click” /> </div> 2)Then in […]

We can use the ‘nlapiCreateRecord’ Netsuite API to create any new Netsuite record via SuiteScript. This API seems very easy to use and understand for a Netsuite developer. But for some records we need to figure out why this API is not working or why is it throwing some error like ‘USER_ERROR’. While creating a […]

In this tip I’m going to share two things, one is how to add your favorite Google products to your website and also how to use Netsuite portlet to add such features on your Netsuite dashboard. Google Web Elements:- This is a feature provided by Google to embed most of its products onto your website. […]

As per my finding, Netsuite till now hasn’t provided any straight forward way (API) to implement jQuery in SuiteScripts. So, you need to follow a deceitful way to get the jQuery stuffs done in your Netsuite screen. In this Tip I’m going to show how to use a ‘jAlert’ in Netsuite screen, lets see how […]

This tip demonstrates how to call a web service (internal/external) from a SuiteScript.You might have come across the ‘nlapiRequestURL‘ API, which is usually used for calling the Netsuite’s SuiteTalk web service from the SuiteScript itself. But this API can also be used for calling the web services which are not hosted in Netsuite or the externally […]

Add a Field Change event for Suitelet Form in Netsuite Field Change Event for a Suitelet Page:   Let’s we have a suitelet script where we have added two text boxes Roll No. andName. Now we want when we enter a Roll No., we want to populate its corresponding name in the Name text box. […]