​
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 “Integrations” tab.

  2. Click Connect to Netsuite from either the Invoicing section or Accounting section, depending on which integration you plan on using.

  3. Follow the instructions to connect NetSuite:

    1. Install the AccountLink NetSuite Bundle, and the AccountLink: Rev Rec Columns Bundle

      • Note: The AccountLink: Rev Rec Columns Bundle adds two custom fields to the netsuite instance in order to allow syncing start and end dates for invoice line items

      • If the direct link to install the Account Link: Rev Rec Columns Bundle is not working go to the Search & Install Bundles in Netsuite and Search for AccountLink: Rev Rec Columns Bundle.

    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 Integrations 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. It can take up to a few hours, depending on the amount of data in the connected NetSuite account.

  4. Configure the NetSuite integration

    1. Within the Integrations tab, go to either the Invoicing or Accounting section, depending on which integration you want to use, and click “Configure” in the NetSuite card.

    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.

    3. [Optional] Sync taxes to NetSuite. Taxes will be synced as a separate line item when using the NetSuite Accounting Sync. Select an external item to sync taxes to.

    4. If configuring Accounting sync, there will be an extra step to configure invoice accounting sync settings. If you already have customers in your accounting provider, map Orb customers to existing customer records before turning on the “Create customer records” setting, so that duplicate customer records are not generated in your accounting provider. You can enable this setting later if you are not ready to map customers. Instructions for mapping customers can be found here.

    5. [Optional] Map Orb items to their external item in NetSuite, then click “Save”. Mapping Orb items to items in NetSuite is required for Orb to sync invoices to NetSuite. This can be completed later if you are not ready to map items. Instructions for setting up items in NetSuite can be found here.

    6. While setting up customers and items in NetSuite, if data is missing in Orb, click the “Refresh” button to re-sync 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

  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

​
Setting up items in NetSuite

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.

​
Mapping items

There are two ways to map items:

Navigate to the Items tab in Orb under Settings, select an item, click “Edit” and select a NetSuite item.

Or, navigate to the Integrations tab in Orb under Settings, and in the NetSuite card, click the “Edit” button and go to the “Map items” step to view a list of all items and select NetSuite items for each.

​
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?

Go to Settings > Integrations tab > Accounting section 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.

​
Mapping NetSuite Invoice with Orb Invoice Number

You do not have to complete these steps for your invoicing to be synced to NetSuite, but for full feature parity we recommend you complete these instructions. Adding this custom field will allow for you to be able to see the Orb Invoice Number for a given NetSuite invoice.

​
Adding Custom Fields:

After logging in to your NetSuite account, please follow these instructions to add the necessary custom fields.

You can reach the “Add Custom Field Form” by hovering on Customization > Lists, Records, & Fields > Transaction Body Fields, then clicking on “New”

Please add the Orb Invoice Number field by filling out the form, then click “Save”:

  • LABEL: Orb Invoice Number

  • ID: _orb_invoice_number

  • OWNER: Your account name should automatically be listed here

  • DESCRIPTION: The identifying Number for the Orb generated invoice.

  • Applies To: Check only “Sale”

As invoices sync, you should see the Orb Invoice Number custom column on all invoices, and new invoices will have the field populated.

Was this page helpful?

QuickBooksBill.com