Summary
This integration template is designed to automate the bidirectional flow of data between DCL and NetSuite, specifically focusing on order management and fulfillment processes. The template includes several predefined flows that handle the exporting and importing of purchase orders, sales orders, transfer orders, item receipts and fulfillment records. These flows are designed to simplify the integration process, ensuring that data is accurately synchronized between the two systems. You can use this template as a starting point. Modify these flows to fit your business needs.
List of Flows
-
Purchase Orders - Add Purchase Orders from NetSuite to DCL
-
Sales Orders - Add Items Fulfillments as Sales orders from NetSuite to DCL
-
Sales Orders - Add Sales Orders from NetSuite to DCL
-
Transfer Orders - Add Transfer Orders from NetSuite as Sales orders to DCL
-
DCL Fulfillment to NetSuite Fulfillment Add
-
DCL Fulfillment to NetSuite Fulfillment Add (Retry)
-
DCL Fulfillment to NetSuite Fulfillment Add (Retry) [PPS]
-
DCL Fulfillment to NetSuite Fulfillment Add [PPS]
-
DCL Item Receipt to NetSuite Item Receipt Add
-
DCL Item Receipt to NetSuite Item Receipt Add (Retry)
Purchase Orders - Add Purchase Order from NetSuite to DCL Setup
This flow exports purchase orders from NetSuite and imports them into DCL as purchase order notifications.
The flow begins with an export operation from NetSuite that is configured to use a RESTlet to extract purchase order records.The exported data is then processed by two import operations. The first import operation is an HTTP import to DCL, which creates purchase order notifications. The second import operation updates the purchase order records in NetSuite with the DCL notification IDs.
The screenshots below provide details of the saved search and necessary mappings for the flow to run successfully.
Saved Search in NetSuite:
Mappings to create PO notifications in DCL:
Mappings to update the ID in NetSuite:
Sales Orders - Add Item Fulfillments as Sales Orders from NetSuite to DCL Setup
The flow exports item fulfillment records from NetSuite, transforms the data, and imports it as sales orders into DCL.
The flow begins with an export process from NetSuite, where item fulfillment records are extracted using a RESTlet. The exported data is then transformed using a set of rules that map the extracted fields to the corresponding fields in the destination system. The import process in DCL is configured to create new sales orders based on the transformed data. The import configuration includes response mappings to capture the order statuses returned by DCL. After the sales orders are created in DCL, a second import process updates the corresponding item fulfillment records in NetSuite with the DCL order numbers.
The screenshots below provide details of the saved search and necessary mappings for the flow to run successfully.
Saved Search in NetSuite:
Mappings to create sales order in DCL:
Mappings to update the ID in NetSuite:
Sales Orders - Add Sales Orders from NetSuite to DCL Setup
This flow exports sales order data from NetSuite using a RESTlet, transforms the data, and imports it into DCL.
The flow begins with an export operation from NetSuite, where it uses a RESTlet to extract sales order records. The exported data is then transformed using a set of rules that map the extracted fields to the corresponding fields in the destination system. Once the data is exported and transformed, it is imported into DCL using an HTTP-based import operation. The import configuration specifies that the data should be sent to the 'batches' endpoint using the POST method. The import operation also includes a response mapping to capture the order statuses returned by DCL, which are then used to update the corresponding sales orders in NetSuite. The final step in the flow will update the sales order in the NetSuite with the order number.
The screenshots below provide details of the saved search and necessary mappings for the flow to run successfully.
Saved Search in NetSuite:
Mappings to create sales order in DCL:
Mappings to update the ID in NetSuite:
Transfer Orders - Add Transfer Orders from NetSuite as Sales Orders to DCL Setup
This flow will export transfer orders from NetSuite and create sales orders in DCL.
The flow begins with an export operation from NetSuite, where it retrieves transfer order records. The export process includes a transformation step that maps various fields from the NetSuite transfer order to a format suitable for DCL. After the data is transformed, it is sent to DCL through an HTTP import operation. The import is configured to send the data to a specific endpoint 'batches' using the POST method. The import operation includes response mapping to capture the order statuses returned by DCL. Once the data is successfully imported into DCL, a second import operation updates the original NetSuite transfer order with the DCL order number and status.
The screenshots below provide details of the saved search and necessary mappings for the flow to run successfully.
Saved Search in NetSuite:
Mappings to create sales order in DCL:
Mappings to update the ID in NetSuite:
DCL Fulfillment to NetSuite Fulfillment Add Setup
This flow will get the data from DCL by using order number and create an Item Fulfillment in NetSuite.
The flow begins with an export operation that retrieves data from an DCL. The export is configured to fetch the order data using a GET request to the specified URI, which includes an order number as a query parameter. The flow then proceeds to an import operation that takes the exported data and imports it into NetSuite as Item Fulfillment records.
The screenshots below provide necessary mappings for the flow to run successfully.
Mappings to create Item Fulfillment in NetSuite:
DCL Fulfillment to NetSuite Fulfilment Add (Retry) Setup
This flow exports the transfer and sales orders that hold the pending fulfillment status in NetSuite, retrieves tracking information from an DCL, and imports the enriched data back into NetSuite as Item Fulfillment records.
The flow begins with an export operation from NetSuite, where it retrieves order data. The exported data is then used in a lookup operation to fetch tracking information for each order from DCL. Once the lookup provides the details, an Item Fulfillment is created with tracking details of the order in NetSuite.
The screenshots below provide details of the saved search and necessary mappings for the flow to run successfully.
Saved Search in NetSuite:
Mappings to create Item Fulfillment in NetSuite:
DCL Fulfillment to NetSuite Fulfillment Add (Retry) [PPS]
This flow exports pending fulfillment data from NetSuite, retrieves tracking information from DCL and updates the corresponding fulfillment records in NetSuite.
The flow begins with an export operation from NetSuite, where it retrieves order data. The exported data is then used in a lookup operation to fetch tracking information for each order from DCL. Finally, the flow performs an import operation to update the fulfillment records with shipped status and tracking details of the order in NetSuite.
The screenshots below provide details of the saved search and necessary mappings for the flow to run successfully.
Saved Search in NetSuite:
Mappings to update Item Fulfillment in NetSuite:
DCL Fulfillment to NetSuite Fulfillment Add [PPS]
This flow will get the details of an order in DCL by using DCL order number and update the Item fulfillment with tracking details of the order in NetSuite.
The flow begins with an export operation that retrieves data from DCL using order number. The response data is processed and then imported into NetSuite, updating existing Item Fulfillment records.
The screenshot below provides necessary mappings for the flow to run successfully.
Mappings to update Item Fulfillment in NetSuite:
DCL Item Receipt to NetSuite Item Receipt Add
This flow will get a list of PO Receipts from DCL and create Item Receipts in NetSuite.
The flow begins with an export operation that retrieves data from DCL. The endpoint is specified by the relative URI 'po_receipts' and uses the GET method to fetch the data. The import operation is configured to add new item receipt records into NetSuite. The import operation makes use of the internal ID to find corresponding purchase orders in NetSuite.
The screenshot below provides necessary mappings for the flow to run successfully.
Mappings to create Item Receipt in NetSuite:
DCL Item Receipt to NetSuite Item Receipt Add (Retry)
This flow exports the purchase orders which are in pending Item Receipt status in NetSuite, performs a lookup to gather additional purchase order receipt information via an HTTP GET request, and then imports the enhanced data back into NetSuite as Item Receipt records.
The flow begins with an export operation from NetSuite, where it retrieves purchase order data. The exported data is then used in a lookup operation to gather additional information based on the 'Order Number' field. This is performed via an HTTP GET request to an endpoint that returns purchase order receipt information. The Lookup will provide the details of the order using customer po number as reference in DCL.
Once the lookup provides the details, an Item Receipt is created in NetSuite.
The screenshots below provide details of the saved search and necessary mappings for the flow to run successfully.
Saved Search in NetSuite:
Mappings to create Item Receipt in NetSuite:
Reminders
- This template provides a basic flow for integrating DCL and NetSuite. You can modify the flows to suit your specific needs.
- If you need further assistance, please contact support@novamodule.com