Sometimes we may come across Duplicate Ids in NetSuite, in order to search for them the below steps are helpful: Navigate to Reports>Saved Searches>All Saved Searches>New. Choose any type of search On the Results tab: Choose the field value where we would screen duplicate entries among the list (e.g. Name) Set Name and Summary Type… Continue reading Searching for Duplicate Ids in NetSuite
Author: Anuja Varghese
Invalid JSON error when using a handlebars expression
Review the retry data returning the invalid JSON error. Sometimes values returned can contain certain characters, such as quotation marks (“), which, when inserting them via a handlebar into your HTTP request body, causes the JSON to be invalid. Use the jsonSerialize handlebar function in your HTTP request body on the field in question. For example, if… Continue reading Invalid JSON error when using a handlebars expression
Dollar sign notation ($.company) in field mapping?
Q. In my integration, I see references to elements within a $ object in the import mapping, like the following: {{#if $.company}} {{$.company}} {{else}} {{$.first_name}} {{$.last_name}}{{/if}} What does $ mean here? I looked for a transform and elsewhere to identify it, but it doesn’t seem to appear before the import. A. NetSuite uses $ as the equivalent of the familiar JavaScript keyword this, in… Continue reading Dollar sign notation ($.company) in field mapping?
Proposal For Location Setting in NetSuite Sales Orders
Proposal summary This proposal covers the Shopify Integration to update the line level location in sales orders according to the location in Shopify Requirement The location in shopify order has to be added in the item line in NetSuite sales order Prerequisites Please provide us the shopify API key and password to establish… Continue reading Proposal For Location Setting in NetSuite Sales Orders
How can I reference fields outside the “Path to many” in my import settings?
We can append _PARENT before any fields that you need to reference outside the Path to many that you set in your import. Note that ALL fields referenced anywhere in the import (mappings, import configuration, scripts, etc.) will be affected when One to many is set to Yes (advanced). For example, let’s say your import data looks like this: { “exampleField”: “value”,… Continue reading How can I reference fields outside the “Path to many” in my import settings?
Celigo – HTTP Sucess response to Source in Webhook Export
Go to the Advanced Section in the webhook export where we can see the following fields. Override HTTP status code for the success responses: integrator.io returns a 204 HTTP status code for all successful webhook requests by default. Select an alternate successful HTTP status code for the listener. Override HTTP response body for success responses.… Continue reading Celigo – HTTP Sucess response to Source in Webhook Export
Celigo Error: Invalid country reference key
This error is generated within a unique circumstance: The flow was developed for an earlier NetSuite bundle that had the Address subrecord set by default. This Address as a subrecord default import setting was later removed in a bundle update. The sandbox or production environment’s bundle was upgraded to the latest version. With the current… Continue reading Celigo Error: Invalid country reference key
PROPOSAL FOR ADDING DROPSHIP LOCATION TO DROPSHIP ITEMS IN SO
Proposal summary This proposal covers the scope of addinga dropship virtual location in the item line of SO if it is a dropship item. Requirement The requirement is to automatically add the fulfillment location of dropship item lines as the “Drop Ship (Virtual)”location in sales orders. Also drop ship orders still appear in… Continue reading PROPOSAL FOR ADDING DROPSHIP LOCATION TO DROPSHIP ITEMS IN SO
Setting current date in Celigo mapping
Go to the field mapping and on the source side give the following multifield expression. This will add the current date and time in Netsuite records. {{dateFormat “MM-DD-YYYY HH:mm:ss” timeStamp}} The date format in the middle should be the one that the specific Netsuite connection is using
Shopify Netsuite IA Error – Failed to create Customer Deposit for Shopify Order
Error: Failed to create Customer Deposit for Shopify Order XXXXXX due to the Invalid reference key of Order XXXXXX for Customer XXXXXX. Reason: If you map the payment method on the sales order, NetSuite restricts to a create customer deposit. Solution: Remove the payment method mappings on the Shopify order to NetSuite order (cash sale or… Continue reading Shopify Netsuite IA Error – Failed to create Customer Deposit for Shopify Order