Month: March 2025

Search to get sales orders that does not have at least any of the given items

var salesorderSearchObj = search.create({ type: “salesorder”, filters: [ [“type”,”anyof”,”SalesOrd”], “AND”, [“cogs”,”is”,”F”], “AND”, [“shipping”,”is”,”F”], “AND”, [“taxline”,”is”,”F”], “AND”, [“datecreated”,”within”,”3/1/2025 12:00 am”,”3/10/2025 11:59 pm”], “AND”, [“sum(formulanumeric: CASE WHEN {item.internalid} IN (36496,36473,36470,36488,36486,36476,36490,36499,36477,36475,36483,36481,36479,36498,36480,36368,36492,36491,36494,36487,36482,36489,36627,36469,36485,36484,36478,36495,36472,36471,38291,36493,675,676,677,678,680,681,682,683,684,685,686,687,688,38311,691,693,694,36194,38287,38285,695,696,697,698,699,36188,700,38289,38290,36185,36186,707,708,36628,36189,711,713,714,36191,717,719,36363,720,721,36184,722,726,621) THEN 1 ELSE 0 END)”,”equalto”,”0″] ], columns: [ search.createColumn({ name: “tranid”, summary: “GROUP”, label: “Document Number” }), search.createColumn({ name: “internalid”, summary: “GROUP”, label: “Internal ID” }), search.createColumn({… Continue reading Search to get sales orders that does not have at least any of the given items

Filter duplicate emails from array

let noteRecepinets = [recepientEmail, recepient2, employee1, employee2, salesAssociateEmail];                                 let validnoteRecepinets = […new Set(noteRecepinets.filter(el => checkForParameter(el)))]; /**          * Function to check the validity of a parameter.          * @param {string|number} parameter    … Continue reading Filter duplicate emails from array

Raymarching in Three.js Using Signed Distance Fields (SDFs)

Introduction Raymarching is an advanced rendering technique used to create procedural surfaces, fractals, and volumetric effects. Unlike traditional ray tracing, which calculates ray intersections with polygons, raymarching steps through space using a mathematical function known as a Signed Distance Field (SDF) to determine the closest surface. This article explains how to implement raymarching in Three.js… Continue reading Raymarching in Three.js Using Signed Distance Fields (SDFs)

postResponseMap hook

The post response map hook is invoked on a page of records after response or results mapping. This hook is a great place to execute logic on batches of records to optimize the response/results data to be merged back into the source records. For example: Perform calculations using the results of a lookup, and then… Continue reading postResponseMap hook

Published
Categorized as Celigo Tagged

Resolving NetSuite Extension Fetch Error: “File Not Found”

Introduction While working with SuiteCommerce in NetSuite, you may encounter errors when fetching extensions using Gulp. One common issue is the “File Not Found” error, even though the file is present in the File Cabinet. This article discusses the possible causes and how to resolve them. Error Details During the execution of gulp extension:fetch, the… Continue reading Resolving NetSuite Extension Fetch Error: “File Not Found”

Performance Benefits of Backend Pagination and Filtering:

Compare the performance of frontend-only solutions versus backend-powered solutions for handling large datasets. Highlight the positive impact on user experience, including faster load times and smooth interactions with the application. Discuss scalability: how this architecture allows your application to handle larger datasets as it grows.

Why Implement Both Pagination and Filtering Together?

Explain the synergy between pagination and filtering: Pagination alone can’t fully optimize large datasets; filtering helps narrow down results, while pagination ensures the data remains manageable. Using both together can significantly enhance performance and user experience by ensuring users only receive the data they need, in small manageable chunks.

Quantity available of a kit item in NetSuite using saved search

Since the available quantity cannot be directly fetched from a kit item record, a saved search is used to retrieve the available quantity of its member items and their respective quantities in the kit. The saved search below provides the available quantity of a kit item. This function returns an object where the kit item’s… Continue reading Quantity available of a kit item in NetSuite using saved search

SuiteQL query to fetch the item details based on a subsidiary

Since we are unable to directly filter the item data using the subsidiary, we will have to use a modified version of the item query by joining the itemSubsidiaryMap table and subsidiary table to get the required results. SELECT item.itemid,item.id,item.itemtype FROM itemSubsidiaryMap  INNER JOIN item ON  (item.id=itemSubsidiaryMap.item) INNER JOIN subsidiary ON  (subsidiary.ID=itemSubsidiaryMap.subsidiary) WHERE subsidiary.id=${nsSubsidiary}