Sales Order Integration

By in ,
Sales Order Integration

Sales Order Integration

This article will go through the SFDC to NetSuite Sales Order Integration. This is one of the most common integrations and we will go through all the steps needed in Boomi to Implement this.

How to Fetch Orders from SFDC:

Once an Order is created in Salesforce you can get it in Boomi by performing the following steps:

Sales order Integration - Salesforce Connector

Action: Get

Connection: Select the common connection you have in your Account

Operation: Create a new operation by following the steps below.

  1. Click on the Import button at the top right of your screen
  2. Select the common SFDC Connection and click on next
  3. The object Type should be Sales Order and Action should be Query.
  4. If you are to fetch Parent/Child objects, then don’t checkbox the Skip import of parent/child hierarchy
  5. From the Child object select the Order Product object
  6. Once completed Boomi will fetch the Schema of the Order and Order Product object of SFDC
  7. It is a recommended practice to select only the fields that you would need for your integration as circled in the screenshot below:

Sales Order Integration - SF Operation

Once you have selected all the fields review the query by clicking on Show SOQL.

How to send data to NetSuite:


Before you do the SFDC to NetSuite mapping you need to import the NetSuite Profile. Based on the requirement, you would create/Update/Upsert to NetSuite. The recommended action for creating Sales Orders in NetSuite is Upsert.

The configurations could be as below:

Sales Order Integration - Netsuite Operation

You need to specify the Action (Create/Update/Upsert) when you configure the connection:

Sales Order Integration - NS Connection

Performing the Mapping

Once both the source and target profile are imported you need to start your mapping.

Drag the map shape from the shapes palette and choose the source and target profile.

Below is a snapshot of an example of the mapping fields needed in NetSuite:

Sales Order Integration - Mapping

Following are key fields that you need to remember while mapping:

  1. External ID is mandatory to perform Upsert in NetSuite. You could use the Salesforce 18-digit Id as the NetSuite external id.
  2. Any order has an Order Header and Order Line Items. Subsidiary & External ID are the mandatory fields while doing Upsert on Orders in the Header Level.
  3. To add items to NetSuite Order you need to map either the Item’s Internal Id or map the Item name.
  4. Along with the item you need to specify the Item Location, Quantity, and Rate
  5. Apart from this map all the other fields based on your requirement and make sure you map any mandatory fields that you have set up in NetSuite.

Additional Resources:

Cover Image by on Freepik