Author: Hannath Abdul

Add a field to a form using a script

function empLocationSearch(currentEmpID) { try { var employeeSearchObj = search.create({ type: “employee”, filters: [ [“internalid”, “anyof”, currentEmpID], “AND”, // [“location”,”anyof”,”29″] [“isinactive”, “is”, “F”], ], columns: [ search.createColumn({ name: “internalid”, label: “Internal ID” }), search.createColumn({ name: “location”, label: “Location” }) ] }); var searchResultCount = employeeSearchObj.runPaged().count; log.debug(“searchResultCount”, searchResultCount) let location if (searchResultCount > 0) { employeeSearchObj.run().each(function (result)… Continue reading Add a field to a form using a script

Compare Date in Suitescript

try {         let empLocation = currentRec.getValue({           fieldId: ‘custpage_saleslocation_field’         })         let trandate = currentRec.getValue({ fieldId: ‘trandate’ });                 let trandateStr = format.format({         value: trandate,         type: format.Type.DATE         });         let trandateParsed = new Date(trandateStr);                                                    let compareDate = new Date(‘2024-07-02’);               console.log(‘trandate’,trandate);         console.log(‘trandateParsed’, trandateParsed);                  console.log(‘compareDate’, compareDate);         console.log(’empLocation’, empLocation);         if(trandateParsed > compareDate… Continue reading Compare Date in Suitescript

Duplicate Record Detection

The Duplicate Detection & Merge feature helps you find duplicate records in your NetSuite account and use the information in them to create a single record. An administrator can turn on the Duplicate Detection & Merge feature at Setup > Company > Enable Features (Administrator) on the Company subtab in the Data Management section. The administrator configures… Continue reading Duplicate Record Detection

Create a case status

Go to Setup > Support > Case Statuses. In the Case Status field, enter a name for the new status. This name appears in the Status field on case records. In the Insert Before field, select where you would like this status listed in the Status field on case records. For example, you may want to arrange statuses in order of how cases are… Continue reading Create a case status

How to get a unique values from a search without using mainline in a transaction

function getItemFulfillments(salesOrderId, itemIds) {       let itemfulfillmentSearchObj = search.create({         type: “itemfulfillment”,         settings:[{“name”:“consolidationtype”,“value”:“ACCTTYPE”}],         filters:         [           [“type”,“anyof”,“ItemShip”],           “AND”,           [“createdfrom”,“anyof”,salesOrderId],           “AND”,           [“item”,“anyof”,itemIds]         ],         columns:         [           search.createColumn({            name: “internalid”,            summary: “GROUP”,            label: “Internal ID”           })         ]        });        let searchResultCount = itemfulfillmentSearchObj.runPaged().count;        log.debug(“result count”, searchResultCount);        let ifArray = [];        if (searchResultCount > 0) {         itemfulfillmentSearchObj.run().each(function (result) {            ifArray.push( result.getValue({ name: “internalid”,             summary:… Continue reading How to get a unique values from a search without using mainline in a transaction

How to create invoice for the shipped quantity of the items in the sales order.

define([‘N/search’, ‘N/record’], function(search, record) {     function getInputData() {         return search.create({             type: “itemfulfillment”,             filters: [                 [“type”, “anyof”, “ItemShip”],                 “AND”,      … Continue reading How to create invoice for the shipped quantity of the items in the sales order.

Helpdesk Field Help

Check this box if this case is internal and is being submitted by or for an employee. Help desk cases are not included in Customer Service reports.