Integration Management

Updated on February 22nd, 2023

+ More

Participate in our Help Center User Experience Survey to shape its future enhancements. It's quick, under 5 minutes, and your feedback is invaluable.

Order Destinations

Setting Up NetSuite OMS

This article reviews NetSuite integration as an Order Destination. To Connect to NetSuite as an Order Source, See here.

Authentication limitation

Extensiv Integration Manager connects to NetSuite's API using their original username/password authentication, not their newer Key-based authentication. This means the following:

You must provide Integration Manager with the username and password for a valid non-admin user in NetSuite
The NetSuite user can not have two factor authentication enabled.
Because you cannot use two factor authentication, we recommend you use a unique password that you don't use for any other accounts, or set up a NetSuite account that is only used for Integration Manager access.

Step-by-step guide

Required testing

The Extensiv Integration Manager NetSuite connection currently requires review and testing. Please reach out to Integration Manager Support so your setup may be reviewed and verified before going live.

Enable web services

Login to NetSuite and go to: Setup > Company > Enable Features > SuiteCloud
Make sure the Web Services box is selected and click Save.

Enable internal IDs

This setting will make it easier to collect all the required information below. You can turn this setting off once the Integration Manager connection is completed if desired.

Go to: Home > Set Preferences.
In the General tab, click Show Internal IDs (in the Defaults section.)

Get your account ID

Login to NetSuite and go to: Setup > Integration > Web Services Preferences
The Account ID should be to the left side of the screen.
Enter this into Integration Manager in WMS Setup

Set up role and get role ID

Go to Setup > Users/Roles > Click on Manage Roles.
There should be a list of roles displayed, click on the one you want to use. We recommend the Warehouse Manager role.
Navigate to Permissions > Setup. If not done, add Web Services and set to Full. Select Save.
Now go to Setup > Integration > Web Services Preferences.
In the Name dropdown, select the user (If only the ID is shown, you can see your user ID in the upper right of the NetSuite page).
Select the default role to use for Web Services.
The Role ID will be displayed on the screen. Copy this and enter into Integration Manager WMS Setup.
Click on Done and Save.

You can not use an administrator role as this role require 2-factor authentication. Therefore, it cannot be used by Integration Manager connections. Lower access levels do not require 2-factor authentication.

Make sure your role also has full "Web Services" permissions.

Get your application ID

Go to Setup > Integration > Manage Integrations > Click on New
Enter Integration Manager as the name.
Under Authentication enable both User Credentials and Token-Based Authentication
Click Save
The page should display an Application ID column correlating to the name of an integration. If the column is blank then consult your NetSuite Rep for the App_id
Enter the Application ID into the Integration Manager WMS Setup page and click Save.

Get your adjustment account ID

The Adjustment Account ID is used when syncing inventory levels in NetSuite.

To use the default app account ID

Leave this setting blank in Integration Manager and we'll use the same Account ID as above.

To use a specific account ID

Go to Setup > Accounting > click on Chart of Accounts
Find the desired account to use and click on it. Look at the URL on the top screen.
The value is right after "acctid=" and before the next "&" sign. This should be a number.

Copy this value and enter it into the Integration Manager WMS Setup page.