NetSuite Connector Order Sync Form Identification and Management

Identifying and managing the specific forms that NetSuite Connector uses for order synchronization is crucial for accurate data handling. By default, most orders are synced as sales orders, while specific sources like Point of Sale (POS), Amazon FBA, and Walmart Fulfillment Services use cash sales. This article outlines how to check and configure the forms used by NetSuite Connector.

Default Sync Behavior

NetSuite Connector typically syncs most order types as sales orders. However, specific types, such as POS and Amazon FBA, sync as cash sales. It is important to be aware that NetSuite does not specify which form is used for the record; instead, it defaults to the preferred sales order form unless a custom form is specified.

How to Check Which Form is Being Used

You can determine which record or form the NetSuite Connector is syncing to through two methods:

• Check Order Mappings: Navigate to Mappings > Orders in your connector account to review the mapping configurations.
• View a Synced Order: Open a successfully synced order and inspect the customForm field. If this field is populated, it indicates which form's internal ID is being used. If the field is absent, NetSuite defaults to the preferred form associated with that record type.

Modifying the Preferred Order Form

To change the form that NetSuite Connector uses for posting orders, you'll need to either update the preferred form within NetSuite or create a specific mapping within the connector. Follow these steps to create a form mapping:

1. Log in to your connector account.
2. Select the relevant account and connector.
3. Navigate to Mappings > Orders.
4. Click on the Order tab.
5. Click Add Mapping to open the mapping popup.
6. In the NetSuite Field dropdown, select Custom Form.
7. Click Add Mapping to save the mapping.
8. If necessary, reload the NetSuite lists to adjust the dropdown options.
9. Select the desired form from the list and click Save.

Best Practices

• Always ensure the selected form matches the type of order being synced to avoid errors.
• Regularly review mappings in the connector to ensure they align with business processes and requirements.

By managing the forms that are synced with your orders effectively, you can optimize your integration with NetSuite and enhance the accuracy of your financial data.

Source: This article is based on Oracle's official NetSuite documentation.

Key Takeaways

• NetSuite Connector defaults to the preferred sales order form unless otherwise specified.
• You can check which form is being used via order mappings or synced orders.
• Changing the order form can be done through mapping configurations in the connector.