Skip to content
  • There are no suggestions because the search field is empty.

NetSuite Setup

Setup should only take 5-10 minutes

⚠️ NOTE

There may be fees associated with setting up a new data connection. Contact your account team to confirm pricing.

Pre-Implementation

You must have full administrator access in NetSuite, including the ability to set up users and role permissions, to establish the connection with BUCS. 

Configuration Steps in NetSuite

This section covers the following steps that must be taken from NetSuite before moving forward with connection in the BUCS platform:

  1. Create a New Role in NetSuite
  2. Create a BUCS Analytics Employee in NetSuite
  3. Create an Integration
  4. Create a Token
  5. Enable REST Web Services

Create a New Role in NetSuite

Create a new role for the BUCS Analytics user with list and view permissions to all modules in NetSuite.     

 1. Go to Setup > Users/Roles > Manage Roles > New.
bucs-netsuite-data-connection-setup-02-create-a-new-role-in-netsuite  

2. In Name field, enter  BUCS Analytics.

 

3. Under the Authentication section, ensure the WEB SERVICES ONLY ROLE is not selected.

4. Go to the Transactions tab under Permissions. Select Find Transaction from the dropdown menu, change Level to Full and click Add. You may need to work with the BUCS team and provide additional permissions depending on the datasets you want to integrate. 

bucs-netsuite-data-connection-setup-05-create-a-new-role-in-netsuite

5. Go to the Reports tab under Permissions and confirm the SuiteAnalytics Workbook level is set to Edit.

6. Go to the Lists tab under Permissions and click Add after selecting each of the following from the dropdown and changing the Level to Full: Accounts, Classes, Currency, Customers, Employee Record, Employees, Items, Locations, Subsidiaries (if applicable), and Vendors. 

bucs-netsuite-data-connection-setup-07-create-a-new-role-in-netsuite

7. Go to the Setup tab under Permissions and click Add after selecting each of the following from the dropdown and changing the Level to Full: Access Token Management, Accounting Lists, Custom Body Fields, Custom Columns Fields, Custom Entity Fields, Custom Event Fields, Custom Fields, Custom Items Fields, Custom Item Number Fields, Custom Lists, Custom Record Types, Custom Transaction Fields, Deleted Records,  Log in using Access Tokens, Manage Accounting Periods, Other Custom Fields, REST Web Services, SOAP Web Services, Records Catalog, SOAP Web Services, Set Up Company, User Access Tokens.

bucs-netsuite-data-connection-setup-08-create-a-new-role-in-netsuite        

8. Click Save to create the BUCS Analytics role.

Create a BUCS Analytics Employee in NetSuite

Create the employee and give them access to the BUCS Analytics role you created per the instructions in the section above.

1. Go to Lists > Employees > Employees > New.

bucs-netsuite-data-connection-setup-09-create-a-bucs-analytics-employee-in

2. Enter the following user details:

  • Custom Form: Enter Standard Employee Form
  • Name: Enter BUCS Analytics
  • Email Address: Enter the email address of the person managing the BUCS Analytics data connection
3. If your company has multiple companies/subsidiaries, select the appropriate subsidiary from the Subsidiary dropdown under the Classification section.

bucs-netsuite-data-connection-setup-10-create-a-bucs-analytics-employee-in

4. Click on the Access tab and select the Give Access box. Either select the Send New Access Email box or select the Manually Assign or Change Password to complete password setup for the BUCS Analytics employee.   

bucs-netsuite-data-connection-setup-11-create-a-bucs-analytics-employee-in        

5. Under the Roles tab, select the BUCS Analytics role you created and click Add.

bucs-netsuite-data-connection-setup-12-create-a-bucs-analytics-employee-in

6. Click Save to create the BUCS Analytics employee.

Create an Integration 

1. Go to Setup > Integrations > Manage Integrations > New.

bucs-netsuite-data-connection-setup-13-create-an-integration

2. Enter BUCS Analytics Integration for the name and confirm the State is set to Enabled.

bucs-netsuite-data-connection-setup-14-create-an-integration

3. Under the Authentication tab, ensure TOKEN-BASED AUTHENTICATION is the only item selected. De-select boxes for any items in the Token-based Authentication and OAuth 2.0 sections.
bucs-netsuite-data-connection-setup-15-create-an-integration           
4. Click Save. 

bucs-netsuite-data-connection-setup-16-create-an-integration

The Consumer Key and Consumer Secret will appear at the bottom of the page. Copy and retain both of these values before leaving the page. They will be required in the BUCS Connection Wizard per the instructions in the section below,

⚠️ IMPORTANT

These credentials will not be displayed after leaving the page. If you lose or forget the credentials, you will need to generate a new ones. 

bucs-netsuite-data-connection-setup-18-create-an-integration

Create an Access Token

1. Go to Setup > Users/Roles > Access Tokens > New.

bucs-netsuite-data-connection-setup-19-create-an-access-token

2. Select the BUCS Analytics Integration you created from the Application Name dropdown. If you skipped this step, return to the section above for instructions. 

bucs-netsuite-data-connection-setup-20-create-an-access-token

3. Select the BUCS Analytics employee you created from User dropdown and BUCS Analytics from the Role field. These are the user and role you created previously. 

bucs-netsuite-data-connection-setup-21-create-an-access-token

4. Click Save.      

bucs-netsuite-data-connection-setup-22-create-an-access-token

The Token ID and Token Secret will appear at the bottom fo the page. Copy and retain these values before leaving the page. They will be required when using the BUCS Connection Wizard for setup in the section below. 

⚠️ IMPORTANT

These values will not be displayed after leaving the page. If you lose or forget these values, you will have to generate new ones. 

bucs-netsuite-data-connection-setup-24-create-an-access-token

Enable Rest Web Services

1. Go to Setup > Company > Enabled Features.
bucs-netsuite-data-connection-setup-25-enable-rest-web-services
2. Go to the Analytics tab and confirm the KPI SCORECARDS and SUITEANALYTICS WORKBOOK boxes are selected.            bucs-netsuite-data-connection-setup-26-enable-rest-web-services

3. Click on the SuiteCloud tab.
bucs-netsuite-data-connection-setup-27-enable-rest-web-services
          
4. Scroll down to the SuiteTalk (Web Services) section and confirm the REST WEB SERVICES box is selected.


Implementation Steps in BUCS

1. Go to BUCS Customer Portal > Connection Management > Connection Hub.

2. Locate or search for the NetSuite connector and click Connect.bucs-netsuite-data-connection-setup-29-create-a-netsuite-connection-in-bucs            
3. Enter a name for your connection and click Next. The connection name should be descriptive and specific to the connection. bucs-netsuite-data-connection-setup-30-create-a-netsuite-connection-in-bucs
            
4. Enter the Consumer Key, Consumer Secret, Token ID, and Token Secret values you copied from the previous configuration steps and enter your NetSuite Account ID.  If you skipped these steps, go back to the Integration and Access Token sections. 

💡 TIP

You can find your NetSuite Account ID by logging into NetSuite and viewing the numeric code at the beginning of the URL. 

bucs-netsuite-data-connection-setup-31-create-a-netsuite-connection-in-bucs

5. Click Save. 

bucs-netsuite-data-connection-setup-32-create-a-netsuite-connection-in-bucs

A Connection Established message will appear if the connection was successful and data from NetSuite will continuously sync to BUCS. If the connection was not successful, you will be prompted to try again.

🗒️ NOTE

It may take up to 24 hours for NetSuite data to appear in the BUCS platform.