Integration tiles found on the homepage provide an overview about the integration. What you see depends on how the integration is performing and your permissions. Status You’ll see either a green dot with the word “Success” or a red dot with the number of errors for the last 30 days. Connection Down A… Continue reading Integration tiles in Celigo
Author: Nived Krishna
CELIGO BASICS: Flows, Integrations and API
Endpoint When you move data from a system (application, database, or other data resource) to another, these systems you connect to are referred to as endpoints. The type of subscription plan you have with Celigo determines how many endpoints you can use within active flows. Example If you’re moving Salesforce account data to create new… Continue reading CELIGO BASICS: Flows, Integrations and API
BUILTIN.DF() in SuiteQL
BUILTIN.DF(transactionLine.createdfrom) AS so# BreakDown of Code: transactionLine.createdfrom Refers to the Created From field at the line level of a transaction. This field stores the internal ID of the source transaction (e.g., a Sales Order for an Invoice or an Item Receipt for a Purchase Order). BUILTIN.DF(field) BUILTIN.DF() is a NetSuite built-in function that retrieves the… Continue reading BUILTIN.DF() in SuiteQL
Retrieve only the child subsidiary name from the Subsidiary field using a search.
result.getText({ name: ‘subsidiary’ }).split(‘:’).pop().trim() || “” result.getText({ name: ‘subsidiary’ }) Retrieves the text representation of the subsidiary field from the search result. In NetSuite, getText is used to fetch the displayed text instead of the internal ID. .split(‘:’) Splits the retrieved text by the colon (:) separator. Some NetSuite fields (like subsidiary) can return values… Continue reading Retrieve only the child subsidiary name from the Subsidiary field using a search.
Retrieve invoice details through serch, including Discount Total and Gift Certificate Amount, without loading the record.
let invoiceSearchObj = search.create({ type: ‘invoice’, filters: [ [‘internalid’, ‘anyof’, invoiceArray], // Handling multiple invoices … Continue reading Retrieve invoice details through serch, including Discount Total and Gift Certificate Amount, without loading the record.
SUITEQL to Calculate Subtotal Considering Discount Item
(CASE WHEN COALESCE(discountData.discountTotal, 0) != 0 THEN (COALESCE(transaction.total, 0) – COALESCE(transaction.taxtotal, 0) + (COALESCE(discountData.discountTotal, 0) – COALESCE(discountItemData.discountItem, 0))) ELSE (COALESCE(transaction.total, 0) – COALESCE(transaction.taxtotal, 0)) END) AS invoiceSubtotal LEFT JOIN (SELECT transactionLine.transaction, SUM(ABS(transactionLine.amount)) AS discountTotal FROM transactionLine WHERE transactionLine.itemtype = ‘Discount’ GROUP BY transactionLine.transaction) discountData ON transaction.id = discountData.transaction LEFT JOIN (SELECT transactionLine.transaction, SUM(transactionLine.netamount) AS OtherCharges… Continue reading SUITEQL to Calculate Subtotal Considering Discount Item
Function for checking valid parameters
function isValid(value) { return value !== null && value !== undefined && value !== “”; }
Custom Form with Search and Editable Sublist
/** * @NApiVersion 2.x * @NScriptType Suitelet */ define([‘N/ui/serverWidget’, ‘N/record’, ‘N/search’], function(serverWidget, record, search) { function onRequest(context) { if (context.request.method === ‘GET’) { var form = serverWidget.createForm({ title: ‘Custom Sublist Suitelet’ }); var sublist = form.addSublist({ id: ‘custpage_items’, type: serverWidget.SublistType.INLINEEDITOR, label: ‘Item Details’ }); sublist.addField({ id: ‘custpage_item’, type: serverWidget.FieldType.SELECT, label: ‘Item’, source: ‘item’ }); sublist.addField({… Continue reading Custom Form with Search and Editable Sublist
Prevent Field Editing Based on Condition
/** * @NApiVersion 2.x * @NScriptType ClientScript */ define([‘N/ui/message’], function(message) { function fieldChanged(context) { var currentRecord = context.currentRecord; var fieldId = context.fieldId; if (fieldId === ‘custpage_factor’) { var stage = currentRecord.getValue(‘custpage_stage’); if (!stage) { message.create({ title: “Warning”, message: “You cannot edit the FACTOR field unless STAGE is set.”, type: message.Type.WARNING }).show(); currentRecord.setValue(‘custpage_factor’, ”); } }… Continue reading Prevent Field Editing Based on Condition
SuiteQL Query Tool
/** * @NApiVersion 2.1 * @NScriptType Suitelet * @NModuleScope Public */ /* —————————————————————————————— Script Information —————————————————————————————— Name: SuiteQL Query Tool ID: _suiteql_query_tool Description A utility for running SuiteQL queries in a NetSuite instance. Tim Dietrich * timdietrich@me.com * https://timdietrich.me —————————————————————————————— History —————————————————————————————— 20210714 – Tim Dietrich * First public beta of v2021.2. 20210725 – Tim… Continue reading SuiteQL Query Tool