Category: SuiteScript Functions

SuiteScript Functions related articles will be posted in this category

Get NetSuite unexpected error ticket number for unexpected error.

When you get the unexpected error, it will point you to a link to a case form that allows you to report the error. To access this: Right-click on here in the message Click Copy Link Location Paste into Word or Notepad and find the part of the link that shows your ticket ID after &ticket= Your ticket ID… Continue reading Get NetSuite unexpected error ticket number for unexpected error.

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

Getting transactions between two trandate

/** * Fetch transactions created between two dates * @since 2015.2 */function getTransaction () { try { var transactionSearchObj = search.create({ type: “transaction”, filters: [ [“type”, “anyof”, “CustCred”, “CustInvc”], “AND”, [“mainline”, “is”, “F”], “AND”, [“shipping”, “is”, “F”], “AND”, [“cogs”, “is”, “F”] ], columns: [ search.createColumn({ name: “custbody_eb_channel”, summary: “GROUP”, label: “Channel” }), search.createColumn({ name: “formulacurrency”,… Continue reading Getting transactions between two trandate

Function used to sales order search for get the context value

function transactionSearch(orderID){ try{ var transactionSearchObj = search.create( { type: “salesorder”, filters: [ [“type”,”anyof”,”SalesOrd”], “AND”, [“systemnotes.context”,”anyof”,”WST”], “AND”, [“internalid”,”anyof”,orderID], “AND”, [ “mainline”, “is”, “T” ] ], columns: [ search.createColumn({ name: “context”, join: “systemNotes”, label: “Context” }) ] } ); var searchResultCount = transactionSearchObj.runPaged().count; log.debug( “transactionSearchObj result count”, searchResultCount ); transactionSearchObj.run().each( function ( result ) { contextValue =… Continue reading Function used to sales order search for get the context value

Function of replace data in email body

function getHtmlBody(Template,htmlbody, replaceData) { try { let html = htmlbody; if (Template === sevenDaysTemplate) { html = html.replace(‘#close’, replaceData.closingdate); html=html.replace(‘#orders’,replaceData.orders) } else if (Template === fourteenDaysTemplate) { html=html.replace(‘#orders’,replaceData.orders); } else if(Template === fifteenDaysTemplate){ html=html.replace(‘#orders’,replaceData.orders); } return html } catch (e) { log.debug({ title: e.name, details: e }); log.error({ title: e.name, details: e }); }}