NetSuite AI Connector Service Enhancements in Version 1.0.6

TL;DR

Starting in NetSuite version 1.0.6, the AI Connector Service introduces significant enhancements, including new tools and updated functionalities aimed at optimizing how developers can interact with NetSuite data. These changes enable improved querying and reporting capabilities, enhancing the overall user experience.

What's New in Version 1.0.6

The MCP Standard Tools SuiteApp, designed to integrate with the NetSuite AI Connector Service, has been updated to include the following enhancements:

New Tools

ns_getSuiteQLMetadata: This tool retrieves detailed metadata for NetSuite records that can be accessed with SuiteQL. It includes available fields, data types, descriptions, nullability, and joinable fields. When called without a specific record type, it returns a list of all supported record types. This tool is essential for ensuring that SuiteQL queries reference only valid fields and relationships, thus preventing errors.

Updated Features

Available Tools List: The MCP Standard Tools SuiteApp and SuiteQL Tools have been updated to include ns_getSuiteQLMetadata among the available tools.
Report Tools Enhancements: Improvements now allow users to run reports for both consolidated and context subsidiaries, providing a more comprehensive view of the data.
Subsidiary Queries: The ns_getSubsidiaries function now indicates that returned lists display positive internal IDs for individual subsidiaries, while negative internal IDs are used for consolidated or context subsidiaries.
Reporting Enhancements: The ns_runReport function's subsidiaryId parameter now accepts negative internal IDs for reports designed to support consolidation, expanding the reporting capabilities.

Tool Accessibility and Permissions

The MCP Standard Tools SuiteApp is built to work alongside existing NetSuite roles and permissions, ensuring that users only access the data and actions permitted by their roles. For comprehensive access control:

Review user roles assigned the MCP Server Connection permission. This permission allows users to create and update records via the AI client and REST Web Services.
It is advisable to create a specialized role for the MCP Server Connection if more granular access control is needed. Specific permissions can be assigned to regulate which records and actions are permissible through the AI client.

Before adopting the new features, it’s crucial to ensure that your organization’s roles and permissions align with the enhancements introduced in version 1.0.6.

Who This Affects

Administrators: Responsible for managing user roles and permissions related to the AI Connector Service.
Developers: Users looking to leverage natural language queries via the AI client for enhanced data interactions.
Accountants: Those who will benefit from improved reporting features for financial data analysis.

Key Takeaways

Version 1.0.6 introduces significant enhancements to the NetSuite AI Connector Service.
The new ns_getSuiteQLMetadata tool aids in querying by providing detailed record metadata.
Updated functionalities allow for improved reporting on consolidated and context subsidiaries.
Permissions management is essential for leveraging the full capabilities of the AI Connector Service effectively.