The following steps will lead you through the process of preparing your NetSuite environment to integrate with Tesorio and connecting to begin your data import.
Steps:
Prepare your NetSuite Environment
Enable Multi-Currency
Ensure that the currency permissions are set up properly for import into Tesorio. This is required even if you don’t have International requirements.
In NetSuite, navigate to Setup → Company → Enable Features → International.
Go to the International Section and ensure that the “MULTIPLE CURRENCIES” option is checked.
Save any changes.
Enable API Features
Ensure the SOAP Web Services, REST Web Services and Token-Based Authentication are enabled. Navigate again to Setup → Company → Enable Features. Find the tab bar at the top, click on the “SuiteCloud” tab and click to open or expand. In some instances of NetSuite, there may not be a tab bar but you may need to scroll down the page to find a SuiteCloud section.
Find the “SuiteTalk (Web Services)” section and ensure that the “SOAP WEB SERVICES” and “REST WEB SERVICES” options are checked.
Still within the “SuiteCloud” tab, find the “Manage Authentication” section and ensure that the “TOKEN-BASED AUTHENTICATION” option is checked.
Save any changes.
Navigate to the “Analytics” tab, find the “SuiteAnalytics Workbook” section, and ensure that the “SUITEANALYTICS WORKBOOK” option is checked.
Install the Tesorio NetSuite Bundle
Access the Search page by navigating to Customization → SuiteBundler → Search & Install Bundles.
Search for “Tesorio Bundle”. Click the option in the list that is listed as ““Bundle ID 180202, Version 1.11”.
Click “Install”, do not change the options on the screen.
In the Preview Bundle Install screen, press “Install Bundle” to start the process. Click “OK” if asked to confirm.
It may take a few minutes to install. The page you are redirected to, Installed Bundles, should list all bundles in your instance. The Tesorio Bundle will display a green checked status when it has completed installation.
Enable Subsidiary Access
If you have no subsidiaries, skip this step.
After the bundle installs, which can take a few minutes, edit the Tesorio Permissions Role to add access to all subsidiaries. Navigate to Setup → Users/Roles → Manage Roles.
Find the “Tesorio Permissions Role” and click Edit.
We advise that you select “All” under Accessible Subsidiaries. If you would like to send data to Tesorio only for certain subsidiaries, you can select only those subsidiaries that would like to sync into Tesorio.
Ensure the “WEB SERVICES ONLY ROLE” is not checked. This role cannot have this enabled as it will prevent RESTlet connections.
Click on Permissions Tab → Lists in the tab bar. Ensure that “Currency” is appearing on the list.
If Currency does not appear, please add Currency by entering “Currency” in the Search, adding it, and changing access to View.
If you have SuiteTax enabled, on the Permissions Tab → Lists, please change the Tax Details Tab access to Full
Click the Save button.
Create Integration User in NetSuite
Tesorio strongly recommend creating a unique user in NetSuite for configuring and maintaining the integration with Tesorio. Using an existing user account for this purpose may lead to disruptions in the sync if that user leaves your organization and their NetSuite account is deactivated.
By setting up a dedicated integration user, you ensure the continuity and reliability of the integration, regardless of changes in your team.
Apply the “Tesorio Permissions Role” to the user that will register with Tesorio. This can be any existing user, or you can create a dedicated user for the Tesorio integration (recommended).
Go to the employee record for this user by navigating to Lists → Employees → Employees.
Find the user in the list and click “Edit”.
NOTE: If you choose to create a new user, navigate to the Employee list, click “New Employee” and then complete the required fields (and email) first.
Click on the Access tab.
Make sure that “Give Access” is checked. Add a password for a new user if required.
Add the “Tesorio Permissions Role”, and click “Add”.
Click “Save” to ensure all changes on the page are saved.
Generate Token and Token Secret
Create a token by navigating to Setup → Users/Roles → Access Tokens → New.
From Application Name dropdown, select “Tesorio”, which is the application that was installed with the bundle.
From the User dropdown select the Registration user you created in the previous section.
From the Role dropdown select “Tesorio Permissions Role.”
The Token Name will be automatically generated as you fill out the other fields.
Click “Save”.
You will receive confirmation of the access token. Make note of the Token_id and Token_secret, as this information will need to be shared with Tesorio during the account registration process in the next step.
IMPORTANT: When you leave this page, you will not have access to this information again.
Locate Account ID
Additionally, you will need your NetSuite Account ID, which can be found by navigating to Setup → Integration → Web Services Preferences, and listed in the “Account ID” field.
NOTE: The “Account ID” for Sandbox environments must be entered using underscores and capital letters, not dashes and lowercase (Example: 12345_SB1).
Connect to Tesorio
Once your Tesorio account is created, you will receive a welcome email with a link to create your user account and begin the set-up process with Tesorio's Time to Connect.
Note: If you've already clicked the email link and are trying to get back to the Time to Connect screen to continue setup, log into Tesorio and click the link in the banner to be brought back to Time to Connect.
In Time to Connect, Navigate to Connect NetSuite to Tesorio and select See Details. Click Connect to NetSuite On the NetSuite registration screen and enter the token, token secret, and Account ID.
Click Connect to make the connection between your NetSuite account and Tesorio. Once connected, your data import will start.
While you're waiting for your data, you can being to configure your Tesorio account by navigating to Administration > Company Settings.