NetSuite AI Connector Companion Prompt Samples

Explore 14 Companion prompt categories, plus the source requirements and analysis boundaries in Analytics Warehouse and Demand Planning examples.

·5 min read·34 views·NetSuite 2026.2·View Oracle Docs

The NetSuite AI Connector Service Companion SuiteApp supplies editable prompt samples across 14 business categories to help users get started with the NetSuite MCP Standard Tools SuiteApp. Its Analytics Warehouse and Demand Planning examples show why source requirements, calculation filters, and limits on record changes matter when adapting a sample.

What Does the Companion Provide?

The Companion organizes example prompts by business function and suggested role. Samples include raw prompt text that users can copy and update to fit their needs. Treat each example as a starting specification: preserve its data requirements and analysis boundaries when changing the business question.

Related reading: AI Connector Companion SuiteApp guide and Companion plugins, skills, and tools overview.

The supplied documentation describes the prompt catalog but does not establish when these samples were introduced. It also does not provide an installation path or permission matrix.

Which Business Workflows Have Prompt Samples?

The catalog covers 14 categories. Choose the category closest to the business question before adapting its raw prompt text.

CategoryDocumented workflow coverage
Analytics WarehouseReturns, inventory snapshots and trends, customer gross margin, and historical accounts receivable (AR) and accounts payable (AP) analysis
Demand PlanningProjected inventory balances, stockout and excess-inventory risks, late supply, demand exceptions, risk priorities, and recommended actions
FinancialPeriod narratives, margin analysis, budget-variance flags, working capital, and AR/AP insights
Fixed AssetsAsset analysis, general ledger reconciliation, depreciation forecasts, and capital planning
Item ConfigurationItem creation and updates, plus revenue- and billing-schedule setup
NonprofitBudgets, forecasts, grant spending, program performance, cash outlooks, and financial summaries
Order to Cash (Customer Management)Customer creation and updates, sales orders, invoices, open-invoice reviews, and customer statements
Procure to Pay (Vendor Management)Vendor setup, purchase order and bill monitoring, approvals, and Automated Clearing House (ACH) and check payment runs
Quality ManagementInspection results, nonconformance patterns, supplier risk, and corrective-action recommendations
Record to ReportJournal entries and intercompany journals with structured fields
SuiteBillingSubscription-renewal pipelines, recurring revenue, churn risk, and follow-up priorities
SupportCase prioritization, escalation briefs, and customer-information requests
System AdministrationCustomization and dependency analysis, including keep, replace, or retire recommendations
VisualizationDashboard-like stylized HTML or charts and scenario summaries

What Must the Analytics Warehouse Returns Sample Check?

The Analytics Warehouse – Returns Analysis sample suggests the Chief Financial Officer role. The documentation also calls NetSuite Analytics Warehouse NetSuite Data Intelligence.

This example specifies the OAC MCP connector, not a dataset. Before analysis, it requires confirmation that both subject areas are available:

  • NetSuite - Order to Cash - Return Authorization
  • NetSuite - Sales Order

If either is unavailable, the prompt directs the response to identify the missing subject area and explain that it must be activated or made available in OAC. It prohibits substituting a dataset or different subject area without telling the user.

Analysis componentSample requirement
Current-month returnsSelect item lines where Return Authorization - Is Created From Sales Order equals 'T'; exclude records where Return Authorization - Main Line or Return Authorization - Tax Line is not 'F'
Returns measureCalculate Total Returns by Item Identifier using Line Amount in Analytics Currency from the Analytics Currency Amounts folder
Comparison periodCalculate previous-calendar-month returns using the same criteria
RankingRetain the top 10 items by current-month Total Returns in Analytics Currency, descending
Matching salesCalculate current-month sales for the same Item Identifiers using Transaction Lines – Analytics Currency Amounts; exclude records where Sales Order - Main Line, Sales Order - Tax Line, or Sales Order - Do Not Display Line is not 'F'
Monthly filtersUse Gregorian Calendar Year and Month Number, not Time.Date

These details define the comparison: current-month returns determine the item selection, and sales are then calculated for those same items. Changing the ranking period or item selection would change the requested analysis.

Source limitation: The supplied excerpt ends mid-sentence while defining the output table. It does not support reconstructing the complete column list. Consult the full sample before adopting its output specification.

How Does the Demand Planning Sample Bound Its Analysis?

The Demand Planning Exception & Inventory Risk Review sample suggests the Controller role and examines the next 90 days. It requests live NetSuite demand-planning, inventory, open-order, and supply data only. It prohibits generating sample data and creating or modifying plans, purchase orders, or work orders.

The sample first requests inspection of available demand plan, item, location, inventory balance, sales order, purchase order, transfer order, and work order fields. It then requests records needed to calculate projected available balance, demand, supply, lead time, reorder point, safety stock, and days of supply by item and location.

The review covers projected stockouts, excess inventory, late supply, demand spikes, items below safety stock, and open demand threatened by insufficient supply or lead time. Prioritization uses estimated revenue exposure, margin exposure where available, and days until the expected exception.

Requested deliverables are:

  • Executive KPIs.
  • A 90-day inventory-risk timeline.
  • The top 20 exceptions, with recommended actions.
  • A location-by-location summary.
  • Stated filters and assumptions, with calculated risk clearly distinguished from confirmed inventory shortages.

When adapting this sample, keep the recommendation step separate from the prohibited record changes. Also preserve the qualification that margin exposure is used where available, rather than assuming every risk can be ranked on that measure.

Who This Affects

  • CFOs: The Warehouse returns sample offers a specified approach to monthly returns and matching sales analysis.
  • Controllers: The Demand Planning sample defines an exception review with a 90-day horizon and prioritized recommendations.
  • Other business users: The catalog provides starting points for financial, operational, nonprofit, billing, support, and reporting workflows.
  • Administrators: The System Administration category covers customization analysis, dependencies, and keep, replace, or retire recommendations.

The two detailed examples name suggested roles; the supplied material does not establish role-based access requirements.

Key Takeaways

  • The Companion supplies editable prompts across 14 business categories.
  • Warehouse returns analysis specifies its connector, subject areas, line filters, comparison periods, and top-10 ranking.
  • Demand Planning requests a 90-day review with 20 prioritized exceptions and prohibits specified record changes.
  • Preserve source requirements and distinguish calculated inventory risk from confirmed shortages when adapting the samples.

Frequently Asked Questions (4)

Which data sources and filters does the Analytics Warehouse Returns sample require?
The sample specifies the OAC MCP connector and requires both the `NetSuite - Order to Cash - Return Authorization` and `NetSuite - Sales Order` subject areas. It applies specified main-line, tax-line, and do-not-display-line filters, uses Analytics Currency Amounts for calculations, and filters months by Gregorian Calendar Year and Month Number rather than `Time.Date`.
How does the returns sample select items and compare returns with sales?
It ranks items by current-calendar-month returns in descending order and retains the top 10. It then calculates previous-month returns and current-month sales for those same Item Identifiers, so changing the ranking period or selected items changes the requested analysis.
What time horizon and outputs does the Demand Planning risk review require?
The sample reviews the next 90 days and requests executive KPIs, an inventory-risk timeline, the top 20 exceptions with recommended actions, and a location-by-location summary. It also asks for filters and assumptions to be stated and calculated risk to be distinguished from confirmed inventory shortages.
Can the Demand Planning sample create or update plans or orders while reviewing risks?
No. The sample calls for live NetSuite demand-planning, inventory, open-order, and supply data, and prohibits generating sample data or creating or modifying plans, purchase orders, or work orders. Recommendations should remain separate from those prohibited record changes.

Weekly Update History (1)

NetSuite AI Connector Serviceadded

Added categories and prompt samples in Available Prompt Samples in the NetSuite AI Connector Service Companion SuiteApp. Examples include inventory risk reviews, grant spending analysis, and subscription renewals.

View Oracle Docs
Source: Available Prompt Samples in the NetSuite AI Connector Service Companion SuiteApp — Oracle NetSuite Help Center. This article was generated from official Oracle documentation and enriched with additional context and best practices.

Was this article helpful?

More in AI

View all AI articles →

Also from NetSuite 2026.2

View all NetSuite 2026.2 changes →