We can source the value in the child record to the field in the parent record using search. Whenever the user changes in the body field of a parent record when value changes in the child record using saved search is possible. Without using any script the value in the child record is updated in… Continue reading Source search into the field to get the latest value from the child record.
Author: Sandhra Simon
Custom Child Record Sublists using Script
Whether we can update the custom child record sublist using script in a record?Yes, It’s possible by scripting. The custom record child record will be inline editor sublist that contains a list of records. There was a concern that whether we can add line into the sublist that are custom record list in the item… Continue reading Custom Child Record Sublists using Script
Update Latest Invoice ID in the Item Fulfillment Record
There will be a custom transaction body field in the item fulfillment record with the label “INVOICE ID”, want to update the latest created invoice id in the field. A UserEvent script is created to deploy in the invoice record, On creating the new invoice the script works. In Addition, a field is added in… Continue reading Update Latest Invoice ID in the Item Fulfillment Record
Code 128 Barcode in Advanced PDF Template
We can add barcode type “Code 128” in the Advanced PDF Template. It is the advanced version of code 39, and can include the 128 characters in ASCII. For Example, If we want to add a barcode in the packing slip template in which the Barcode represents a concatenation of the Purchase Order and Delivery… Continue reading Code 128 Barcode in Advanced PDF Template
Mark All button will not work in sublist type “Static List”
In the suitelet page, for the sublist type “STATIC” the mark all button will not work bcoz data on the static sublist is not actually part of a record and therefore not accessible to suit script, is not submitted with the record when the record is saved. For this, you can add one field to… Continue reading Mark All button will not work in sublist type “Static List”
Alternate to the scriptContext.lineNum
There are some cases in which scriptContext.lineNum will be undefined if not a sublist or matrix field. In that case you can use the Record.getCurrentSublistIndex, it returns the line number of the currently selected line. Note that line indexing begins at 0 with SuiteScript 2.0. Example In the client script for field validation, in field… Continue reading Alternate to the scriptContext.lineNum
Convert Date to Specific Format
In netsuite sometimes when we get the value of date will be with weekday+date+timezone. In order to change this value to your corresponding date format. This function may help you to change the date to YYYY-MM-DD format.You can change the format by just changing the string in the datestring varible function generateDateString(dateObj) { //convert date… Continue reading Convert Date to Specific Format
Update Line Field of purchase order on updating the body field
Client would like to implement the following field update in the purchase order record Receive By date field in the purchase order will be update by UI/CSV import/SOAP web services in the Purchase order record There is a line column field “Expected Receipt Date” in the purchase order For every update in the “Receive By… Continue reading Update Line Field of purchase order on updating the body field