NetSuite Changelog
GeneralSuiteAnalyticsReportsNew FeatureRelease Notes

NetSuite 2026.1: Support for Consolidated Reports and SuiteQL

New SuiteQL tool and consolidated reports enhance NetSuite 2026.1 reporting.

·2 min read·99 views·NetSuite 2026.1·View Oracle Docs

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.

Frequently Asked Questions (4)

Do I need to enable any specific feature to utilize consolidated reports in NetSuite 2026.1?
Yes, you need to ensure that the MCP Standard Tools SuiteApp is updated to version 1.0.6 to access the functionality for consolidated and context subsidiaries within reporting.
How does the SuiteQL Metadata Tool enhance the function of custom SuiteQL queries?
The SuiteQL Metadata Tool helps by providing detailed metadata for NetSuite records, ensuring that custom queries use valid fields and relationships, which improves the reliability of the data returned.
Can consolidated reports include subsidiaries not accessible to the user?
No, context subsidiary reports only show data from child subsidiaries accessible to the user, formatted in the currency of the chosen context subsidiary.
Is the new SuiteQL Metadata Tool available in all versions of NetSuite?
The SuiteQL Metadata Tool is introduced as a part of NetSuite 2026.1 and is available with the updated features of the MCP Standard Tools version 1.0.6.

Weekly Update History (4)

Integration SuiteAppsadded

Added an entry for Interactive MCP Apps and Report Tool Enhancements in MCP Standard Tools SuiteApp.

View Oracle Docs
Integration SuiteAppsadded

Added an entry for NetSuite AI Connector Service Companion SuiteApp.

View Oracle Docs
Integration SuiteAppsadded

Added an entry for Interactive MCP Apps and Report Tool Enhancements in MCP Standard Tools SuiteApp.

View Oracle Docs
Integration SuiteAppsadded

Added an entry for Support for Consolidated Reports and New SuiteQL Tool in MCP Standard Tools.

View Oracle Docs
Source: Support for Consolidated Reports and New SuiteQL Tool in MCP Standard Tools — Oracle NetSuite Help Center. This article was generated from official Oracle documentation and enriched with additional context and best practices.

Was this article helpful?

More in General

View all General articles →

Also from NetSuite 2026.1

View all NetSuite 2026.1 changes →