Netsuite

Overview
Integration

Overview

NetSuite is the world’s leading provider of cloud-based business management software. 16,000 high-growth and midsized companies and divisions of large enterprises use NetSuite to manage core business processes with a single, fully integrated system covering ERP/financials, CRM, ecommerce, inventory and more. NetSuite also offers industry-specific solutions for professional services, software, wholesale distribution, manufacturing, and ecommerce. NetSuite OneWorld helps global, multi-company organizations manage subsidiaries better with robust multinational, multi-currency support.

Financial Management

Drive new efficiencies, gain real-time insights and streamline your financial processes with a comprehensive solution that combines robust finance and accounting capabilities with built-in business intelligence that is accessible from any location, at any time.

Order Management

Accelerate the order-to-cash process and eliminate manual bottlenecks by integrating your sales, finance and fulfillment teams with pricing, sales order management and returns management features.

Production Management

Gain real-time visibility into your production process and get your products to market as quickly and cost-effectively as possible with product data management, work order management and quality assurance solutions.

Supply Chain Management

Define, execute and support your distribution and supply chain management plans from a single collaborative platform that you can access anywhere, anytime and from any location.

Integration

What data syncs?

BambooHR Field	Netsuite Field	Field Logic or Notes
Status	isInactive
Employee #	ID	*This is a secondary unique identifier. It will look for email address first, and then it will look for Employee # to find the match. If it can't find a record in NetSuite with the email address, then it will try the Employee #. If it can't find a record with the Employee #, then it will create a new record in NetSuite.
Date of Birth	Birthdate
First Name	First Name
Middle Name	Middle Name
Last Name	Last Name
Gender	Gender
Marital Status	Marital Status
Address line 1	Address	The address info BambooHR sends over will be labeled as "Address from BambooHR"
Address line 2	Address
City	City
State	State
Zip code	Zip
Country	Country
Mobile Phone	Mobile Phone
Home phone	Home phone
Work email	Email	*This is the Unique Identifier. It will look for email address first, and then it will look for Employee # to find the match. If it can't find a record in NetSuite with the email address, then it will try the Employee #. If it can't find a record with the Employee #, then it will create a new record in NetSuite.
Work phone	Office Phone
Employment Status	Employee Status
Hire Date	Hire Date
Termination Date	Termination Date
Location	Location
Department	Department
Division	Subsidiary	Divisions in BambooHR are mapped to subsidiaries in NetSuite. The name of the division in BambooHR must match the name of the subsidiary. BambooHR will not automatically create subsidiaries in NetSuite. If a matching subsidiary cannot be found, no subsidiary will be set for the employee. If you are not using subsidiaries (not a OneWorld account), no action is required.
Reporting to	Supervisor	If a manager is not specified within NetSuite, the integration will sync the employee but will not indicate the manager. This will be logged in the error log and provide more details.
Job Title	Job title
Ethnicity	Ethnicity

Note that the syncing of data for this integration flows from BambooHR into NetSuite and so all updates to the syncing fields must be made in BambooHR. Changes made directly within NetSuite to the shared syncing fields will not automatically update in BambooHR. For this purpose, we suggest using BambooHR as your system of record.