Configure and run flows in the 3PL Central – NetSuite integration template

Additional record mapping is required to integrate the template’s exports and imports with your 3PL Central and NetSuite apps.

Contents

• Overview: Understanding the 3PL Central - NetSuite quickstart integration template
• Install the 3PL Central - NetSuite quickstart integration template
•  Configure and run flows in the 3PL Central NetSuite integration template
  • 3PL Central inventory adjustments to NetSuite inventory adjustments
  • 3PL Central inventory receivers to NetSuite return authorizations and item receipts
  • 3PL Central shipment confirmations to NetSuite item shipments
  • NetSuite items to 3PL Central items
  • NetSuite sales orders to 3PL Central sales orders

3PL Central inventory adjustments to NetSuite inventory adjustments

This flow syncs 3PL Central inventory adjustments as NetSuite inventory adjustments. When new inventory adjustments are created in 3PL Central, the integration flow exports inventory adjustments from 3PL Central to NetSuite.

Flow details

Export source: 3PL Central

• Get3PL Central inventory: This export retrieves all inventory records that were created since the last flow run time from 3PL Central.

Import destination: NetSuite

• Import NetSuite inventory adjustment: This import adds or ignores inventory adjustments in NetSuite with the configured custom field as the lookup identifier.

Before you begin

• Verify that 3PL Central Items have the same values as NetSuite Items.
• Create an inventory cost revaluation field for the NetSuite item. 

Setup instructions

1. Configure mapping for Adjustment Account (InternalId) and Adjustments : Location (InternalId) in NetSuite import.

2. Add Subsidiary (InternalId) mapping on NetSuite inventory adjustments import.

3PL Central inventory receivers to NetSuite return authorizations and item receipts

This integration flow syncs 3PL Central inventory receivers as NetSuite return authorizations and item receipts. The integration flow exports inventory receivers from 3PL Central and imports that data into NetSuite as return authorizations and item receipts whenever a new inventory receiver is created in 3PL Central.

Flow details

Export source: 3PL Central

• Export 3PL Central inventory receivers: This export retrieves any records created or updated since the last time the flow ran.

Import destination: NetSuite

Import NetSuite return authorizations: This import retrieves NetSuite return authorizations.

1. This import uses the following field mappings:

2. This import uses the following response mappings:

• Import NetSuite item receipts:
  1. This import uses the following field mappings:

Before you begin

• Sync NetSuite sales orders and item shipments with 3PL Central sales orders 
• Sync 3PL Central shipment confirmations to NetSuite item shipments.
• NetSuite Order # should have the same values as 3PL Central ReferenceNum.

Setup instructions

1. Configure mapping for Status (InternalId) and Order Type (InternalId) in NetSuite return authorization import.

2. Configure dynamic lookup for Created From (InternalId) and End User (2) (InternalId) in in NetSuite return authorization import.

3. Configure dynamic lookup for Items : Quantity in NetSuite item receipts import.

4. Configure mapping for Location (InternalId) and Items : Location (InternalId) in  Import NetSuite item receipts import.

3PL Central shipment confirmations to NetSuite item shipments

This integration flow syncs 3PL Central shipment confirmations as NetSuite item shipments. When new inventory adjustments are created in 3PL Central, the integration flow exports shipments from 3PL Central to NetSuite.

Flow details

Export source: 3PL Central

• Get3PL shipment confirmations: This export retrieves all shipment confirmations created or modified from 3PL Central since the last time the flow ran.

Import destination: NetSuite

• Import NetSuite item shipments: This import adds all item shipments retrieved by the Get3PL Central inventory export to NetSuite. The import adds or ignores item shipments using the reference number as the lookup identifier.

Before you begin

1. Set up the NetSuite sales orders with the 3PL Central sales orders flow.
2. NetSuite Order number should have the same values as 3PL Central ReferenceNum.

Setup instructions

1. Configure mapping for Items : Location (InternalId) in NetSuite item shipments import.

2. Configure dynamic lookup for Created From (InternalId) in NetSuite item shipments import.

NetSuite items to 3PL Central items

This integration flow syncs NetSuite items as 3PL Central items. Any creation event performed via the NetSuite user interface or REST API is exported to Integrator.io. When new items are modified in NetSuite the integration flow exports those items from NetSuite to 3PL Central.

Flow details

Export source: NetSuite

• Get all items from NetSuite:

Import destination: 3PL Central

• Import 3PL Central items.
• Import NetSuite inventory items.
• Import NetSuite Kit items.
• Import NetSuite Assembly items.

Setup instructions

1. Create a saved search on Items records in NetSuite, and configure it on the export.
2. Create a custom checkbox field in the NetSuite import, and configure mappings for Sent to 3PL in NetSuite Inventory items and NetSuite Assembly items imports.

3. Configure the customer ID field in 3PL Central items import.

NetSuite sales orders to 3PL sales orders

This integration flow syncs NetSuite sales orders as 3PL sales orders. Whenever a new sales order is created in NetSuite, this integration flow exports sales orders from NetSuite and imports them into 3PL Central, whenever a new sales order is created in NetSuite.

Flow details

Export source: NetSuite

• Get NetSuite sales orders: This export sends any sales order created in NetSuite to integrator.io.

Import destination: NetSuite

• Import 3PL Central sales orders: This import sends the sales order in the export from NetSuite to 3PL Central.

Before you begin

1. Sync NetSuite inventory items with 3PL Central items.
2. Verify the NetSuite item name and item number are mapped to the 3PL Central item name and item number.
3. Verify the NetSuite customer name is mapped to the 3PL Central company name.

Setup instructions

1. Configure mapping for facilityIdentifier.id in 3PL Central sales orders import.

2. Configure dynamic lookup for customerIdentifier.id in 3PL Central sales orders import.