Author: Anjo Joseph

Initiate a Workflow from script

Initiates a workflow on-demand. This method is the programmatic equivalent of the “Initiate a workflow action” action in SuiteFlow. Returns the internal ID of the workflow instance used to track the workflow against the record. var workflowInstanceId = workflow.initiate({ recordType: ‘customer’, recordId: 24, workflowId: ‘customworkflow_myWorkFlow’ });

Trigger a workflow state on button click in the suitelet page

The following scripts can be used to trigger a workflow state in a record by clicking the button in a suitelet page: Parent Suitelet: /**  * @NApiVersion 2.1  * @NScriptType Suitelet  */ define([‘N/ui/serverWidget’, ‘N/url’, ‘N/runtime’], function(serverWidget, url, runtime) {     function onRequest(context) {         if (context.request.method === ‘GET’) {    … Continue reading Trigger a workflow state on button click in the suitelet page

Executing SuiteQL Queries Through REST Web Services

SuiteQL is a query language based on the SQL database query language. SuiteQL provides advanced dynamic query capabilities that can be used to access NetSuite records. You can execute SuiteQL queries through REST web services by sending a POST request to the suiteql resource, and specifying the query in the request body after the body parameter q. In… Continue reading Executing SuiteQL Queries Through REST Web Services

Record Filtering and Query

The query operation is used to execute a query on a specific record type based on a set of criteria. Record query only returns record IDs and HATEOAS links. That is, query results have a form of non-expanded references. Additionally, you can only use body fields in query conditions. Saved queries, multilevel joins, and sublist… Continue reading Record Filtering and Query

PROPOSAL FOR INVENTORY BALANCE AND TRANSACTION PAGE

Proposal Summary This proposal outlines the scope of the custom page for the inventory balance and transaction details on the NetSuite account at Nationwide Pharmaceutical (hereafter referred as the client) by Jobin&Jismi (hereafter referred to as Implementer).   This proposal covers the development of a custom Suitelet page in NetSuite to enhance inventory and transaction reporting.… Continue reading PROPOSAL FOR INVENTORY BALANCE AND TRANSACTION PAGE

Proposal for Installer Scheduler in NetSuite with Dispatch Track Integration

Proposal Summary This proposal outlines the scope of setting up the Installer scheduler on the NetSuite account and the order integration with the Dispatch Track system at Famous Tate (hereafter referred as client) by Jobin&Jismi (hereafter referred as Implementer).   This proposal covers the customization to add an Installer Scheduler page accessible from the Sales… Continue reading Proposal for Installer Scheduler in NetSuite with Dispatch Track Integration

Create a Query for Transaction Records and Run It as a Paged Query

The following sample creates a query for transaction records, joins the query with another query type, and runs the query as a paged query. /**  * @NApiVersion 2.1  */ require([‘N/query’], query => {   // Create a query definition for transaction records   let myTransactionQuery = query.create({     type: query.Type.TRANSACTION   });   // Join the original query definition based… Continue reading Create a Query for Transaction Records and Run It as a Paged Query

Create a Query for Customer Records and Run It as a Non-Paged Query

The following sample creates a query for customer records, joins the query with two other query types, and runs the query. /**  * @NApiVersion 2.1  */ require([‘N/query’], query => {   // Create a query definition for customer records   let myCustomerQuery = query.create({     type: query.Type.CUSTOMER   });   // Join the original query definition based on the salesrep… Continue reading Create a Query for Customer Records and Run It as a Non-Paged Query

Convert a Query to SuiteQL and Run It

The following sample creates a query for customer records, converts it to its SuiteQL representation, and runs it. /**  * @NApiVersion 2.x  */ require([‘N/query’], function(query) {   var myCustomerQuery = query.create({     type: query.Type.CUSTOMER   });   myCustomerQuery.columns = [     myCustomerQuery.createColumn({       fieldId: ‘entityid’     }),     myCustomerQuery.createColumn({       fieldId: ’email’     })   ];   myCustomerQuery.condition = myCustomerQuery.createCondition({     fieldId: ‘isperson’,     operator: query.Operator.IS,     values: [true]   });… Continue reading Convert a Query to SuiteQL and Run It