Consolidated Reports and SuiteQL...

Starting with the latest updates, the MCP Standard Tools SuiteApp now offers significant enhancements, particularly in the handling of consolidated reports and the introduction of a new SuiteQL metadata tool. These enhancements improve reporting capabilities and metadata accessibility.

What’s New in MCP Standard Tools?

The MCP Standard Tools SuiteApp has been updated to version 1.0.6, introducing two major enhancements:

Support for consolidated and context subsidiaries in reporting.
A new SuiteQL metadata tool that expands metadata accessibility.

Support for Consolidated and Context Subsidiaries in Reporting

The updated ns_getSubsidiaries tool now allows for more complex reporting. Here’s what it offers:

Individual Subsidiaries: Displayed with positive internal IDs.
Consolidated and Context Subsidiaries: Displayed with negative internal IDs.

When you use reports that support consolidation, you can leverage negative internal IDs with the ns_runReport tool to generate reports for consolidated or context subsidiaries:

Consolidated Subsidiary Reports: Include data from the selected subsidiary and its child subsidiaries.
Context Subsidiary Reports: Provide data for any child subsidiary accessible to the user, displayed in the currency of the selected context subsidiary.

For additional details, refer to the Report Tools.

New SuiteQL Metadata Tool

This new tool, ns_getSuiteQLMetadata, delivers detailed metadata for records accessed via SuiteQL. You can either specify a record type to receive its metadata or retrieve a list of all supported record types if none is specified. The ns_runCustomSuiteQL tool utilizes this metadata tool to validate fields and relationships before executing a custom SuiteQL query.

Learn more in the SuiteQL Tools documentation.

These enhancements overall improve reporting sophistication and make querying metadata more robust, ultimately supporting better data access and management capabilities.

Who This Affects

The enhancements primarily affect:

Administrators: Improved tools for managing subsidiaries.
Developers: Enhanced options for implementing SuiteQL queries.
Report Designers: Greater flexibility in creating consolidated reports.

Key Takeaways

The ns_getSubsidiaries tool can now handle individual, consolidated, and context subsidiaries.
Reports for consolidated and context subsidiaries utilize negative internal IDs.
The new ns_getSuiteQLMetadata tool increases access to metadata for SuiteQL queries.
User access to subsidiary data is determined by their role permissions.

Source: This article is based on Oracle's official NetSuite documentation.

Frequently Asked Questions (4)

How can I include custom reports in my reporting workflow using the latest MCP Tools SuiteApp?

In MCP Tools SuiteApp version 1.0.6, custom reports can now be accessed using the `ns_listAllReports` tool, allowing you to better manage and customize your reporting needs directly within NetSuite.

Is it necessary to provide a subsidiary ID when running reports for multi-subsidiary accounts?

Yes, if your report includes a subsidiary filter and your account manages multiple subsidiaries, providing a `subsidiaryId` is mandatory when using the `ns_runReport` tool for more precise data analytics.

How does the new `ns_getSubsidiaries` tool help with subsidiary management?

The `ns_getSubsidiaries` tool provides a list of all subsidiaries in your account, simplifying the selection for report filtering and is especially beneficial for administrators needing quick access to subsidiary data.

What is the role of the `ns_getSuiteQLMetadata` tool in constructing SuiteQL queries?

The `ns_getSuiteQLMetadata` tool offers detailed metadata for NetSuite records accessible with SuiteQL, ensuring valid fields and relationships are used in custom SuiteQL queries before they are executed.

Consolidated Reports and SuiteQL Tool Enhancements in