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

ns_getSubsidiaries

Lists the subsidiaries in your NetSuite account you can use to filter results for reports with a subsidiary filter.

ns_listAllReports

Lists all standard and custom reports in your NetSuite account.

ns_runReport

Runs a report in your NetSuite account and displays the results.

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

Related Topics

General Notices