...
As a partner, our innovative, cloud-based Time and Expense software integrates directly with NetSuite to make your Time and Expense reporting processes easier. Improve your bottom line with the power and flexibility you need to streamline your labor, project and expense reporting processes.
...
Integration Mapping
...
NetSuite Setup
Setup user, lists employee – new;
To give access rights you need to click on edit then access and then add roles.
Setup Company
Click on setup, company ,
Enable features ; suite cloud ; make sure CLIENT SUITESCRIPT and SERVER SUITESCRIPT are checked
Make sure CREATE BUNDLES WITH SUITEBUNDLER is checked under
SuiteBundlerWEB SERVICES under SuiteTalk (Web Services) is checked
Create NetSuite Web Service Application ID
Click on the setup – integration and then new. Under authentication, you need to check user credentials and/or token-based authentication (dependent on client preference)
Create DATABASICS post application.
Once the DATABASICS application is installed in NetSuite, the DATABASICS team will configure DATABASICS AgentHub and NetSuite Service WebServices Module to connect with NetSuite.
To get the Account ID from NetSuite, go to Web Services Preferences:
...
Install DATABASICS application in NetSuite
Install; go to customization and then type in DATABASICS in the keywords and pull the DATABASICS app from the app store.
...
2. Click the Install button, and then install bundle
3.Once installed, you will see the DATABASICS menu item; go to DATABASICS setup
4. Configure Setup
...
WebService Account with Token
To get the Account ID from NetSuite, go to Company Information:
...
Ensure the company is enabled for SOAP WEB SERVICES & REST WEBSERVICES.
Setup → Company --> Enable Futures ---> go to tab SuiteCloud--> go down Enable SOAP WEB SERVICES and REST WEBWERVICES
...
2. Setup a Web Service Role to access Manage Roles under Setup and setup a role for Web Service User that you will use.
...
3. Setup a user and assign the user to the role that was created in the above step.
Setup the Consumer Key: Go to Setup--> Integration --> Integration Management --> Create Integration Record and that is where we get the CONSUMER KEY and CONSUMER SECRET.
Make sure to check Check TOKEN-BASED AUTHENTICATION and uncheck OAuth 2.0 for
Call it DATABASICS
Make sure to save the information in safe place.
NOTE: You get an Application ID from the Integrations list.
Create Access Token ID and Secret: Setup--> User/Roles --> Access Token--> We create a token for the Integration Record and select the WEB Service User created in the above steps.
Setup--> User/Role --> Access Token--> We create a token for the Integration Record.
TOKEN ID
TOKEN SECRET
Make sure to save the information in safe place.
Customer ID - will be provided by DATABASICS
...
NOTE: Always reference NetSuite documentation.
Viewing, Editing, Creating, and Revoking TBA Tokens
You can see a list view of tokens in your system.
To view tokens:
Go to Setup > Users/Roles > User Management > Access Tokens
The Access Token page displays.
Actions you can take from this page include:
Click View to open the Access Token page and review the details of a specific token.
Click New Access Token to open the Access Token page and create a new token.
Click Edit to open the Access Token page and:
Edit specific details about the token, or
Click Revoke to revoke the token.
Open the Filters panel to select a value for Revoked status (All, Yes, or No).
Click Search at the top right corner of the Access Tokens page.
Regenerating a Consumer Key and Secret in NetSuite
If you no longer have the consumer key and secret for an integration record that was created in your NetSuite account, you can regenerate them. Be aware that when you reset these credentials, the old ones are invalidated.
At the same time, even after you reset the consumer key and secret, you can still use a token and token secret that were created with the original consumer data. But they must be used with the new consumer key and secret.
If the record was installed in your account through bundling, you cannot reset the credentials. The credentials can be reset only by an authorized user in the NetSuite account where the record was create
To regenerate a consumer key and secret:
...
Go to Setup > Integration > Manage Integrations.
...
Select the record for which you want to generate a new consumer key and secret.
The record opens in view mode.
...
Click the Edit button.
...
Click the Reset Credentials button.
The system displays a popup message asking if you are sure you want to reset the credentials.
Click OK.
...
Setup Connectors
With the NetSuite Client ID, the DATABASICS team will configure DATABASICS MiniService Connectors and dbNetSuitePostService to Post Time, Expense, GL and AP to NetSuite.