Skip to main content

Connecting to Netsuite

Prerequisites

  1. NetSuite account
  2. Sufficient administrator settings in your NetSuite instance to install bundles and enable SuiteCloud features

Connecting NetSuite with Orb

  1. In the sidebar of the Orb dashboard, click on "Settings", then click on the "Connections" tab.
  2. Follow the instructions to connect NetSuite:
    1. Install the AccountLink NetSuite Bundle, and the AccountLink: Rev Rec Columns Bundle
      • Note: You need to install both bundles for revenue recognition data to work
    2. Enable SuiteCloud features as listed
    3. Confirm setup
    4. Upon clicking Save, you should now see NetSuite as a connection at the top of the Connections tab with status “Sync in progress”
    5. Once existing data from NetSuite is synced and ready to be used by Orb, the status of the connection will show up as “Configuration required”. Until then, the connection cannot be used in Orb.
  3. Configure the NetSuite integration
    1. In the connections table, click the overflow menu for the NetSuite connection and click "Configure NetSuite"
    2. Select a subsidiary and a default bank account to connect your Orb account to. You will need to select a bank account per currency that you support in Orb.

While setting up customers and items in NetSuite, if data is missing in Orb, click the “Refresh” button to resync data from NetSuite. Orb also periodically updates data from NetSuite.

Setting up RevRec schedules

Orb syncs line item service periods so you can perform accurate revenue recognition in NetSuite. To enable this:

  1. In NetSuite, navigate to the Revenue Field Mapper
  2. Map Rev Rec Start Date and Rev Rec End Date to Start Date and End Date respectively

image.png

  1. Navigate to Revenue Recognition Rule, and create a new rule
    1. Specify the Rev Rec Start Date Source and Rev Rec End Date Source to the data that we mapped in the previous step

image.png

Mapping items

Mapping items to items in NetSuite is required for the integration to succeed. If you do not map items, Orb will not be able to sync invoices to Netsuite. In NetSuite, create items corresponding to items you are selling in Orb. When creating the item, in the Revenue Recognition/Amortization tab, select the Revenue Recognition Rule and Rev Rec Forecast Rule that you created in the above step.

image.png

Then, navigate to the Items tab in Orb under Settings, and select a NetSuite item for each Orb item.

image.png

Testing NetSuite

Connect a NetSuite sandbox account to Orb in Test mode. While testing RevRec, syncing invoices does not automatically update revenue arrangements in Netsuite. To force update the revenue arrangement within NetSuite, in Update Revenue Arrangements and Revenue Plans, click Refresh, Update Revenue Arrangements, and then Update Revenue Plans.

Using Orb for Invoicing?

Finish setting up the accounting sync connection by going to Settings > Accounting tab to configure the sync. For more information on sync settings and details go here.

Using Netsuite as an external invoicing provider?

Setup the Invoicing Integration

Finish setting up the invoicing provider by mapping customers.

Configuring customers

After item mapping has been completed the last step for the invoicing provider is to create or update customers in the Orb UI or through the API.

When creating or updating customers in the Orb UI, select NetSuite as the Payment Provider in order to view a list of previously created customers in your NetSuite account.

Customer mappings can also be configured in the API, by passing in the customer’s NetSuite ID under payment_provider_id, and setting payment_provider to netsuite. The customer’s NetSuite ID can be found by navigating to the customer’s page in NetSuite, and copying the ID from the URL (e.g. https://<>.app.netsuite.com/app/common/entity/custjob.nl?id=1613&whence=, where 1613 is the ID)

Once mappings are configured, invoices for customers with a NetSuite payment provider ID will be synced to NetSuite.