Sync from NetSuite to Rydoo
Please keep in mind that the following is the only information we obtain from Netsuite and sync to Rydoo:
-
Categories
-
Employees
-
Supervisors (as approvers or controllers)
-
Groups
-
Tax Rates (legacy tax, SuiteTax)
-
Projects
The following Rydoo setup requires manual maintenance via Admin access:
- Branches (Subsidiaries)
- Roles
- Custom Fields
- Expense Rules
- Reject Reasons
- Mileage
- Second level approvers
Sync from Rydoo to NetSuite
- Sync reimbursable expenses
- Sync non-reimbursable expenses
Preparation
Always set up and test Netsuite integration in sandbox environment first before moving to production. Apply all steps in the sandbox and only move to production if all expected results were achieved and errors were fixed.
Step 1: Find your NetSuite account ID
The most obvious place is the address bar of your browser.
- Log in to your NetSuite account.
- Copy the portion we show in the picture below (everything before .app.netsuite.com)
- Alternatively, you can go to Setup > Integration > Web Services Preferences > copy the account ID to a text file
Step 2: Install Rydoo Expense Bundle
After you successfully copied your account ID, paste it into the NetSuite account ID field and hit the Install bundle button.
- This will load Search & Install Bundles page in NetSuite. Please, confirm bundle installation. The bundle is installed when you can see the green checkmark under Status.
If the Install bundle button didn't work for you, you may installRydoo Expense for NetSuite
differently:
-
Log into NetSuite as an administrator, go to Customization > SuiteBundler > Search & Install Bundles then search for "259729" which is the ID of our integration bundle. The name of the bundle should be 'Rydoo Expense for NetSuite'.
If you already have the bundle installed, navigate to Customisation > SuiteBundler > Search & Install Bundles > List ****and update it to the newest version.
Step 3: Enable SOAP WEB SERVICES and Token Based Authentication.
-
Go to Setup > Company > Setup Tasks > Enable Features > SuiteCloud
-
Manage Authentication > Enable “Token Based Authentication”
-
SuiteTalk (web Services) > "SOAP WEB SERVICES"
-
Refresh the page.
-
Add Rydoo WebServices role to an Admin User or create a new employee named, for example, 'Rydoo Integration' with Rydoo WebServices role assigned.
Best Practice: We recommend creating a new User in Netsuite dedicated to Integration instead of directly assigning the role to an actual Employee profile.
Step 4: Enable Expense Reports
-
Go to Setup > Company > Setup Tasks > Enable Features > Employees > Time & Expenses
-
Make sure 'Expense Reports' is enabled
-
If not - enable it and hit Save. Wait for the page to refresh.
Step 5: Create an Access Token
- Now navigate to Setup > Users/Roles > Access Tokens
- Click New Access Token
- Select the application name: Rydoo Integration (Xpenditure Integration), the integration user (make sure that the Employee is always active.)
If the employee does not have access. Go to the integration user's profile > Access > Roles > Rydoo WebServices. - Select the role Rydoo WebServices, then press save.
- Copy the token ID and token secret to a saved location on your computer. NetSuite only shows those one time.
- Copy and paste the Token ID and Token Secret in a text file.
Step 6: Find your Rydoo Expense Report ID
- Go to Customisation > Forms > Transaction Forms > Search for Rydoo Expense Report from bundle 259729
- Set as 'preferred', then copy and paste the Internal ID of the form in a text file.
Step 7: Send Netsuite Information to Rydoo
Save the text file with the following information:
-
Netsuite Account ID
-
Token ID
-
Token Secret
-
Rydoo Expense Report Internal ID
Send the text file to a Rydoo Integration Specialist (connect@rydoo.com) or to your dedicated CSM.
We will test the combination of given NetSuite credentials and will let you know if we have issues with authentication.
Failed authentication could mean a mistake in any of the fields or that the 'Rydoo Integration' user is set inactive in NetSuite.
Once Integration is successfully set up Rydoo Integration Specialist or CSM will contact you and you can proceed to the next steps.
Step 8: Set Up Subsidiaries in Rydoo as Branches
- In Netsuite, download the list of Subsidiaries by going to Setup > Company > Subsidiaries
List down the names of Subsidiaries and their Internal IDs. You can also export the data if preferred. Make sure that parent subsidiaries are skipped or deleted on the export file. Subsidiaries in Rydoo do not have parent-child relationships.
For example: Based on the screenshot below, we will only list down:
Honeycomb Mfg. – 1
Test sub – 4
Honeycomb Holdings Inc – 3 was not included because it is a parent Subsidiary. - Log in to your Rydoo account and go to Admin > Branches > Add Branch button.
- Enter Subsidiary names under Branch Name field
- Enter Internal IDs of Subsidiaries under Branch ID
It is important that the information Branch ID is identical to the subsidiary Internal IDs in Netsuite. Otherwise, integration will not work.
Confirm the branches in Rydoo (Admin > Branches) you want to link to your NetSuite subsidiaries have matching currencies.
Rydoo branch named "A" with currency EUR should be linked to the NetSuite subsidiary named "A" with base currency EUR.
If the currencies don't match, you won't be able to link the branch to your subsidiary. Adjust your branches until you have all branches with the correct currencies to be linked to NetSuite subsidiaries.
Step 9: Sync NetSuite with Rydoo
- In Rydoo, go to Admin > Integrations then choose Branches (Subsidiaries) that you want to sync and click Save.
- Click 'Sync your categories from Netsuite' button to sync your Categories from Netsuite.
- At the bottom of the page enable 'Test mode for employee syncing' checkbox. This will import all users as inactive so none of your employees will receive a 'Welcome to Rydoo' email before you are ready.
- Click 'Sync your employees for Netsuite' button to sync your Employees (and their Groups) from Netsuite.
REMINDER: For Supervisors, do not click the sync button yet.
Please follow these steps first:
- Select from the dropdown if Supervisors are to be synchronised as Approvers or Controllers
- Click Save
- After clicking Save, click the button to sync your Supervisors from Netsuite.
Check the following in Rydoo to ensure that information has been successfully synchronised from Netsuite:
-
list of Employees and Supervisors in Users Page (Admin > Users)
-
list of Groups in Groups Page (Admin > Groups)
-
list Categories in Categories Page (Admin > Categories)
CONGRATULATIONS!
If you encounter any issues contact your dedicated CSM for assistance or send a message to connect@rydoo.com.
Some More Instructions
Enable Expense Reports and Expense Categories in NetSuite
As Rydoo posts expenses to NetSuite Expense Reports, it is required to enable this feature.
- Log into NetSuite as an administrator
- Go to Setup > Company > Enable Features > Employees > Expense Reports
- If the checkbox next to Expense Reports is checked, you're done. If not, click the checkbox then click Save. Wait for the page to refresh.
Once Expense Reports are enabled you will be able to set Expense Categories.
- Log into NetSuite as an administrator
- Go to Setup > Accounting > Expense Categories. A list of Expense Categories would show up.
- Click on the
New
button to create a new category. You may limit the category to certain subsidiaries and Rydoo will respect this setting importing expense categories.
Setup different connection settings
You will need to decide how many different settings you will need. It depends on how different you want the integration to work for different subsidiaries/branches. If you want all of the branches/subsidiaries to sync the same information, you may just use one setting.
- Navigate to Integrations page: Admin > Integrations
- Select 'Add new setting'
- Set up Sync Preferences
- When done, hit
save
Click Run sync manually
to sync employees, departments, expense categories, and optional syncs you selected in the setting.
When the progress of synchronisation completes, you're done.
If you encounter any issues with data syncing, please review the Netsuite FAQ page and SOAP Web Services Usage Log article for more information.
In case you already have a Rydoo account and you are considering to use the NetSuite bundle, please reach out to your Rydoo Account Executive. You can find more information on the account migration process here.