NetSuite 2026.1: Enhancements to Consolidated Reports and SuiteQL
NetSuite 2026.1 introduces new consolidated reports and SuiteQL tool for improved reporting and data integrity.
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?
How does the SuiteQL Metadata Tool enhance the function of custom SuiteQL queries?
Can consolidated reports include subsidiaries not accessible to the user?
Is the new SuiteQL Metadata Tool available in all versions of NetSuite?
Weekly Update History (4)
Added an entry for Interactive MCP Apps and Report Tool Enhancements in MCP Standard Tools SuiteApp.
View Oracle DocsAdded an entry for NetSuite AI Connector Service Companion SuiteApp.
View Oracle DocsAdded an entry for Interactive MCP Apps and Report Tool Enhancements in MCP Standard Tools SuiteApp.
View Oracle DocsAdded an entry for Support for Consolidated Reports and New SuiteQL Tool in MCP Standard Tools.
View Oracle DocsWas this article helpful?
More in General
- Email Notification Controls for Imports in NetSuite 2023
Email notification controls enhance NetSuite imports, improving alerts based on user preferences and permissions.
- Enhanced Commitment Credits for Flexible Billing in NetSuite
Commitment Credits in NetSuite SuiteBilling offer enhanced flexibility for usage-based billing across diverse services.
- Release Notes PDF Availability and Translations in NetSuite
NetSuite provides PDF files for each Release Note update, improving accessibility and user experience.
- New Parent Role Field for Custom Roles in NetSuite 2025.2
The new Parent Role field facilitates easier role management and visibility in NetSuite 2025.2 for administrators.
Also from NetSuite 2026.1
- Consigned Inventory Management in NetSuite 2026.1
Consigned inventory management in NetSuite 2026.1 enhances tracking and reporting for vendor consigned goods. Introduction
- Standard Roles and Permissions in NetSuite 2026.1
Explore standard roles and permissions in NetSuite 2026.1 for enhanced employee management and security. Introduction Introduction
- Prompt Studio: Generative AI Management in NetSuite 2026.1
Prompt Studio in NetSuite 2026.1 enhances generative AI management, enabling customization of prompts and Text Enhance actions.
- SuiteCloud Agent Skills for AI Development in NetSuite 2026.1
SuiteCloud Agent Skills enhance development workflows with AI-driven guidance in NetSuite 2026.1, improving automation and process standardization.
Advertising
Reach General Professionals
Put your product in front of NetSuite experts who work with General every day.
Sponsor This Category