NetSuite Connector - Fields Mapping

Effective field mapping is a critical component of the NetSuite integration, ensuring accurate data synchronization between Nue and NetSuite. Properly configured mappings enable seamless communication between the two systems, preserving data integrity and reducing manual errors in financial records, invoicing, and accounting statuses. This article outlines the standard field mappings between Nue and NetSuite and explores how custom field mappings can be used to meet unique business requirements.

Standard Fields Mapping

This section provides the details of the standard fields mapping between Nue and NetSuite.  

Customer

In Nue, customers are represented as the Customer object, while in Salesforce, they are represented as the Account object. These are synchronized to the Customer object in NetSuite.

Customer Sync Field	Nue Field	NetSuite Field
Name	name	companyName
ID	id	externalId
Customer Email	email	Email
Customer Since	customerSince	StartDate
Description	description	comments
Phone	phone	phone

Product

In Nue/Salesforce, customers are represented as the Product object. These are synchronized to the Item object in NetSuite.

Product Sync Field	Nue Field	NetSuite Field
ID	id	externalId
SKU	sku	itemId
Name	name	displayName
Description	description	salesDescription

Order

In Nue/Salesforce, orders are represented as the Order object. These are synchronized to the Transaction object in NetSuite with transaction type salesorder.  

Order Sync Field	Nue Field	NetSuite Field
Order Fields → Transaction Fields
Customer	billingAccountId	entity
Start Date	subscriptionStartDate	startDate
End Date	subscriptionEndDate	endDate
Billing Address	billingAddess	billingAddress
Shipping Address	ShippingAddress	shippingAddress
Order Product Fields → Transaction Line Fields
ID	id	custcol_nue_transactionlineid
Product ID	productId	item.id
Net Sales Price	netSalesPrice	rate
Quantity	quantity	quantity
Tax	tax	taxAmount
Total Amount	totalAmount	amount

Invoice / Credit Memo

In Nue, invoices and credit memos are represented as the Invoice and Credit Memo object respectively. These are synchronized to the Transaction object in NetSuite with transaction type invoice and creditmemo respectively.  

 

Each invoice and credit memo synchronizes their corresponding Invoice Item Detail and Credit Memo Item Detail records to NetSuite, where they are represented as Transaction Lines within the respective invoice and credit memo transactions.

 

Sync Field	Nue Field	NetSuite Field
Invoice / CreditMemo Fields → Transaction Fields
Billing Address	customer.billingAddress	billingAddress
Start Date	orderStartDate	startDate
End Date	endDate	endDate
Due Date	dueDate	dueDate
Invoice Date	invoiceDate	tranDate
InvoiceItemDetail / CreditMemoItem Fields → Transaction Line Fields
Transaction Quantity	transactionQuantity	quantity
Transaction Amount	transactionAmount	amount
Start Date	startDate	custcol_nue_start_date
End Date	endDate	custcol_nue_end_date

Custom Fields Mapping

The NetSuite Connector supports the custom field mapping between Nue and NetSuite for the following objects:

Nue Object	NetSuite Object
Customer	Customer
Product	Item
Order	Transaction with transaction type salesorder
Invoice	Transaction with transaction type invoice
Credit Memo	Transaction with transaciton type creditmemo

 

The following Nue field types are supported: 

• Text
• Checkbox
• Number
• PickList
• Date
• Date Time
• Email
• ID
• Phone
• Currency

Configure Custom Field Mapping

Users can set up custom field mappings for all supported objects directly through the NetSuite Connector in the Nue App by following the steps below: 

• Login to Nue App
• Navigate to Settings → NetSuite Integration.  Click 'Launch' to launch the Configuration Wizard.  
• in the Configuration Wizard, after setting up the credentials, click Next to navigate to the Customers configuration screen
• In the Fields Mappings section, click "Add Property to 1st Value" and follow the steps to map NetSuite fields with Nue Fields  
• Click 'Next' to save the fields mapping of Customers, and navigate to the Products / Items configuration screen. Repeat the same steps in the Products / Items configuration screen to configure custom fields mapping for Products / Items. 
• Click "Next" to save the fields mapping of Products / Items, and navigate to the Transactions configuration screen.  Repeat the same steps in the Transactions configuration screen to configure custom fields mapping for Sales Orders, Invoices and Credit Memos.  

NOTE   The mapping schema follows a Key/Value Pair format, where the NetSuite field serves as the Key and the Nue field as the Value. Note that the field setup must use the field name, not the field label.   Multiple NetSuite fields can be mapped to a single Nue field. If multiple NetSuite fields are mapped to the same Nue field, the value of the Nue field will be synchronized to all the mapped NetSuite fields during the synchronization process.   Before executing a live sync job from Nue to NetSuite, it is essential to first sync all field metadata from Salesforce to Nue. For more information about synchornizing custom fields from Salesforce to Nue, please refer to this article.

Configure Field Mapping for NetSuite's Item Object

Because the NetSuite Connector accesses NetSuite Items via the SOAP API due to legacy tax considerations, the Item field mapping differs from other objects. To address this, the NetSuite field type must be included as a suffix in the field mapping.

 

Example:

For a NetSuite field named ns_field_001 with a field type of “List/Record,” you would map it to a picklist-type Nue field (e.g., nue_field_001) using the following format:

{

    "ns_field_001:list": "nue_field_001"

}


 

The following table shows the Configure Type names supported for Item object: 

 

Custom Field Type	Configure Type Name
Check Box	checkbox
List/Record Document	list
Free-Form Text Text Area Phone Number E-mail Address Hyperlink Rich Text	string
Date Time of Day or Date/Time (both in one field)	date
Integer	number
Decimal Number	decimal
Multiple Select	multilist

 

Configure Field Mapping for Picklist / List Type Fields

For list-type records, map the API Name of each list option to the corresponding List/Record internal ID in NetSuite.

 

Example:

The Department in NetSuite is a record type and a field on the Customer object called department. To map it:

• Create a picklist field on the Salesforce Account object, e.g., ns_department.
• Set the API Name of ns_department to match the internal ID of the corresponding department in NetSuite.
  • Example: Salesforce Picklist Option → NetSuite Department Internal ID.
• Configure the field mapping in the Configuration Wizard.

This process ensures seamless synchronization between Salesforce and NetSuite for list-type records.