# Oracle NetSuite MCP for AI Agents AI Agent Connect

> Oracle NetSuite MCP for AI Agents. Manage your financials, sales orders, and inventory records directly through your AI client. This connection lets you query G/L account balances, post journal entries, and track purchase orders without clicking through the NetSuite dashboard. It handles the heavy lifting of record management so you can focus on high level analysis.

## Overview
- **Category:** industry-titans
- **Price:** Free
- **Endpoint:** https://edge.vinkius.com/vk_preview_rsObfCyEQmTdqnE2TGr81cx6rumQdWKS51SFjrVv/ai-agent-connect
- **Tags:** cloud-erp, financial-reporting, sales-orders, inventory-management, business-automation, procurement

## Description

You're tired of tab-switching between your ERP and your communication tools. This Connector changes that by letting your AI agent act as a direct interface for your Oracle NetSuite account. Instead of hunting through menus to find a specific sales order or digging through nested reports to see a subsidiary's balance, you just ask. You can have your agent pull a trial balance, create a new purchase order, or update a customer's credit limit in a single turn. It handles the complex stuff like SuiteQL queries and saved searches too, meaning your agent can actually see the data you need to make decisions. It's part of the Vinkius catalog, which makes it easy to plug into your existing workflow so you can stop doing the manual data entry that eats up your afternoon. You can manage financials, sales orders, and inventory without the usual friction of a web interface. Controllers can get revenue breakdowns, and procurement leads can track vendor bills in a conversational format that actually moves the needle. It turns your ERP into a searchable database that responds to your questions in real time. You get to spend less time on data entry and more time on the actual strategy of your business. This is about getting to the numbers faster and making fewer mistakes in the process.

## Tools

### delete_record
Remove a record from your NetSuite account when it's no longer needed. Use this action only when you are sure the data is no longer required.

### list_customers
Quickly see a list of all customers stored in your NetSuite account. This helps you browse your customer base without navigating deep menus.

### get_record
Fetch a specific record like a customer, vendor, or invoice to see its current details. This is useful for quickly viewing a single record without searching.

### update_record
Change specific fields on existing records without having to edit the whole thing. This makes it easy to update contact info or credit limits on the fly.

### execute_suiteql
Run advanced SQL-like queries against any NetSuite record type to get specific data. It allows you to pull complex datasets using SELECT and JOIN functions.

### create_record
Generate new entries like sales orders or journal entries using a JSON body. You can use this to automate the creation of new records in your ERP.

### list_records
Pull a list of records by type, such as listing all current customers or employees. It provides a high level view of your data by category.

### list_sales_orders
Get a list of recent sales orders to check on fulfillment status. It is a fast way to see what is pending in your sales pipeline.

### get_record_metadata
See what fields are available for a record type before you try to create or update it. This helps you understand the data structure of your specific account.

## Prompt Examples

**Prompt:** 
```
Show me the revenue breakdown by subsidiary for March 2026.
```

**Response:** 
```
### Revenue by Subsidiary (March 2026)

| Subsidiary | Revenue | MoM Change |
| :--- | :--- | :--- |
| US Operations | **$2,340,000** | +12% |
| EU Operations | **€1,150,000** | +8% |
| APAC | **¥89,500,000** | +15% |

**Total Consolidated Revenue:** $4,120,000

Would you like me to drill down into any specific subsidiary?
```

**Prompt:** 
```
Find all customers with overdue invoices above $10,000.
```

**Response:** 
```
I found **12 customers** with overdue invoices exceeding $10,000:

*   **GlobalTech Inc** — $45,200 (32 days overdue)
*   **Pinnacle Corp** — $28,750 (18 days overdue)
*   **Summit Holdings** — $22,100 (45 days overdue)
*   *(10 more records found)*

**Total Overdue Amount:** $312,400

Would you like me to generate a collections follow-up list for these accounts?
```

**Prompt:** 
```
Create a sales order for customer 'CUST-1045' with 100 units of item 'SKU-2024-A' at $45 each.
```

**Response:** 
```
✅ **Sales Order SO-2026-04567 created successfully!**

*   **Customer:** CUST-1045
*   **Item:** SKU-2024-A
*   **Quantity:** 100
*   **Unit Price:** $45.00
*   **Total:** $4,500.00
*   **Status:** Pending Fulfillment

Would you like me to check stock availability or generate the pick ticket?
```

## Capabilities

### Query financial balances
Get G/L account totals and trial balances across different subsidiaries.

### Create sales orders
Generate new orders with specific items, quantities, and customer details.

### Track purchase orders
Monitor receipt statuses and match vendor bills to your POs.

### Update customer records
Modify contact info or credit limits on your customer master data.

### Run SuiteQL queries
Execute advanced SQL-like commands to pull specific, complex datasets.

### Check inventory levels
See real-time stock counts across multiple warehouse locations.

## Use Cases

### Overdue Invoice Audit
A controller asks for all customers with overdue invoices over $10k. The agent uses list_records to find them and presents a summary table.

### Rapid Order Entry
A sales rep asks the agent to create a sales order for 100 units of a specific SKU. The agent uses create_record to make it happen instantly.

### Inventory Check
A warehouse manager asks for stock levels of a top-selling item. The agent uses list_records to provide a real-time count across three warehouses.

### Custom Reporting
An admin needs a specific breakdown of revenue by subsidiary. The agent uses execute_suiteql to run the query and summarize the results.

## Benefits

- Stop manual data entry by using create_record to generate sales orders and journal entries from plain text.
- Get instant answers on stock levels by using list_records to check inventory across all locations.
- Speed up month-end closing by using execute_suiteql to pull complex financial data without manual exports.
- Keep customer data clean by using update_record to change credit limits or contact info in seconds.
- Reduce tab fatigue by using list_customers and list_sales_orders to view records without navigating the UI.

## How It Works

The bottom line is you get a conversational interface for your entire ERP without leaving your chat window.

1. Connect your Oracle NetSuite account using your TBA credentials in your AI client.
2. Grant the Connector permission to read and write to your specific record types.
3. Ask your agent to perform tasks like List all overdue invoices or Create a new PO.

## Frequently Asked Questions

**Can the Oracle NetSuite MCP create new sales orders?**
Yes, it can create sales orders, purchase orders, and journal entries directly. You just tell your agent what to create and it handles the record generation.

**How do I use Oracle NetSuite MCP for financial reports?**
You can ask your agent to pull trial balances or run specific SuiteQL queries. It will fetch the data and summarize the key figures for you.

**Can I update customer information with this Connector?**
Yes, you can use it to update customer master data, including contact details and credit limits. It only changes the specific fields you tell it to.

**Does the Oracle NetSuite MCP work with my existing saved searches?**
Yes, your agent can execute your saved searches to pull pre-filtered datasets. This is great for getting complex data quickly.

**Can I check my inventory levels using the Oracle NetSuite MCP?**
You can ask the agent to check stock levels by location. It will pull the current inventory records and give you a clear count.

**Is the Oracle NetSuite MCP safe for my financial data?**
The Connector uses your existing NetSuite TBA credentials. It only performs the actions you specifically ask it to do through your AI client.

**What credentials do I need for NetSuite authentication?**
You need 5 values for Token-Based Authentication (TBA): Account ID, Consumer Key, Consumer Secret, Token ID, and Token Secret. All are generated within your NetSuite account under Setup > Integration.

**Can I run custom SuiteQL queries?**
Yes. The `execute_suiteql` tool executes SQL-like queries against the SuiteQL endpoint. You can query any record type, join tables, and use aggregation functions — all through natural language that the agent translates to SuiteQL.

**Does it support NetSuite saved searches?**
Absolutely. Use the `run_saved_search` tool with the saved search ID to retrieve its results. This works with any existing saved search in your account — transactions, customers, items, or custom records.

**Can I create sales orders through the agent?**
Yes. The `create_record` tool with the `salesOrder` record type lets you create full sales orders with line items, pricing, shipping addresses, and payment terms — all through conversation.