Netsuite Income Statement
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
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 used
Configuring this kit for use
Variables
In this Kit, there are two variables that are used to make for dynamic use of target configuration. {db_netsuite_odbc} is used in all Target configurations and queries as the target database name.
{schema_netsuite_odbc} is used in all Target configurations and queries as the target schema name.Go to the Variables menu on the left side navigation bar and create variables for db_netsuite and schema_netsuite. Then fill in the values as the Snowflake database and schema where you would like the data to land.
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 KitHave questions about this kit?
Set up a meeting with a Rivery solutions engineer.
Additional Considerations
This template is intended as a starting point for creating more customized reports in Netsuite. It is not intended for compliance with any tax, audit, legal, or regulatory requirements.
