Create a WorkBook database with the necessary fields as per your requirements. There is an Export button that allows you to download it as SuiteQL. Then the file will be downloaded to your system
Author: Nived Krishna
Populate Customer ID from Sales Order to Deposit with Workflow and Go To Record Action
Scenario Populate Customer ID from Sales Order transaction to Deposit with the use of workflow and Go To Record action. Solution Navigate to Customization > Workflow > Workflows > New Basic Information: Name: Enter Name Record Type: Select Transaction Sub Types: Select Sales Order Event Definition: On Create: Enter Checkmark On View or Update: Enter Checkmark Click Save Click State 1 Bottom Right Corner: Click New Action Click Go To Record Parameters: Record Type: Select Customer Deposit Field: Select Customer (Payments… Continue reading Populate Customer ID from Sales Order to Deposit with Workflow and Go To Record Action
Known Excel Limitation for Values with More Than 16 Digits
When opening a CSV file directly, Excel treats long numeric sequences as numbers and displays them using scientific notation. This treatment leads to a loss of precision when the number has more than 16 digits and to loss of information when digits at 16+ position are truncated. Even if apostrophes or double quotes are used… Continue reading Known Excel Limitation for Values with More Than 16 Digits
Using NetSuite Connector for Data Migration
NetSuite Connector is not intended to perform mass data migration but the services provided by NetSuite Connector are used for the incremental syncing of data. The NetSuite Connector order sync process allows up to 30 days of historical order data to be synced. Syncing more than 30 days worth of historical data is not supported.… Continue reading Using NetSuite Connector for Data Migration
Mass Delete the Data on the Memo Field of a Credit Card Information under Customer Records
Scenario The user wants to delete all the date on the memo field on Customer Records credit card section. Solution Create a Saved Search customer to show customers records to be updated. 1. Go to Lists > Search > Saved Searches > New 2. Locate and Click Customer 3. In the Search Title… Continue reading Mass Delete the Data on the Memo Field of a Credit Card Information under Customer Records
Convert Seconds to HH:MM:SS
function secondsToHMS(seconds) { const h = Math.floor(seconds / 3600); const m = Math.floor((seconds % 3600) / 60); const s = seconds % 60; return `${h.toString().padStart(2, ‘0’)}:${m.toString().padStart(2, ‘0’)}:${s.toString().padStart(2, ‘0’)}`; } console.log(secondsToHMS(3661)); // Output: “01:01:01”
Deep Clone an Object
function deepClone(obj) { return JSON.parse(JSON.stringify(obj)); } const original = { a: 1, b: { c: 2 } }; const clone = deepClone(original); clone.b.c = 3; console.log(original.b.c); // Output: 2
Truncate Text with Ellipsis
function truncateText(text, maxLength) { if (text.length > maxLength) { return text.substring(0, maxLength) + ‘…’; } return text; }
Format Numbers in Indian Numbering System
function formatIndianNumber(amount) { let formatted ; // Parse the number to two decimal places if(amount){ formatted = parseFloat(amount).toLocaleString(‘en-IN’, { minimumFractionDigits: 2, maximumFractionDigits: 2 … Continue reading Format Numbers in Indian Numbering System
Preventing Value Entry in a Client Script for NetSuite Sublist Fields
In SuiteScript 2.0, client scripts offer flexibility in managing sublist fields, including restricting or removing values based on specific conditions. The following code snippet demonstrates how to prevent data entry in the Sublist field by clearing any entered value if the row index is even. In this scenario, if a user attempts to enter a… Continue reading Preventing Value Entry in a Client Script for NetSuite Sublist Fields