Add a custom transaction body field of type Inline HTML.For that go to Customization > Lists, Record, & fields > Transaction Body FieldsAdd Label, select type as Inline HTML.Under ‘Applies To’ subtab check Item ReceiptUnder Validation and Defaulting subtab, add the below code in DEFAULT VALUE Here ‘custbody17’ holds the total amount which is to… Continue reading Add Summary Box for displaying Total Amount in Item Receipt
Author: Meghana Satheesh
Data manipulation in records using beforeLoad(context) of User Event Script
Data can be manipulated for records created in beforeLoad user events.That is for example we can set the value of any field in ‘create’ mode of beforeLoad(context) of User Event Script.Data cannot be manipulated for records that are loaded in beforeLoad scripts.If you attempt to update a record loaded in beforeLoad, the logic is ignored.That… Continue reading Data manipulation in records using beforeLoad(context) of User Event Script
Connecting ODBC with NetSuite
Connecting ODBC with NetSuiteGo to Setup> Company> Enable FeaturesUnder Analytics Subtab check Suite Analytics Connect module (Paid Feature)Go to Home in NetSuite: Scroll down to view the Settings portlet.Click Set Up Suite Analytics ConnectDownload the driver bundle based on the system: 32 bit or 64 bit.After downloading, install the bundle by clicking extract all.Once installed,… Continue reading Connecting ODBC with NetSuite
Append an existing PDF to a PDF template.
To add a static PDF page into a PDF template. This can be achieved by <pdfset> tag. Add required file into file cabinet.Navigate to Documents> Files> File CabinetOpen the folder “Templates”.Then open the folder “PDF Templates”.Click on the button “Add File” on the top left corner.Select the particular file and click open.Now the file is… Continue reading Append an existing PDF to a PDF template.
How to remove standard message when a document is about to unloaded?
The onbeforeunload event occurs when a document is about to be unloaded. This event allows you to display a message in a confirmation dialog box to inform the user whether he/she wants to stay or leave the current page. The default message that appears in the confirmation box, is different in different browsers. However, the… Continue reading How to remove standard message when a document is about to unloaded?
Setting group item to item sublist in any record using script.
Example situation: User wants to set item sublist of estimate page by importing item lines from different sales orders. So create a button in estimate page, “Import from sales orders”. By clicking that button will open a suitelet page.In the suitelet page the user can select multiple sales order numbers. Then click on submit button… Continue reading Setting group item to item sublist in any record using script.
Add new line at the end of a sublist.
First load the record in dynamic mode.To select the new line at the end of a sublist in any record we can use,record.selectNewLine(options).After selecting the new line in sublist, set the sublist value using,objRecord.setCurrentSublistValue(options).Then to commits the currently selected line on the sublist use,objRecord.commitLine(options)Finally save the record. Example code of estimate record is added below.
How to get related fields of another record while creating a transaction saved search?
For an example, while creating an invoice search the required columns includes some fields incustomer record. The code shows, how to join customer record fields to invoice search.
Things that help in Advanced pdf or html templates creation.
It is Nonbreaking space.It’s used to create a space that will not break into a new line by word wrap.Provide space as same as a regular space. Output will be like: Text Text If the table has 3 column we can write the code like this. This will provide a blank row inside a table.By… Continue reading Things that help in Advanced pdf or html templates creation.