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.
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.
| Category | Documented workflow coverage |
|---|---|
| Analytics Warehouse | Returns, inventory snapshots and trends, customer gross margin, and historical accounts receivable (AR) and accounts payable (AP) analysis |
| Demand Planning | Projected inventory balances, stockout and excess-inventory risks, late supply, demand exceptions, risk priorities, and recommended actions |
| Financial | Period narratives, margin analysis, budget-variance flags, working capital, and AR/AP insights |
| Fixed Assets | Asset analysis, general ledger reconciliation, depreciation forecasts, and capital planning |
| Item Configuration | Item creation and updates, plus revenue- and billing-schedule setup |
| Nonprofit | Budgets, 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 Management | Inspection results, nonconformance patterns, supplier risk, and corrective-action recommendations |
| Record to Report | Journal entries and intercompany journals with structured fields |
| SuiteBilling | Subscription-renewal pipelines, recurring revenue, churn risk, and follow-up priorities |
| Support | Case prioritization, escalation briefs, and customer-information requests |
| System Administration | Customization and dependency analysis, including keep, replace, or retire recommendations |
| Visualization | Dashboard-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 AuthorizationNetSuite - 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 component | Sample requirement |
|---|---|
| Current-month returns | Select 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 measure | Calculate Total Returns by Item Identifier using Line Amount in Analytics Currency from the Analytics Currency Amounts folder |
| Comparison period | Calculate previous-calendar-month returns using the same criteria |
| Ranking | Retain the top 10 items by current-month Total Returns in Analytics Currency, descending |
| Matching sales | Calculate 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 filters | Use 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?
How does the returns sample select items and compare returns with sales?
What time horizon and outputs does the Demand Planning risk review require?
Can the Demand Planning sample create or update plans or orders while reviewing risks?
Weekly Update History (1)
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 DocsWas this article helpful?
More in AI
- Prompt Studio: Generative AI Management in NetSuite 2026.1
Prompt Studio in NetSuite 2026.1 enhances generative AI management, enabling customization of prompts and Text Enhance actions.
- SuiteCloud Agent Skills for AI Development in NetSuite 2026.1
NetSuite 2026.2 adds AI Agent Plug-ins for business and SuiteCloud workflows, with platform support, role-based skills, and finance analysis.
- N/llm Module: Usage Limits and Additional Requests in NetSuite
In NetSuite 2026.1, the N/llm module sets usage limits and options for additional requests via Oracle Cloud.
- Required Features and Permissions for NetSuite AI Connector
Ensure Server SuiteScript and OAuth 2.0 are enabled for secure usage of the NetSuite AI Connector Service.
Also from NetSuite 2026.2
- Bank Matching and Reconciliation Enhancements in NetSuite 2026.2
Bank matching and reconciliation pages in NetSuite 2026.2 receive critical UI enhancements for improved transaction management.
- System Notes Enhancement for Reconciliation in NetSuite 2026.2
System notes enhancement tracks GL transaction events in NetSuite 2026.2, improving reconciliation auditing and review.
- SuiteCloud CLI License Acceptance for Automation
Set SUITECLOUD_CLI_ACCEPT_LICENSE=true to suppress the SuiteCloud CLI license prompt during scripted npm installation.
- NetSuite Next: Readiness, Preview, and Ask Oracle
Eligible administrators can request a NetSuite Next preview, set up Ask Oracle, and prepare data, roles, customizations, and navigation.
