Netsuite agent

The Netsuite agent is for the general ledger and connects your Netsuite system directly to FP&A Plus or Financial Planning and Analysis, and securely and automatically pulls your financial data, such as balance sheets and income statements directly from NetSuite using its SuiteTalk API.

The Netsuite agent is ideal for organizations that:

  • Use NetSuite as their financial system of record.
  • Want to automate the flow of general ledger data into Prophix.
  • Need to generate timely and accurate financial reports without manual data entry.
  • Require drill-down capabilities for variance and trend analysis.

By using this agent, you can:

  • Reduce the risk of errors from manual data handling.
  • Save time by automating recurring data pulls.
  • Improve decision-making with up-to-date financial insights.

What you can do

Once configured and connected, you can begin pulling data into Prophix and using it in your financial models and reports.

You can perform the following tasks:

  • Test the connection: verify that Prophix can successfully connect to your NetSuite environment using the credentials and settings you’ve provided.
  • Configure integration settings, such as:
    • Reporting year (current or previous)
    • Task limits
    • Account structure for separating balance sheet and profit and loss data
  • Import financial data:
    • Opening balances: pull starting balances for balance sheet accounts at the beginning of a fiscal year or selected period.
    • Balance sheet: retrieve the latest summarized balance sheet data.
    • Profit and loss (P&L): retrieve summarized income statement data.
  • Create financial reports: generate formatted balance sheet entries in a structure compatible with Prophix; you can also apply default dimension values if needed.
  • Drill across for transaction details:
    • Initialize drill across: prepare the system to extract detailed transactional data for variance or trend analysis.
    • Fetch drill-across data: retrieve the transactional data using task identifiers, which help manage large data sets.
  • Run custom queries:
    • Initialize custom query: submit your own SuiteQL query and define the columns you want to extract.
    • Fetch custom data: retrieve the results of your custom query, with support for incremental data pulls.

Prerequisites

To set up the integration, you’ll need to provide connection details from your NetSuite account. These include:

  • Your NetSuite account ID
  • Authentication tokens (provided by your NetSuite administrator)
  • The base URL for NetSuite’s SuiteTalk API

Add a connection

To add a connection for a Netsuite agent:

  1. In the navigation panel, select Admin Setup.
  2. Select a text agent or peer connection, and click > Add Connection.

  3. Connection Name must be unique. Up to 40 characters.

     Note:  All the parameters listed below are required; none have character restrictions.

  4. Suite Talk Base URL: The REST API URL used to query NetSuite's SuiteQL services

    For example: https://[realm].suitetalk.api.netsuite.com/services/rest/query/v1/suiteql

  5. Customer Key: A public key used in conjunction with the customer secret to sign OAuth 1.0a requests.
  6. Customer Secret: A private secret paired with the customer key to authenticate API requests.
  7. Token ID: A unique identifier for a token created in NetSuite for API access.
  8. Token Secret: The confidential token associated with the Token ID. Both are used for secure OAuth 1.0a authentication.
  9. Realm: Your NetSuite account ID (also referred to as account ID or realm) which is required to uniquely identify your instance.

  10. Method: The HTTP method used for SuiteTalk REST API calls. For example: GET or POST. This typically stays consistent depending on the query type.

  11. Click Verify Credentials.
  12. Click Save.

Add a query

  1. Select a Netsuite connection or peer query, and click > Add Query.
  2. Query name: Must be unique. Up to 40 characters.

  3. From Query type, select an option:

    • 1.1 Test Connection

      Verifies that the connection to the NetSuite SuiteTalk API is working correctly using the provided authentication tokens and base URL

    • 1.2 Set Integration Settings

      Stores integration-specific parameters like task limits, reporting year (current or previous), and account structure for Balance Sheet/Profit and Loss separation.

    • 2.1 Balance Sheet Opening Balances

      Retrieves opening balances for balance sheet accounts at the start of a selected fiscal period or year.

    • 2.2 Balance Sheet

      Retrieves the latest summarized balance sheet data from NetSuite.

    • 2.3 P&L

      Retrieves summarized income statement (Profit and Loss) data.

    • 3. Create Balance Sheet

      Generates formatted balance sheet entries in Prophix-compatible structure with optional dimension defaults.

    • 4.1 Drill Across – Initialize

      Prepares the system to extract detailed transactional data for variance and trend analysis across multiple periods.

    • 4.2 Drill Across – Fetch Data

      Fetches transactional data previously initialized, using task identifiers for pagination and large dataset handling

    • 99.1 Custom Query – Initialize

      Accepts user-defined SuiteQL queries and column names to configure a custom extract request.

    • 99.2 Custom Query – Fetch Data

      Executes and retrieves the data from the SuiteQL custom query, supporting incremental fetch with task identifiers.

  4. Click Save.