Report Tools
The report tools enable you to access and run NetSuite reports from your AI client. With these tools, you can retrieve a list of standard and custom reports and run any report that you have access to based on your current permissions. These tools support custom reports and most of the standard reports available in Standard Reports.
The following report tools are available:
|
Name |
Description |
|---|---|
|
Lists the subsidiaries in your NetSuite account you can use to filter results for reports with a subsidiary filter. |
|
|
Lists all standard and custom reports in your NetSuite account. |
|
|
Runs a report in your NetSuite account and displays the results. |
You can run reports that display data for individual, consolidated, or context subsidiaries.
-
The ns_getSubsidiaries tool returns a list of subsidiaries available in your NetSuite account. This list shows:
-
Positive internal IDs for individual subsidiaries.
-
Negative internal IDs for consolidated or context subsidiaries.
-
-
To run a report with the ns_runReport tool:
-
For an individual subsidiary, use its positive internal ID in the
subsidiaryIdparameter. -
For a consolidated subsidiary, use its negative internal ID in the
subsidiaryIdparameter. Reports for a consolidated subsidiary display data for the selected subsidiary and its child subsidiaries. -
For a context subsidiary (when you only have access to a child subsidiary but want to see its data in the currency of a parent or related context subsidiary), use its negative internal ID in the
subsidiaryIdparameter. Reports for a context subsidiary display data for any child subsidiary you have access to, in the currency of the selected context subsidiary.
-
For information about how consolidated reporting and subsidiary context work in the NetSuite UI, see Consolidated Reporting in OneWorld and Subsidiary Context for Reports.
Known Limitations of the Report Tools
The following are known limitations of the report tools:
-
Accounting periods are not supported. Currently, the report tools ignore the Report by Period user preference. The AI client won't be able to see the accounting periods that you have set up in your NetSuite account, and may use the calendar year as the fiscal year or ask you to provide more details about your fiscal year.
-
Only date and subsidiary context filters are supported when running the reports. Other filters or report footer options available in the UI are currently not supported by the report tools.
-
For accounts with one or more subsidiaries, the reports use the currency of the subsidiary selected in the report. For accounts without subsidiaries, the reports use the base currency set up on the Company Information page.
-
Report tools may return null values for reports that use column segmentation (that is, reports with multi-level or nested headers). This is a known limitation that affects reports such as the A/R Aging Summary and A/P Aging Summary, as well as other reports with similar column structure.