Support for Consolidated Reports and SuiteQL Tool in

Starting with the latest updates, 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 now includes functionality for consolidated and context subsidiaries within reporting. This means that the tool ns_getSubsidiaries returns both individual and consolidated subsidiary data:

• 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.

What is the New SuiteQL Metadata Tool?

The 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.

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.

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