Author: Aishwarya M J

Creating Inventory Adjustments via SuiteScript Returns Unexpected Error

Scenario When creating an Inventory Adjustment record using SuiteScript, an unexpected error is returned. However, when setting the same values in UI, the record is saved successfully. Solution One possible cause for this is because there are customizations that is trying to set the main body Location field on the Inventory Adjustment. The body location field on the Inventory Adjustment record is Adjustment… Continue reading Creating Inventory Adjustments via SuiteScript Returns Unexpected Error

Export or import NetSuite multiple select fields

NetSuite multiple select field types allow you to include multiple values in a single field.  In a scheduled flow that uses a saved search, integrator.io exports the multiple select field as a string with each value separated by a comma. In a real-time flow (one initiated by a webhook listener), integrator.io exports a multiple select… Continue reading Export or import NetSuite multiple select fields

Functions supported by the integrator.io EDI generator

The given below are the functions supported by the EDI generator _counter : The _counter function is relatively new and helps you to count the number of EDI segments generated for the same segment identifier. Set the counter to true for an EDI segment in your definition file. _iterationCount : The _iterationCount EDI function is… Continue reading Functions supported by the integrator.io EDI generator

Attach and detach objects in NetSuite File Cabinet

You can attach (with nlapiAttachRecord) and detach (with nlapiDetachRecord) records in NetSuite and files in the NetSuite file cabinet. You can specify if you want to attach a record or detach a record while configuring the import. Choose one of the following options: Add Update Add/Update Attach Detach The mappings page has the following locked… Continue reading Attach and detach objects in NetSuite File Cabinet

Set NetSuite date format on saved searches

Consider a scenario where you exported records from NetSuite via a saved search flow, but the date fields were exported in the European format D/M/YYYY rather than your preferred format, DD-MMM-YYYY. You might have wondered if the issue was because the Celigo export had used the date format in the company preferences setting, which had… Continue reading Set NetSuite date format on saved searches

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

Fix the error {{# each data}} not found in the template.

The error “{{# each data}} not found in the template.” is encountered when creating file for FTP transfer. Solution: It’s the validation to have an each loop specifically for the batch_of_records. To solve the issue, Update the handlebar as below. Also set page size to 1 in Export step and skip aggregation set to true… Continue reading Fix the error {{# each data}} not found in the template.

Exclude the JSON row structure from files

When creating the JSON files the JSON data is enclosed in square brackets. The opening and closing square brackets are the defining characteristics of a JSON row structure. When we group the export data, the data passes through the rest of the flow in row structure. These square brackets can be removed by using the below… Continue reading Exclude the JSON row structure from files