Creating Order Line Mappings in NetSuite Integration

TL;DR

Order line mappings are essential for configuring field associations at the line item level within orders. This article details the steps for creating or editing these mappings within the NetSuite Connector, ensuring seamless integration for specific order fields.

How to Create or Edit Order Line Mappings

Creating or editing order line mappings enables you to align specific fields at the line-item level in a sales order with corresponding fields in NetSuite. Here’s how to set it up in the NetSuite Connector:

1. Log in to your NetSuite Connector account.
2. Select the Connector and relevant account you wish to work with.
3. Navigate to Mappings > Orders.
4. On the Orders page, click on the Order Item tab, where you’ll find existing mappings.
5. Click Add Mapping to open the Add NetSuite Mapping window.
6. Choose the appropriate field from the NetSuite Field list:
   • For standard fields, select the order line item field.
   • For custom fields, select Custom Field and enter its field ID (custom field IDs should start with custcol).
   • To find an ID, refer to documentation on NetSuite Connector Communication.
7. Click Add Mapping, then Close to confirm your selection. The new mapping will appear at the bottom of the list.
8. In the Mapping Type column of your mapping, select from the following:
   • Fixed: A constant value that always posts to NetSuite.
   • Order Header: List of header fields from the order.
   • Order Header With Translation: Value-specific based on 'if this, then that' conditions.
   • Order Line: A selection of order line item fields.
   • Order Line With Translation: Similar to the Order Header With Translation but for line item fields.
   • Logic: Suitable for complex mappings.
9. Specify the desired posting value from the <marketplace or cart> field/Fixed Value column based on your selected mapping type:
   • Fixed: Enter a constant.
   • Order Header/Line: Select from the available values.
   • Order Header/Line With Translation: Select a value and click Click to View/Edit. Ensure to map the NetSuite value accordingly:
     1. Click Add Row.
     2. Enter the connector and NetSuite value.
        • Example: Select Location, enter 1 for connector value, and 3 for NetSuite value. Here, a location of 1 posts a value of 3 in NetSuite.
     3. Repeat to map all necessary values.
     4. (Optional) Set a Default Value for unmapped values.
     5. Click Save.
10. Finally, click Save again to confirm all changes.

Note on Field IDs

NetSuite uses internal IDs and field IDs for effective communication. For example, the order ID displayed is associated with an internal ID shown in the record's URL. Field IDs for standard fields are typically presented in lowercase in SuiteScript but are camel case in SuiteTalk. Thus, an effective mapping strategy must reference these correct field IDs rather than their labels, especially if field names have been modified in your NetSuite account.

Who This Affects

• Administrators: Responsible for setting up and maintaining the integration.
• Developers: Involved in the technical aspects of mappings.
• Accountants: Users who depend on accurate order processing and reporting.

Key Takeaways

• Order line mappings are crucial for aligning order details with NetSuite fields.
• Proper ID referencing is essential for correct field mapping.
• Understanding mapping types enhances your configuration capability for integrations.

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