Best Practice for 3PL Sync
This topic covers best practices for the following in 3PL sync
Because some parts of 3PL sync are essentially Order and Fulfillment sync, for best practices related to 3PL order and fulfillment sync, refer to Best Practice for Order and Fulfillment Sync.
Mapping Logic
All complex logic for determining the field values to sync to 3PL must be handled in NetSuite in a formula field, script, or other automation. NetSuite Connector works best when mappings are relatively simple, either directly syncing data from NetSuite to the 3PL or using a simple translation mapping. Keeping complex logic in NetSuite allows you to have full control over the logic. If unexpected data is entered to a field on the order in the 3PL, determining where the unexpected data came from is greatly simplified.
Actual Shipping Cost
NetSuite Connector automatically syncs the actual cost paid to ship the order from the 3PL to the native shipping cost field on the Item Fulfillment. This syncing enables you to track the amount the customer paid for shipping on the Sales Order (incoming revenue) and the amount you paid to ship the order on the Item Fulfillment (outgoing revenue), as they are often not the same.
Inventory Detail
You must select the inventory detail on the source record (Sales Order, Transfer Order, etc.) so that NetSuite will automatically carry over the inventory detail to subsequent records that require it. If this is not possible, then you must configure NetSuite such that the inventory detail is automatically populated on the final record (Item Fulfillment, Item Receipt, Inventory Adjustment, or others) using a script or other ways. Most 3PLs do not send inventory detail in the data they return to NetSuite Connector, and while some do for certain data sets (like fulfillments), they do not with others (like inventory quantities). NetSuite should automatically provide the expected inventory detail. This ensures that the syncs related to inventory detail will work without error when NetSuite requests them, even if NetSuite Connector does not have the data to provide such detail. This also ensures that you will have the inventory detail you want on the final record.
When you select the inventory detail on the record, NetSuite automatically carries it over to subsequent records. Do not assign the inventory detail in NetSuite Connector.