Consolidated Reports and SuiteQL Tool Enhancements

Starting with the latest updates in NetSuite 2026.1, the MCP Standard Tools SuiteApp now offers significant enhancements, particularly in the handling of consolidated reports and the introduction of a new SuiteQL metadata tool. These enhancements improve reporting capabilities and metadata accessibility.

What’s New in MCP Standard Tools?

The MCP Standard Tools SuiteApp has been updated to version 1.0.6, introducing two major enhancements:

• Support for consolidated and context subsidiaries in reporting.
• A new SuiteQL metadata tool that expands metadata accessibility.

Additionally, MCP Standard Tools SuiteApp version 2.0.0 has introduced further enhancements, including new interactive MCP Apps and report tool updates.

Support for Consolidated and Context Subsidiaries in Reporting

The updated ns_getSubsidiaries tool now allows for more complex reporting. Here’s what it offers:

• Individual Subsidiaries: Displayed with positive internal IDs.
• Consolidated and Context Subsidiaries: Displayed with negative internal IDs.

When you use reports that support consolidation, you can leverage negative internal IDs with the ns_runReport tool to generate reports for consolidated or context subsidiaries:

• Consolidated Subsidiary Reports: Include data from the selected subsidiary and its child subsidiaries.
• Context Subsidiary Reports: Provide data for any child subsidiary accessible to the user, displayed in the currency of the selected context subsidiary.

For additional details, refer to the Report Tools.

New SuiteQL Metadata Tool

This new tool, ns_getSuiteQLMetadata, delivers detailed metadata for records accessed via SuiteQL. You can either specify a record type to receive its metadata or retrieve a list of all supported record types if none is specified. The ns_runCustomSuiteQL tool utilizes this metadata tool to validate fields and relationships before executing a custom SuiteQL query.

The ns_getSuiteQLMetadata tool ensures that the query uses only valid fields and relationships, thereby improving the robustness of querying metadata. Learn more in the SuiteQL Tools documentation.

Interactive MCP Apps and Report Tool Enhancements in MCP Standard Tools SuiteApp

MCP Standard Tools SuiteApp version 2.0.0 includes the following enhancements:

• New Interactive MCP Apps: Provides interactive UI components that support guided workflows and data selection.
• Report Tool Enhancements: Enhanced ns_runReport to support additional parameters and filtering options, as well as added support for report filters and column grouping.

For more information, see the Available MCP Apps in the MCP Standard Tools SuiteApp.

Who This Affects

The enhancements primarily affect:

• Administrators: Improved tools for managing subsidiaries.
• Developers: Enhanced options for implementing SuiteQL queries.
• Report Designers: Greater flexibility in creating consolidated reports.

Key Takeaways

• The ns_getSubsidiaries tool can now handle individual, consolidated, and context subsidiaries.
• Reports for consolidated and context subsidiaries utilize negative internal IDs.
• The new ns_getSuiteQLMetadata tool increases access to metadata for SuiteQL queries.
• User access to subsidiary data is determined by their role permissions.