Custom Reports and Filters in NetSuite MCP Tools v1.0.5

Starting in NetSuite 2026.1, the MCP Standard Tools SuiteApp version 1.0.6 introduces significant enhancements, particularly in reporting and data querying functionalities. These updates facilitate better data management and querying, especially for developers and administrators working with multiple subsidiaries.

What's New?

Support for Consolidated Reports

The tool ns_getSubsidiaries now includes functionality for individual, consolidated, and context subsidiaries. When you need to handle reports that consolidate data, negative internal IDs are used. This allows for:

• Consolidated Subsidiary Reports: Incorporate data from the main subsidiary and its children.
• Context Subsidiary Reports: Present data based on accessible child subsidiaries, formatted in the currency of the context subsidiary.

New SuiteQL Metadata Tool

A new tool, ns_getSuiteQLMetadata, is introduced to provide detailed metadata for SuiteQL-accessible NetSuite records. When specifying a record type, detailed metadata is returned; without a specification, a list of supported record types is provided. The ns_runCustomSuiteQL tool incorporates this to ensure valid query construction.

Additional Enhancements (Version 1.0.5)

The prior version of MCP Standard Tools, 1.0.5, included several notable enhancements, such as:

• Custom Reports Inclusion: The ns_listAllReports tool now returns custom reports.
• Subsidiary Filters in Reports: Introducing the subsidiaryId parameter in ns_runReport tool for subsidiary-specific report filtering.
• Currency Support: Reports adopt the currency of the selected subsidiary or base currency if no subsidiaries exist.

Who This Affects

These updates impact several roles and modules:

• Administrators and Developers: Benefit from enhanced reporting tools and SuiteQL capabilities.
• Multi-Subsidiary: Improved management of multiple subsidiaries in reporting.
• Multi-Currency: Better handling of currency in financial reports.

Key Takeaways

• New tools and enhancements improve reporting and query functionalities in NetSuite 2026.1.
• Consolidated and context subsidiaries are supported with new reporting features.
• The introduction of SuiteQL Metadata Tool facilitates efficient data querying.
• Version 1.0.5 also enhanced custom report inclusion and supports subsidiary filters.

These improvements underscore NetSuite's commitment to robust data management and integration capabilities, providing users with more flexibility and precision in managing complex business environments.