Celigo has a feature to add the path to records called Path to records in the HTTP response body under the Non-standard API response header in the export step. This optional field allows integrator.io to locate the resource (or set of resources) returned from an API call. If the HTTP response from an API contains… Continue reading Specifying Path to Records in Celigo
Author: Anuja Varghese
Setting Default Shipping Method
Go to Setup —> Accounting —> Shipping Set the default shipping method there and save it. Based on the customer also we can make the shipping method default in Netsuite. For that go to Customer record —> Preferences Subtab and add default shipping method for that specific customer there.
GraphQL Query in Celigo Request body
In the Rest API Integration, If the application uses GraphiQl Query to call the API like the one attached below. Add it in the request body of Celigo like the following Also in the Relative URL add “/graphql.json” (For Example : https://<shop>.myshopify.com/admin/api/<YYYY>-<MM>/graphql.json)
Adding a file link in a Custom Field by script
Create a hyperlink custom field
PROPOSAL FOR DATEV INTERFACE IN NETSUITE
Proposal summary The requirement put forward was to provide a way for exporting journal entry item line details as CSV files. The solution we are proposing is to use either a saved search or adding a button in a journal entry Requirement The requirement was to export the journal entry details as CSV files from… Continue reading PROPOSAL FOR DATEV INTERFACE IN NETSUITE
Proposal for sending Item Fulfillment details from Netsuite to Mintsoft
Proposal summary The proposal covers the scope of sending CSV files including Item Fulfillment details to Mintsoft. Requirement The requirement is to send the Item fulfillment details as a csv file to an specific email id. Then order importing will be performed in their end. Our Solution Solution #1 We will create a saved… Continue reading Proposal for sending Item Fulfillment details from Netsuite to Mintsoft
Proposal For Netsuite – Wayfair Integration
This proposal covers the Wayfair Integration for Harbour Lifestyle. This proposal also covers the engagement scope of Jobin and Jismi It Services LLP, as official implementation partner Of Oracle NetSuite. Proposal summary The Proposal covers the scope of Wayfair and NetSuite Integration. Requirement The requirement is to create two custom flows between Wayfair and… Continue reading Proposal For Netsuite – Wayfair Integration
Changing Date Format in Saved Search
If you want to change the date format of a date field in Netsuite Saved Search, do the following Open the search and in go to the Result subtab Add Formula (Text) On the Formula field, add TO_CHAR({fieldid},’DateFormat’) For Example : TO_CHAR({trandate},’MM/DD/YY’) Click Add
Setting Custom Item Rate Field in Advanced PDF Template
Create a Custom Transaction Column Field : Navigate to Customization >Lists, Records, & Fields > Transaction Line Fields > New Give the label and id to the field Select the type as Currency. Uncheck the Store Value Checkbox. Click Applies To Sale Item: Enter Checkmark. In Validation & Defaulting, Enable the formula box and give the formula as the… Continue reading Setting Custom Item Rate Field in Advanced PDF Template
Partner Discount in Netsuite
Usually, the Discount items will show up on List > Accounting > Items (Type: Discount). But Partner Discount won’t show up there. Because they are built-in records that have a negative internal ID which is hidden from the item list and Saved Searches. Partner Discount is a Discount for Sale Item with Internal Id as… Continue reading Partner Discount in Netsuite