Consolidated Reports and SuiteQL Tool in NetSuite 2026.1

Starting in NetSuite 2026.1, the MCP Standard Tools SuiteApp version 1.0.6 introduces significant enhancements, including support for consolidated reports and a new SuiteQL metadata tool. These features enable better visibility and reporting capabilities for consolidated and context subsidiaries, as well as providing developers with robust tools for accessing record metadata.

What's New

Support for Consolidated and Context Subsidiaries in Reporting

The ns_getSubsidiaries tool has been upgraded to return a comprehensive list of subsidiaries, which now includes:

• Individual Subsidiaries: Display positive internal IDs.
• Consolidated/Context Subsidiaries: Display negative internal IDs.

This update specifically benefits reporting strategies where consolidated data is required. With this new functionality, users can efficiently run reports that aggregate data for:

• Consolidated Subsidiaries: Includes data for the selected subsidiary along with its child subsidiaries.
• Context Subsidiaries: Displays data for any child subsidiary you have access to, using the currency of the selected context subsidiary.

You can utilize the ns_runReport tool to run reports effectively by leveraging these new subsidiary identifier formats.

New SuiteQL Metadata Tool

Alongside the improvements in reporting, a new tool named ns_getSuiteQLMetadata has been introduced. This tool enhances SuiteQL functionalities by allowing developers to:

• Retrieve detailed metadata for NetSuite records accessible via SuiteQL.
• Specify a particular record type for focused metadata retrieval.
• If no record type is provided, the tool lists all supported record types.

The ns_runCustomSuiteQL tool will now call ns_getSuiteQLMetadata before executing custom SuiteQL queries, ensuring that all fields and relationships within queries are valid and will minimize errors in execution.

For additional details regarding the MCP Standard Tools SuiteApp, please refer to the relevant documentation.

Who This Affects

These enhancements will primarily benefit:

• Developers: Accessing granular metadata and efficiently customizing reports based on subsidiary structures.
• Administrators: Overseeing subsidiary data and report configurations across the organization.
• Financial Analysts: Generating consolidated financial reports and analyzing multi-subsidiary data for insights.

Key Takeaways

• NetSuite 2026.1 adds support for consolidated and context subsidiaries in reporting.
• New SuiteQL metadata tool streamlines access to record-related data.
• Enhanced reporting capabilities improve decision-making through better data insights.
• Developers can validate SuiteQL queries with the updated tools to prevent errors in execution.