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

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 quickstart 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
  • 3PL Central purchase order receipts to NetSuite purchase order receipts
  • NetSuite items to 3PL Central items
  • NetSuite sales orders to 3PL Central sales orders
  • NetSuite purchase orders to 3PL Central purchase orders

After you install the template, additional record mapping is required to integrate the template’s exports and imports with your 3PL Central and NetSuite apps.

Note that all of your flows are disabled when first installed. After configuring the flows, you can enable them in your Flows dashboard or in Flow Builder with the Off/On toggle button. Then run or schedule each flow.

3PL Central inventory adjustments to NetSuite inventory adjustments

This flow syncs 3PL Central inventory adjustments as NetSuite inventory adjustments. When a new inventory adjustment is created in 3PL Central, this integration flow exports inventory adjustment from 3PL Central to NetSuite.

Flow details

• Export source: 3PL Central
• Built-in export: Get 3PL Central inventory - get all inventory from 3PL Central that have been created since this flow last ran.
• Import destination: NetSuite
• Built-in import: Import NetSuite inventory adjustment - add/ignore inventory adjustments in NetSuite with the configured custom field as the lookup identifier.

Before you begin

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

Setup instructions

1. Configure the following mapping according to your business requirements in Import NetSuite inventory adjustment, before running the flow.

2. Add subsidiary mapping to Import NetSuite inventory adjustment.

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

This flow syncs 3PL Central inventory receivers as NetSuite return authorizations and item receipts. When a new inventory receiver is created in 3PL Central, this integration flow exports the inventory receiver from 3PL Central to NetSuite as return authorization and item receipt.

Flow details

• Export source: 3PL Central
• Built-in export: Get 3PL Central inventory receivers - get all inventory receivers from 3PL Central that have been modified since this flow last ran.
• Import destination: NetSuite
• Built-in lookup: Get NetSuite sales orders - get all sales orders from NetSuite with Order # as the lookup identifier.
• Built-in import: Import NetSuite return authorizations - add/ignore return authorizations into NetSuite with PO # as the lookup identifier.
• Built-in input filter: Import NetSuite return authorization item receipts - filter for record ID that is not empty.
• Built-inimport: Import NetSuite return authorization item receipts - add/ignore return authorizations item receipts into NetSuite with Ref.No. as the lookup identifier.

Before you begin

• The NetSuite sales orders and item shipments with 3PL Central sales orders must be in sync.
• The 3PL Central shipment confirmations to NetSuite item shipments must be in sync.
• The NetSuite Order # should have the same values as 3PL Central Ref.No.

Setup instructions

1. Configure the following mapping according to your business requirements in Import NetSuite return authorizations, before running the flow.

2. Configure the following dynamic according to your business requirements in Import NetSuite return authorizations, before running the flow.

3. Configure the following dynamic according to your business requirements in Import NetSuite return authorization item receipts, before running the flow.

4. Configure the following mapping according to your business requirements in Import NetSuite return authorization item receipts, before running the flow.

3PL Central shipment confirmations to NetSuite item shipments

This flow syncs 3PL Central shipment confirmations as NetSuite item shipments. When a new shipment confirmation is created in 3PL Central, this integration flow exports the shipment confirmation from 3PL Central to the NetSuite item shipment.

Flow details

• Export source: 3PL Central
• Built-in export: Get 3PL Central shipment confirmations - get all shipment confirmations from 3PL Central that have been modified since this flow last ran.
• Import destination: NetSuite
• Built-in import: Import NetSuite item shipments - add/ignore item shipments in NetSuite with the Ref. No. as the lookup identifier.

Before you begin

1. Set up the NetSuite sales orders with the 3PL Central sales orders flow.
2. The NetSuite order number should have the same values as 3PL Central Ref. No.

Setup instructions

1. Configure the following mapping according to your business requirements in Import NetSuite item shipments, before running the flow.

2. Configure the following dynamic mapping according to your business requirements in Import NetSuite item shipments, before running the flow.

3PL Central purchase order receipts to NetSuite purchase order receipts

This flow syncs 3PL Central purchase order receipts as NetSuite purchase order receipts. When a new purchase order receipt is added in 3PL Central, this integration flow exports the purchase order receipt from 3PL Central to the NetSuite purchase order receipt.

Flow details

• Export source: 3PL Central
• Built-in export: Get 3PL Central purchase orders receipts - get all purchase orders receipts from 3PL Central that have been modified since this flow last ran.
• Import destination: NetSuite
• Built-in lookup: Get NetSuite purchase orders - get all purchase orders from NetSuite.
• Built-in import: Import NetSuite purchase orders receipts - add purchase order receipts into NetSuite.

Before you begin

1. The NetSuite items and 3PL Central items should be the same in both 3PL Central and NetSuite.
2. The 3PL Central purchase order receipt ID should be stored as a custom field in the NetSuite purchase order receipt.

Setup instructions

1. Configure the following mapping according to your business requirements in Import NetSuite purchase orders receipts, before running the flow.

2. Configure the following dynamic mapping according to your business requirements in Import NetSuite purchase orders receipts, before running the flow.

3. Create a custom field in NetSuite purchase orders receipt to store the 3PL Central purchase orders receipt ID in NetSuite.

NetSuite items to 3PL Central items

This flow syncs NetSuite items as 3PL Central items. When items are modified in NetSuite, this integration flow exports the item from NetSuite to the 3PL Central item.

Flow details

• Export source: NetSuite
• Built-in export: Get NetSuite items - get all items from NetSuite that have been modified since this flow last ran.
• Import destination:  3PL Central
• Built-in import: Import 3PL Central items - add/ignore items into 3PL Central with the configured custom field as the lookup identifier.
• Built-in input filter: Import NetSuite inventory items - filter for record type that equals inventory items.
• Built-in import: Import NetSuite inventory items - update inventory items into NetSuite with the internal ID as the lookup identifier.
• Built-in input filter: Import NetSuite assembly items - filter for record type that equals assembly/bill of materials.
• Built-in import: Import NetSuite assembly items - update assembly items into NetSuite with the internal ID as the lookup identifier.
• Built-in input filter: Import NetSuite kit items - filter for record type that equals kit/package.
• Built-in import: Import NetSuite kit items - update kit items into NetSuite with the internal ID as the lookup identifier.

Setup instructions

1. Create a saved search on NetSuite items records and configure it on the export.
2. Create a custom checkbox field in the NetSuite import and configure the following mapping according to your business requirements in Import NetSuite inventory items and Import NetSuite assembly items, before running the flow.

3. Configure the custom ID field in Import 3PL Central items.

NetSuite sales orders to 3PL sales orders

This flow syncs NetSuite sales orders as 3PL Central sales orders. When a new sales order is created in NetSuite, this integration flow exports the sales order from NetSuite to the 3PL Central sales order.

Flow details

• Export source: NetSuite
• Built-in export: Get NetSuite sales orders - get all sales orders from NetSuite that have been modified since this flow last ran.
• Import destination:  3PL Central
• Built-in import: Import 3PL Central sales orders - add sales orders into 3PL Central.
• Built-in import: Import NetSuite sales orders - update sales orders into NetSuite with the internal ID as the lookup identifier.

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 the following mapping according to your business requirements in Import 3PL Central sales orders, before running the flow.

2. Configure the following dynamic mapping according to your business requirements in Import 3PL Central sales orders, before running the flow.

NetSuite purchase orders to 3PL Central purchase orders

This flow syncs NetSuite purchase orders as 3PL Central purchase orders. When a new purchase order is created in NetSuite, this integration flow exports the purchase order from NetSuite to the 3PL Central purchase order.

Flow details

• Export source: NetSuite
• Built-in export: Get NetSuite purchase orders - get all purchase orders from NetSuite that have been modified since this flow last ran.
• Import destination:  3PL Central
• Built-in import: Import 3PL Central purchase orders - add purchase orders into 3PL Central.
• Built-in import: Import NetSuite purchase orders - update purchase orders into NetSuite with the internal ID as the lookup identifier.

Before you begin

1. The NetSuite vendor name and 3PL Central customer name should be the same in both NetSuite and 3PL Central.
2. The NetSuite items and 3PL Central items should be the same in both 3PL Central and NetSuite.
3. The 3PL Central purchase order ID should be stored as a custom field in the NetSuite purchase order.

Setup instructions

1. Configure the following mapping according to your business requirements in Import 3PL Central purchase orders, before running the flow.

2. Configure the following dynamic mapping according to your business requirements in Import 3PL Central purchase orders, before running the flow.

3. Create a custom field in NetSuite purchase order to store 3PL Central purchase order ID in NetSuite.