You 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 Reference fields outside the “Path to many” in import settings
Month: May 2023
NetSuite Analytics Warehouse Product Overview
Introduction NetSuite Analytics Warehouse is a powerful business intelligence solution designed to provide comprehensive insights and analytics for organizations operating on the NetSuite platform. By seamlessly integrating with NetSuite’s robust suite of cloud-based business management applications, Analytics Warehouse empowers businesses to unlock the full potential of their data and make informed, data-driven decisions. In today’s… Continue reading NetSuite Analytics Warehouse Product Overview
Array length issue on initailize extend
When array length issue occurred check the error and find out where the error the extend the child view and give the code to correct the condition not get the array empty.
Modify Body Fields in WorkfLow Locked Records via Script
A user wants to update body fields of records locked by a workflow. Note: We are unable to load records locked by workflow using SuiteScript through record.load(options). Solution The following code snippet sets the Memo field to ‘Testing’ on a Sales Order which has an internal id of 440 and is locked by a workflow. Note: Fields that can be… Continue reading Modify Body Fields in WorkfLow Locked Records via Script
To create a Item fulfillment Email template.
Create a email template Document->templates->email template->newCreate a IF Create a new template by updating code
Error in NetSuite Item to Magento Product Add/Update flow
An error message is displayed while running the NetSuite item to Magento Product Add/Update flow as shown. {“message”:”Error occurred during \”custom_attributes\” processing.Attribute \”category_ids\” has invalid value.The \”string\”value’s type is invalid.The \”int[]\” type was expected.Verify and try again.”} This can be resolved by adding the category id in the result tab of the saved search. Map… Continue reading Error in NetSuite Item to Magento Product Add/Update flow
Set a Custom form for the sales order on a Specific Customer
ScenarioThe client is creating a sales order from the customer record > Quick action> Sales order. while creating sales order like this client want to set a specific custom form for this particular customer. SolutionGo to customization> Workflows > Workflow> NewRecord Type: TransactionSub Type: Sales OrderEvent Defenition On createClick save(No need to give conditions in… Continue reading Set a Custom form for the sales order on a Specific Customer
Issues with plugins in a browser
Plugins are third-party software components that add additional functionality to a web browser. Although plugins can be helpful in extending the features of a browser, they can also cause a number of issues. Security Vulnerabilities: Plugins can be a potential security risk as they can introduce security vulnerabilities that hackers can exploit to gain access… Continue reading Issues with plugins in a browser
Change the data type of the data in Celigo
We can change the data type of data in the mapping side of the Celigo. First, Click the setting of the mapping data field then assign the data type to data (Desired data type)
How to get value from Sales order, in an Item fulfilment email template?
Scenario: While creating Item fulfilment email template, if we want to take data from the sales order record, such as order date etc. Use the following code. <#assign salesOrder = record.createdfrom><#if salesOrder?has_content><p>Sales Order Date: ${salesOrder.trandate}</p></#if>