Connect Webgility Desktop with NetSuite

10 Minutes Read

Virendra avatar
Written by Virendra
Updated over a week ago

Connect Webgility Desktop with NetSuite

Overview

In order to offer high-level security and authentication, NetSuite supports token-based authentication (TBA), which is a robust, industry standards-based mechanism that enhances the overall system security. This authentication mechanism enables client applications to use a token to access NetSuite through APIs, eliminating the need for RESTlets or web services integrations using stored user credentials.

In this case, you need to connect NetSuite with Webgility for which you need to have 5 key parameters before you can proceed with the integration process. The following are the key parameters that are required:

  • Account ID

  • Consumer Key

  • Consumer Secret

  • Token ID

  • Token Secret

The Account ID is already available and can be easily tracked from your NetSuite application, however, you need to generate the remaining 4 parameters. Once done, you can successfully proceed to connect NetSuite with Webgility.

This article consists of two procedures for NetSuite connections such as:

  • Setting up NetSuite TBA

  • Connecting Webgility with NetSuite

Overview of NetSuite TBA

NetSuite TBA (Token Based Authentication) setup comprises the following 4 steps:

  1. Enable TBA in your NetSuite account.

  2. Assign appropriate access permissions to an existing user (or create a new user).

  3. Generate the consumer Key and secret key for the Integration (Webgility).

  4. Generate the Access Token (token ID and token secret) for the Integration (Webgility).

Once you are done with the above steps, you can go ahead and successfully connect Webgility Desktop with NetSuite.

Steps to Setup TBA in NetSuite

1. Log in to your NetSuite account using your Super Admin credentials (user id & password).

2. In the NetSuite Home page, from the Setup menu, point to Company and then click Enable Features.

3. In the Enable Features screen:

A. Click SuiteCloud.

B. Under Manage Authentication, click TOKEN BASED AUTHENTICATION.

C. In the Terms and Conditions pop-up screen, click Accept.

The TOKEN BASED AUTHENTICATION checkbox gets selected.

D. Click Save to save the settings.

4. Manage Roles

A. Go to Setup> Users/Roles> Manage Roles> New.

B. Create a role and assign the necessary permission for SyncApps integration.

C. The role must have "User Access Tokens" permission for integration using TBA.

D. Add the following roles in Permissions> Transactions:

E. Add the following roles in Permissions> Lists:

F. Add the following roles in Permissions> setup:

NOTE 1:

If using the SOAP Web Services in Netsuite you will need to add that instead as seen below:

G. Assign the Role to the desired user that will be used for integration. Go to Lists> Employees> Employees> edit user> Access tab> Roles sub-tab.

5. To assign the Synch-App1 role for an existing user, from the Lists menu, point to Employees and then click Search.

Note: You can even create a new custom user role and assign it to an existing user.

In the Employee screen:

A. Search for the desired user to whom you want to assign appropriate access.

The complete information of the employee user gets displayed.

B. Click Edit and then click the Access tab.

C. From the Roles drop-down box, click Synch-App1 and then click OK.

D. Click Save to save the settings.

E. A conÕrmation message gets displayed notifying that the employee information has been successfully saved.

6. From the Setup menu, point to Integration and then click Manage Integrations to generate a Consumer Key and a Consumer Secret Key for Webgility Desktop integration.

Manage_Integrations.png

7. In the Integrations screen, click any existing integration component or create a new integration component.

Note: Click here to learn how to create a new integration component.

8. In the Integration screen:

A. Click Edit to edit the settings of the selected integration component.

Integrations_screen.png

B. From the STATE drop-down box, click Enabled and then Select (Enable) the TOKEN BASED AUTHENTICATION checkbox.

C. Click Save to save the settings.

Integration_screen.png

D. A confirmation message displays notifying that the integration has been successfully saved.

mceclip1.png

NOTE 2:

The Consumer Key and Secret Key are only displayed once. If you forget these values, you must regenerate (reset the credentials) and reconfigure the NetSuite.

9. From the Setup menu, point to Users/Roles > Access Tokens and then click New for generating a new access token (TokenID and Token Secret) for Webgility Desktop.

10. In the Access Token screen:

A. From the Application Name drop-down box, click to select the desired application name.

B. From the User field, click to select a user (either use the List or the Search option) to generate a token.

C. From the Role drop-down box, click Synch-App1.

D. The token name gets generated and displayed in the Token Name field.

20190627-tba-image.PNG

E. In the Confirmation screen, note the token ID and token secret key that gets generated. Copy these values temporarily to a text editor for future reference.

NOTE: The token ID and secret key are only displayed once. If you forget these values you will need to regenerate them and reconfigure in NetSuite. Hence, it is advisable to save these keys, so you can use them whenever required.

11. Connect with Webgility Desktop using these generated tokens:

  • Account ID

  • Consumer Key,

  • Consumer Secret,

  • Token ID,

  • Token Secret

NOTE: If you do not know how to locate your Account ID, follow the below steps as follows:

1. From the Setup menu, point to Integration and then click Web Services Preferences.

2. In the Web Services Preferences screen, you can locate your account ID under the Primary Information section.

Connect Webgility Desktop with NetSuite:

Now, we have all the required information in hand, the final step is to connect Webgility Desktop with NetSuite.

1. In the Connect to Accounting Software screen:

A. From the Use Existing/Add Accounting Company drop-down field, click New Accounting Company.

B. From the Select Accounting Software field, click NetSuite Inc. (US).

C. Type your account id corresponding to your NetSuite account in the Account ID field.

D. Under Authentication, click Token Based (Secured).

E. Type the consumer key, consumer secret, token id, and token secret that you had generated from NetSuite in the respective fields.

F. Click Connect to NetSuite.

G. Wait for the data to get downloaded and then click Continue.

You will be directed to the Order Processing Settings screen.

2. In the Order Processing Settings screen, enter the required values for the settings such as name, product code, location, and more, and then click Continue.

Did this answer your question?