Author: Vachas Varghese

SuiteScript Function to Convert NetSuite Invoice Records into CSV Format for R365 ERP

The SuiteScript function toCSV(invoiceId) generates a CSV file containing specific invoice data for a given invoice ID. It uses the search.create method to retrieve relevant transaction lines while filtering out any unnecessary data. function toCSV(invoiceId) {     try {         let filters = [             [“internalid”,… Continue reading SuiteScript Function to Convert NetSuite Invoice Records into CSV Format for R365 ERP

Using render.mergeEmail() to Merge Email Templates with Records in NetSuite

In NetSuite, the render.mergeEmail() function is a powerful tool that allows users to merge an existing email template with various record details. This enables dynamic email generation based on transaction, entity, or other record data. Here’s how it works: render.mergeEmail({ templateId: number, entity: RecordRef, recipient: RecordRef, customRecord: RecordRef, supportCaseId: number, transactionId: number }) templateId (Required):… Continue reading Using render.mergeEmail() to Merge Email Templates with Records in NetSuite

Prevent Redirecting to Another Page After Saving Record Using SuiteScript

NetSuite’s default functionality may redirect the page to another, such as automatically redirecting to the Sales Order after saving a Dropship or Special Purchase Order. To stay on the same record without redirection, a User Event Script can be used. const afterSubmit = (scriptContext) => {             redirect.toRecord({    … Continue reading Prevent Redirecting to Another Page After Saving Record Using SuiteScript

Calculate IGST, or SGST and CGST in advanced PDF template

If the tax type is IGST, we should display the IGST. If the tax type is not IGST, both SGST and CGST should be displayed. You can use the provided sample code to display either IGST or both CGST and SGST along with their respective values. <#– Find matching tax details –>     <#list… Continue reading Calculate IGST, or SGST and CGST in advanced PDF template

Substring till a blank space in advanced HTML/PDF template

If the field value we receive is “998529 Other security services nowhere else classified,” but we only want the first token up to the space (998529 ), we can use Advanced Printing’s built-in “substring” and “index_of” functions. Sample code: <#if item.custcol_in_hsn_code?has_content>       <#assign hsn_code = item.custcol_in_hsn_code?substring(0, item.custcol_in_hsn_code?index_of(” “))>     <#else>    … Continue reading Substring till a blank space in advanced HTML/PDF template

How to Display a Custom List of Items in Transactions

To display a custom list (such as an item search result) in the items sublist of a transaction record, you can achieve this by linking the saved search to the item filter field in a custom transaction form. Default Item List: Create and save an item search. Add the saved search to the item filter… Continue reading How to Display a Custom List of Items in Transactions

The requested resource was not found error while trying to use a NetSuite Link externally

If we use url.resolveRecord(options) to generate a record URL and attempt to access it externally, such as from an email, we may encounter an error like: 404 Not Found The requested resource was not found. This occurs because the generated URL does not include the domain. To avoid this, we should create the record URL using the… Continue reading The requested resource was not found error while trying to use a NetSuite Link externally

Modify the line level values of a WBS record

The Work Breakdown Structure (WBS) record stores cost and revenue data for each line in an array of objects format when the timeline type is set to “Monthly.” Example of the serializedamounts field: serializedamounts:”[{“key”:307,”lineKey”:5,”type”:”Cost”,”eac”:null,”date”:”2024-10-01″},{“key”:308,”lineKey”:5,”type”:”Revenue”,”eac”:null,”date”:”2024-10-01″},{“key”:309,”lineKey”:5,”type”:”Cost”,”eac”:null,”date”:”2024-11-01″},{“key”:310,”lineKey”:5,”type”:”Revenue”,”eac”:null,”date”:”2024-11-01″},{“key”:311,”lineKey”:5,”type”:”Cost”,”eac”:null,”date”:”2024-12-01″},{“key”:312,”lineKey”:5,”type”:”Revenue”,”eac”:null,”date”:”2024-12-01″}]” To modify a specific Cost or Revenue value in the WBS record, we must: Retrieve the existing values for the serializedamounts… Continue reading Modify the line level values of a WBS record

SSS_METHOD_NOT_IMPLEMENTED

The SSS_METHOD_NOT_IMPLEMENTED error in NetSuite occurs when a required method in a custom plug-in type isn’t implemented or is incorrectly defined. This error often arises when NetSuite attempts to call a missing method or is incorrectly set up in the plug-in implementation. How to resolve: Verify Method Implementation: Ensure the required method is implemented in… Continue reading SSS_METHOD_NOT_IMPLEMENTED