Support for Consolidated Reports and SuiteQL Tool

Starting with the latest updates in NetSuite 2026.1, NetSuite enhances reporting capabilities with support for consolidated reports and introduces a new SuiteQL tool. These features enable users to leverage consolidated data and retrieve detailed metadata for records effectively.

How Does Support for Consolidated Reports Work?

The MCP Standard Tools SuiteApp (version 1.0.6) now includes functionality for consolidated and context subsidiaries within reporting. The tool ns_getSubsidiaries now returns both individual, consolidated, and context subsidiaries:

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

When generating reports that support consolidations, users can utilize these negative internal IDs with the ns_runReport tool:

• Consolidated Subsidiary Reports: These include data for the selected subsidiary and all child subsidiaries.
• Context Subsidiary Reports: These show data from any child subsidiary accessible to the user, formatted in the currency of the chosen context subsidiary.

For more information, see Report Tools.

What is the New SuiteQL Metadata Tool?

The new ns_getSuiteQLMetadata tool is a new addition that provides detailed metadata for NetSuite records accessible via SuiteQL. Users can specify a record type to retrieve specific metadata or omit it to list all supported record types.

Additionally, before executing custom SuiteQL queries with the ns_runCustomSuiteQL tool, this metadata tool ensures that all queries utilize valid fields and relationships, enhancing the reliability of data returned. For more information, see SuiteQL Tools.

Who This Affects

This enhancement will primarily benefit:

• Report Developers: Those creating and managing reports.
• Admin Users: Administrators overseeing subsidiary data and reporting functionalities.
• Business Analysts: Analysts requiring consolidated data for decision-making and analysis.

Key Takeaways

• Support for consolidated and context subsidiaries in reporting enhances data visibility.
• New SuiteQL tool allows access to detailed metadata for records.
• Improved data integrity and validation in custom queries aids in report generation.