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 / creditmemofields → transaction fields billing address customer billingaddress billingaddress start date orderstartdate startdate end date enddate enddate due date duedate duedate invoice date invoicedate trandate invoiceitemdetail / creditmemoitemfields → 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 https //app nue io 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 docid\ tguor j2gqmocfcc bu3m 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