NetSuite

Query and Update NetSuite with an AI Agent: SuiteQL and Record Writes over MCP

Let Claude run SuiteQL against NetSuite, create or update journal entries, vendor bills and more, and report on NetSuite beside QuickBooks — with per-user permissions.

Jose R. Gonzalez, CPA

Jose R. Gonzalez, CPA

Updated · 2 min read

Short answer

ERP Sync connects NetSuite to AI agents through MCP. The agent can run read-only SuiteQL queries, create, update or delete individual records (journal entries, vendor bills, checks, deposits, vendor payments, customers, vendors and more) through NetSuite’s REST API, and read NetSuite’s synced ledger in the same reports as your QuickBooks companies.

Query and Update NetSuite with an AI Agent: SuiteQL and Record Writes over MCP

What ERP Sync does with NetSuite

  • Read-only SuiteQL queries against a connected company, with guidance to filter by subsidiary on OneWorld accounts.
  • Create, update or delete one record at a time through NetSuite’s REST record API — journal entries, vendor bills, checks, deposits, vendor payments, vendor credits, accounts, vendors, customers, items, classes and departments. The subsidiary is filled in automatically on create.
  • Full and incremental sync of the NetSuite ledger into ERP Sync, so NetSuite entities sit in the same balance sheet, income statement, aging and Excel reports as QuickBooks Online entities.
  • An optional SuiteScript bundle pushes record saves and deletes to ERP Sync for faster change detection.

What to ask your AI agent

With ERP Sync connected to Claude, ChatGPT, or another MCP-capable agent, requests like these work as written:

Using SuiteQL, list vendor bills over $10,000 posted in September for the US subsidiary.
Create a journal entry in NetSuite moving $3,000 of rent from Corporate to the West region department.
Show the September income statement for the NetSuite subsidiary next to the two QuickBooks companies.

The ERP Sync tools behind it

These are the MCP tools an agent calls. Each one is switched on or off per user, and read-only versus read-write is set per feature.

ToolWhat it does
ns_queryRuns read-only SuiteQL against a connected NetSuite account.
ns_writeCreates, updates or deletes a single NetSuite record.
erp_gl_balance_sheet / erp_gl_income_statementReads synced NetSuite statements alongside other entities.

Limits and requirements

  • Writes are one record per call.
  • On OneWorld accounts, the connection covers the whole account; queries should filter by subsidiary, and master records are shared across subsidiaries.
  • Installing the SuiteScript bundle is optional and takes a NetSuite admin about 30–60 minutes.

Frequently asked questions

Does the agent get my NetSuite admin rights?

No. It works through ERP Sync’s tools, and each ERP Sync user is set to off, read-only or read-write for NetSuite independently.

See it on your own books

A 30-minute call is enough to know whether ERP Sync fits. Bring the task you're tired of doing by hand.