Author: Anjo Joseph

NetSuite – Numerik Integration

Steps to do integration between NetSuite and Numerik: Create Integration Record in NetSuite Generate certificates using command: openssl req -new -x509 -newkey rsa:4096 -keyout private.pem -sigopt rsa_padding_mode:pss -sha256 -sigopt rsa_pss_saltlen:64 -out public.pem -nodes -days 730   Create OAUTH 2.0 CLIENT (M2M) in Netsuite  and copy certificate ID Under Embedded Integrations, create new Integration App in Numerik In… Continue reading NetSuite – Numerik Integration

Item Fulfillment > Mark as Shipped > Unexpected Error

Unexpected error is throwing when User clicks the mark as Shipped in the Item fulfillment. The error is typically caused by an invalid email address in the “To Be E-mailed” field on the associated sales order. An invalid email address may include: Incomplete formats, such as missing domain extensions (e.g., “support@netsuite instead of “support@netsuite.com”). Extra… Continue reading Item Fulfillment > Mark as Shipped > Unexpected Error

Function to create deployment and execute the script through script.

  The following functions can be used to create a new script deployment and execute the script.   /**      * A function that create Deployment and execute the script.      *      * @return {String} The Task ID from NetSuite.      */     function createAndExecuteDeployment(options)     {  … Continue reading Function to create deployment and execute the script through script.

Translate text using N/machineTranslation Module

Use the N/machineTranslation module to translate text into supported languages using generative AI. This module uses the Oracle Cloud Infrastructure (OCI) Language service to translate text in documents you provide. You can also use the N/llm Module to translate text by providing a suitable prompt when calling generative AI methods (such as llm.generateText(options)). However, using the N/machineTranslation module… Continue reading Translate text using N/machineTranslation Module

Handling Timezone Conversion When Setting Date Fields in NetSuite via Map/Reduce Scripts

Purpose This article explains how to handle timezone discrepancies when setting date fields in NetSuite via a Map/Reduce script, especially when using ISO 8601 UTC date strings from external systems. This ensures the correct calendar date appears in the NetSuite UI, regardless of the account’s timezone configuration. Problem Overview External systems often send date values… Continue reading Handling Timezone Conversion When Setting Date Fields in NetSuite via Map/Reduce Scripts

Excluding Kit Components in Sales Order Item Queries

To retrieve transaction details, including item and quantity information from the transaction line, we can use query on the transaction line table. By default, this query will include both standalone items and components of Kit Items. To exclude Kit Item components and return only the items listed on the sales order, include the following condition… Continue reading Excluding Kit Components in Sales Order Item Queries

APIs for NetSuite Clutch Integration

Here are the APIs available for updating customer reward points in Clutch: To add reward points to customer: curl –location ‘https://{endpoint}/merchant/updateBalance’ –header ‘authorization: Basic {Authorization code}’ –header ‘brand: SME8953’ –header ‘location: SMEECOMM’ –header ‘terminal: SMEECOMMWS’ –data ‘{ “cardNumber”: “1234593316630193”, “action”: “issue”, “amount”: { “amount”: “882”, “balanceType”: “Points” } }’ To redeem reward points to customer:… Continue reading APIs for NetSuite Clutch Integration

API to fetch the Quote from the Nutanix

curl –location ‘https://{domain}/frontline/v1/distributor/quotes?quoteNumbers=XQ-182951′ –header ‘x-frontline-jwt: {JWT Token}’ –header ‘Authorization: {JWT Token}’ Select the following in the Auth in Postman Auth type: JWT Bearer Algorithm: RS256 Private key: upload private key

Displaying Child Record Data on a Parent Custom Record PDF

To display child record information within the printed PDF of a parent custom record, follow this approach using SuiteScript and Advanced PDF/HTML templates: Steps to Implement Deploy a User Event Script on the Parent Custom Record Within the beforeLoad function, ensure the script executes only when the context is CONTEXT.PRINT. Generate a Virtual Sublist with… Continue reading Displaying Child Record Data on a Parent Custom Record PDF