Data Manipulation in NetSuite and NetSuite Connector
You can automate your data in NetSuite by creating workflows and scripts. For example, you can create a workflow that automatically creates a cash sale when a sales order is in Pending Fulfillment state. Another example is you can create a script that calculates an item’s profitability and automatically populates the profitability on the sales order line item.
NetSuite Connector also has certain capabilities to transform data through calculations and post to NetSuite. However, if an automation or calculation relies on NetSuite data, you should implement a workflow or script in NetSuite. For example, assume that you have a custom record in NetSuite and want to populate information from that record on the sales orders. In such case, you should set up a script in NetSuite because the custom record data is in NetSuite.
Use NetSuite Connector for automations that only rely on storefront data. In such case, NetSuite Connector may be able to manipulate the data prior to the sale order posting to NetSuite. You can adjust the order or fulfillment mappings or change the connector settings in the NetSuite Connector. For example, you want to auto-populate the Department field on sales orders based on the order type in the storefront. To achieve this automation, set up a logic mapping for the Department field in NetSuite Connector so that the correct value posts to NetSuite.