By Alex Rolnik

Netsuite Income Statement

Integrates with:

Netsuite is a popular ERP software for helping organizations organize and manage their e-commerce and transactional business processes. The Netsuite Income statement Kit combines data from 10 popular Netsuite ODBC reporting entities and outputs a table representing a generic income statement for your organization. Due to the nature of the Netsuite source, this Kit is intended to be a starting point for more customized report creation and specific reporting.

This Kit includes…

  • Data ingestion rivers for for the following entities:
    • Transactions
    • Transaction Lines
    • Accounts
    • Subsidiaries
    • Companies
    • Departments
    • Employees
    • Accounting Periods
    • Entity
    • Vendors
  • Logic that joins these entities together to recover values for total income across all customers and channels and accounts. You can find the full contents, data model documentation, and source fields here.

Configuring this Kit for use

Variables

In this Kit, there are two variables that are used to make for dynamic use of target configuration. 

  • {Dataset_Netsuite} is used in all Target configurations and queries as the target dataset ID.
  • {Netsuite_Alert_Group} is used as the alert email address(es) for when a river fails.
  • {gcs_file_zone} is used as the File Zone Bucket for all Google BigQuery Target configurations. This variable should already be populated in your Rivery account as long as a Google BigQuery connection has previously been created. 

Go to the Variables menu on the left side navigation bar and create variables for Dataset_Netsuite and Netsuite_Alert_Group. Then fill in the values as the Google BigQuery schema where you would like the data to land and the email address(es) to which you would like the failure emails sent.

Connections

Kits are imported with ‘blank’ source and target connections. In order to use the kit, you have two options:

  • Swap out blank connections with existing connections
  • Add credentials to the blank connections that come with the imported Kit

Have questions about this Kit?

Set up a meeting with a Rivery solutions engineer.

Time to Ride the River

Rivery is free to try - no credit card required.