NetSuite Changelog
SuiteAnalyticsSuiteAnalyticsIntegrationMulti-SubsidiaryMulti-CurrencyRelease NotesNew Feature

SuiteQL Tool and Enhanced Reporting in NetSuite 1.0.6

NetSuite 2026.1 introduces consolidated and context subsidiary reporting with SuiteQL.

·2 min read·2 views·View Oracle Docs

Starting in NetSuite 2026.1, the MCP Standard Tools SuiteApp has introduced significant enhancements including support for consolidated and context subsidiaries in reporting and a new SuiteQL Metadata Tool. This update streamlines report generation and enhances data querying capabilities within your NetSuite environment.

Support for Consolidated and Context Subsidiaries in Reporting

The ns_getSubsidiaries tool now facilitates easier reporting across subsidiaries by returning individual, consolidated, and context subsidiaries. Here's what you need to know:

  • Individual subsidiaries are identified by positive internal IDs.
  • Consolidated and context subsidiaries are identified by negative internal IDs.

For reports with consolidation support, use the negative internal IDs with the ns_runReport tool. This allows you to generate reports that:

  • Include data from the selected subsidiary and its child subsidiaries (for consolidated subsidiaries).
  • Include data in the currency of the selected context subsidiary, scoped to accessible child subsidiaries (for context subsidiaries).

New SuiteQL Metadata Tool

A new tool, ns_getSuiteQLMetadata, provides metadata access for NetSuite records. You can query this tool by specifying a record type to retrieve its metadata. If unspecified, it returns a list of all supported record types. Integration with the ns_runCustomSuiteQL tool ensures queries only use valid fields and relationships, enhancing data integrity.

Who This Affects

  • Administrators: Streamline reporting processes across subsidiaries.
  • Developers: Increase efficiency and accuracy of SuiteQL queries.
  • Finance Teams: Gain enhanced insights through accurate consolidated reporting.

Key Takeaways

  • Introduces support for reporting on individual, consolidated, and context subsidiaries.
  • Includes a new SuiteQL Metadata Tool for enhanced data querying.
  • Integrates with existing tools to ensure report and query accuracy.
  • Targeted improvements for Admins, Developers, and Finance Teams.

Frequently Asked Questions (4)

What feature enables consolidated reporting across subsidiaries in NetSuite 1.0.6?
The ns_getSubsidiaries tool supports consolidated reporting using negative internal IDs for context and consolidated subsidiaries.
How does the SuiteQL Metadata Tool help in crafting queries?
The ns_getSuiteQLMetadata tool provides detailed metadata access for NetSuite records, helping to ensure that SuiteQL queries are error-free and align with NetSuite's relational data structures.
Can the SuiteQL tool validate queries before execution in NetSuite 1.0.6?
Yes, the ns_runCustomSuiteQL tool uses the ns_getSuiteQLMetadata tool to pre-validate queries, ensuring only valid fields and relationships are used.
Is the enhanced reporting feature applicable only to specific NetSuite editions?
The article does not specify limitations to certain NetSuite editions for the enhanced reporting feature introduced in version 1.0.6.

Weekly Update History (1)

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 SuiteAnalytics

View all SuiteAnalytics articles →