NetSuite
This page describes how to use Census with NetSuite.

In this guide, we will show you how to connect NetSuite to Census and create your first sync.

This process involves several steps - please set aside 15-30 minutes to complete it. NetSuite configuration can be complex, so if you have any questions please contact us via [email protected] and we'll help you tailor these instructions to your needs.

  1. 1.
    Visit the integrations page or use the global search to look for and navigate to: page: Manage Integrations
  1. 1.
    Create a new integration with the follow properties:
    • Give it a name that you'll recognize, such as Census
    • Check TOKEN-BASED AUTHENTICATION
    • Leave OAuth 2.0 AUTHORIZATION CODE GRANT unchecked
    • Leave TBA: AUTHORIZATION FLOW unchecked
    • Set State to Enabled
  2. 2.
    Click Save when finished.
  3. 3.
    Copy and paste the CONSUMER KEY / CLIENT ID and CONSUMER SECRET / CLIENT SECRET to a password manager. You'll need those later to paste into Census.

  1. 1.
    Global search to page: Enable Features
  2. 2.
    Navigate to the tab SuiteCloud > Manage Authentication
  3. 3.
    Make sure Token Based Authentication is checked
  4. 4.
    Save

The Administrator user you're using with NetSuite and Census also needs "Token Role".
  1. 1.
    Global search to page: New Role
  2. 2.
    Name the role: Census
  3. 3.
    Check WEB SERVICES ONLY ROLE
  4. 4.
    Check DO NOT RESTRICT EMPLOYEE FIELDS
  5. 5.
    For multi-subsidiary NetSuite users**,** check ALL under ACCESSIBLE SUBSIDIARIES
  6. 6.
    Under Permissions > Setup, add the following permissions:
    • Access Token Management: Full
    • Custom Body Fields: Full
    • Custom Column Fields: Full
    • Custom Entity Fields: Full
    • Custom Fields: Full
    • Custom Item Fields: Full
    • SOAP Web Services: Full
    • User Access Token: Full
7. Under Permissions > Lists, Give your Role the appropriate permissions for the NetSuite objects you'll be updating. For example, to update Customers, you'll want to give this role the Lists > Customers (Full) permission.

  1. 1.
    Global search to page: Employees
  2. 2.
    Edit the employee record of the Admin user you will be using Census with.
  3. 3.
    Navigate to Access > Roles and add the Token Role you just created above.

  1. 1.
    Global search to page: Access Tokens
  2. 2.
    Click New Access Token
  3. 3.
    Select the application and role we created above, then press Save
  4. 4.
    Copy and paste the new Token ID and Token Secret to your password manager or file. We'll use it below.
Note: Netsuite permission changes to a role or user do not occur immediately. These changes typically take anywhere from a few minutes to a few hours, and they can even take up to 24 hours to go into effect. If you are confident that you have given Census the correct permissions above and experience an error setting up the connection, we recommend waiting for these changes to go into effect before testing the connection again.

The last bit of information youโ€™ll need is your NetSuite Account ID:
  1. 1.
    Global search to page: Company Information.
  2. 2.
    Your ACCOUNT ID will be found on that page. Copy and paste it as well.

  1. 1.
    Now in Census, add a new Service Connection.
  1. 1.
    Paste the Account ID of your NetSuite Account, as well as the Consumer Key, Consumer Secret, Token ID and Token Secret created above.
  1. 1.
    Click Save Connection, and click Test to double check your connection information.
You're ready to start using Census to load data from your warehouse to NetSuite! If you have any trouble with these steps, please don't hesitate to reach out to: [email protected] and we'll help get this setup.
โ€‹

NetSuite's API speed and rate limitation are complex and are tied to the plan you are on but you can expect a speed of ~500 records sync / minute on their base plan,
Service
Records sync / Minute
NetSuite
500
Please note that you can contact your Customer Success Manager at NetSuite to increase your NetSuite account API concurrency to increase the records sync speed.

This is is the current list of NetSuite objects supported by our connector. There are many more and we add them on a case by case basis. If you need a different type of object, please contact us to let us know which object do you need, and we will be happy to support it.
Object Name
Supported?
Account
โœ…
Billing Account
โœ…
Cash Sale
โœ…
Class
โœ…
Contact
โœ…
Credit Memo
โœ…
Currency
โœ…
Customer
โœ…
Customer Payment
โœ…
Customer Status
โœ…
Custom Record
๐Ÿ”œ
Department
โœ…
Employee
โœ…
Invoice
โœ…
Inventory Item
โœ…
Journal Entry
โœ…
Location
โœ…
Partner
โœ…
Purchase Order
โœ…
Sales Order
โœ…
Subscription
โœ…
Subscription Change Order
โœ…
Subsidiary
โœ…
Vendor
โœ…
Please note that NetSuite doesn't support the creation of fields via Census and currently we don't support add all fields feature for NetSuite

Learn more about all of our sync behaviors on our Core Concept page.
Behaviors
Supported?
Objects
Update or Create
โœ…
All
Update Only
โœ…
All
Create Only
โœ…
All
โ€‹
๐Ÿ“ซ
Contact us if you want Census to support more Sync Behaviors for this destination

โ€‹Contact us via [email protected] or start a conversation with us via the in-app chat.
Copy link
On this page
๐Ÿƒโ€โ™€๏ธ Getting Started
Prerequisites
1. Create an Integration Record for Census
2. Enable Token Based Authentication
3. Create a Token Role
4. Add Token Management Permissions
5. Create Access Tokens
6. One more thing: NetSuite Account ID
7. Finally, Configure Your Census Connection
๐ŸŽ Sync Speed
๐Ÿ—„๏ธ Supported Objects
๐Ÿ”„ Supported Sync Behaviors
๐Ÿš‘ Need help connecting to NetSuite?