NetSuite AI Connector Guide: MCP Setup & Use Cases

Oracle NetSuite has long been a cloud-based enterprise resource planning (ERP) platform for small to medium-sized businesses. However, its website UI is infamous for its steep learning curve, click-heavy navigation, and rigid reporting structures.

With the recent release of the NetSuite AI Connector Service, users can leverage the Model Context Protocol (MCP) and AI (Artificial Intelligence) Assistants to directly ask questions in plain language and get real-time answers from their financial and operational data.

How the NetSuite MCP AI Connector Works

NetSuite’s MCP exposes a suite of tools to the AI, such as running SuiteQL queries, reading Saved Searches and reports, or executing record operations like creating a new customer record. All tools are governed by NetSuite’s native role-based permissions.

When a user asks a question in plain language, the AI uses the Model Context Protocol (MCP) to translate the request into structured operations that NetSuite understands. NetSuite executes the operations using the user's permissions, and the results are returned to the AI for analysis and presentation.

NetSuite AI Connector Setup Guide

1. Enable Server SuiteScript and REST Web Services
   1. Go to Setup > Company > Enable Features.
   2. On the SuiteCloud subtab:
      • Under SuiteScript, check the Server SuiteScript box.
      • Under SuiteTalk (Web Services), check the REST Web Services box.
   3. Click Save.
2. Install the NetSuite MCP Standard Tools first. Click on Customization > SuiteCloud Development > SuiteApp Marketplace.
3. Search for NetSuite MCP Standard Tools.
4. Once it is installed, you will see the status 'Installed' on the right.
5. Follow the same instructions to install the 'NetSuite AI Connector Service Companion'.
6. Set up an Integration Record
   1. Go to Setup > Integration > Manage Integrations.
   2. Create an Integration Record for ChatGPT, and we will come back with the actual token_id:
7. Create a custom role for MCP with the minimum permissions and assign it to users. e.g.,

How to Integrate NetSuite MCP with ChatGPT

1. Click on 'Settings'.
2. Click on 'Apps' > 'Advanced settings'.
3. Turn on 'Developer mode', then click on 'Create app'.
4. Enter the details. For Connection, enter https://<account_id>.suitetalk.api.netsuite.com/services/mcp/v1/all.
5. Click on 'Create'. Once it is integrated, you will see the following popup.
6. Click on 'Sign in with NetSuite MCP'.
7. Click the 'Continue' button to grant permissions.

How to Integrate NetSuite MCP with Claude AI

1. Click on 'Customize'.
2. Click on 'Connect your apps'.
3. Search for 'NetSuite'.
4. Click on 'NetSuite' and enter the server URL: https://<account_id>.suitetalk.api.netsuite.com/services/mcp/v1/suiteapp/com.netsuite.mcpstandardtools. Replace <account_id> with your actual account ID.
5. Click the 'Continue' button.
6. Click 'Continue' to authenticate the connector.

NetSuite AI Use Cases

Use Case in ChatGPT: Show overdue invoices over 30 days in NetSuite

• ChatGPT created the SuiteQL query and ran it. This is very handy and saves a lot of time compared to creating a report using the NetSuite website UI.

Use Case in ChatGPT and Claude: Can you draw the sales of the last 30 days in a line graph?

• ChatGPT wasn't able to generate the line graph.
• I tried on Claude, and it worked. The difference may be due to the large language model capabilities.

Use Case in Claude: Create a customer record

• Double-checking the NetSuite website UI confirms the record was created.
• Running it in ChatGPT shows the record is available:

Use Case in Claude: Run SuiteQL Query

• The SuiteQL query can be executed directly.

Final Thoughts on the NetSuite AI Connector

The biggest win in using MCP is for users who are not technical enough to create complex reports. These users can use plain language to query the data and ask the AI to present the report exactly the way they want.

To prevent prompt injection attacks and the misuse of 'write' operations, only grant write permissions to certain records and transactions. When the AI uses MCP to update or create a record, it executes this as server-side SuiteScript, which completely bypasses any client-side scripts or form validations.

Reference:

• Installing the MCP Standard Tools SuiteApp
• NetSuite AI Connector Service FAQ
• Connect to the NetSuite AI Connector Service