> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://zuora.ferndocs.com/docs/platform/integration/integration-hub/advanced-connectors/revenue-connector-for-netsuite-erp/configurations-in-netsuite-erp/set-up-transactional-datasets/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://zuora.ferndocs.com/_mcp/server.

# Set up transactional datasets for Revenue connector for NetSuite

> Learn how to set up transactional datasets for the Revenue connector for NetSuite ERP.

Learn how to set up transactional datasets for the Revenue connector for NetSuite ERP.

Navigate to **Analytics** menu, and then click the **DataSets** tab.

Create **New DataSet**.

Select the transaction object.

Enter the dataset name and description.

Optionally, if you want to add a custom name, enter the dataset ID.

Select the fields from the **Transaction** and **Transaction Line** objects.

Drag and drop the fields that are part of Netsuite Sales Order transactions that you want to map with the fields of the Orders template in Zuora Revenue.

Save your entries.

Click the **Dataset** columns and change the **Alias** (display labels) to what gets displayed in the Connector Field Mapping UI.

You can set up and select the fields based on the use case requirements in NetSuite. See [Sample dataset for Revenue Connector for NetSuite](/docs/platform/integration/integration-hub/advanced-connectors/revenue-connector-for-netsuite-erp/configurations-in-netsuite-erp/set-up-transactional-datasets/sample-dataset-for-revenue-connector-for-netsuite).

Click the **DataSet** columns link to see all the columns that are part of the dataset results.

> **Note**
>
> You can define filter criteria in the Dataset UI to filter out certain transactions from the resulting Dataset, such as transactions updated in last 24 hours, last 1 week, or transactions from specific subsidiary.

Repeat steps for other transactional datasets, such as Invoices and Credit Memos.

Configure functions and formulae on the fields in the Netsuite Datasets to derive specific field or attribute values.

Complete configurations in Zuora Revenue. See [Set up API user in Revenue](/docs/platform/integration/integration-hub/advanced-connectors/revenue-connector-for-netsuite-erp/configurations-in-zuora-revenue/set-up-api-user-in-revenue).

> Learn how to set up transactional datasets for the Revenue connector for NetSuite ERP.

## Docs

- [Sample dataset for Revenue Connector for NetSuite](https://zuora.ferndocs.com/docs/platform/integration/integration-hub/advanced-connectors/revenue-connector-for-netsuite-erp/configurations-in-netsuite-erp/set-up-transactional-datasets/sample-dataset-for-revenue-connector-for-netsuite.md): This topic provides a sample list of NetSuite Sales Order Lines fields.