• item (required) -- Item reference: {"id": "<internal_id>"}
• quantity (required) -- Units to order (non-negative)
• rate -- Unit price (optional if item has default pricing)
• amount -- Total line amount (alternative to rate)
• taxcode -- Tax code reference: {"id": "<internal_id>"} (required if SuiteTax enabled)
• description -- Line item notes

Example:

Tool: NETSUITE_CREATE_SALES_ORDER
Arguments:
  entity: {"id": "1234"}
  item: {
    "items": [
      {"item": {"id": "56"}, "quantity": 10, "rate": 25.00},
      {"item": {"id": "78"}, "quantity": 5, "rate": 50.00}
    ]
  }
  tranDate: "2026-02-11"
  memo: "Q1 bulk order"
  orderStatus: "B"

2. Run SuiteQL Queries

Execute ad-hoc SQL queries against NetSuite data with server-side paging.

Tool: NETSUITE_RUN_SUITEQL_QUERY

Key Parameters:

• q (required) -- SuiteQL SELECT statement
• limit -- Rows per page (default varies)
• offset -- Zero-based index of first row (must be a multiple of limit)

Examples:

Tool: NETSUITE_RUN_SUITEQL_QUERY
Arguments:
  q: "SELECT id, companyname, email FROM customer WHERE isinactive = 'F' ORDER BY companyname"
  limit: 100
  offset: 0

Tool: NETSUITE_RUN_SUITEQL_QUERY
Arguments:
  q: "SELECT id, entitystatus, total FROM transaction WHERE type = 'SalesOrd' AND trandate >= '2026-01-01'"
  limit: 50

3. Create and Manage Customers

Create new customer records with subsidiary assignment and contact details.

Tools:

• NETSUITE_CREATE_CUSTOMER -- Create a new customer
• NETSUITE_GET_CUSTOMER -- Retrieve customer by internal ID
• NETSUITE_UPDATE_CUSTOMER -- Update existing customer (PATCH semantics)

Key Parameters for NETSUITE_CREATE_CUSTOMER:

• body (required) -- JSON object with customer data. Required fields:
  • subsidiary -- Object with id (subsidiary internal ID)
  • Either companyName (for businesses) or firstName + lastName (for individuals)
  • Optional: email, phone, isPerson (set to "T" for individuals), comments
• replace -- Comma-separated sublist names to fully replace (e.g., "contacts,addressbook")

Example:

Tool: NETSUITE_CREATE_CUSTOMER
Arguments:
  body: {
    "companyName": "Acme Corp",
    "subsidiary": {"id": "1"},
    "email": "[email protected]",
    "phone": "555-0100"
  }

4. Upsert Records by External ID

Create or update records idempotently using an external identifier. Essential for sync workflows.

Tool: NETSUITE_UPSERT_RECORD_BY_EXTERNAL_ID

Key Parameters:

• record_type (required) -- Record type name, e.g., "customer", "salesorder", "customrecord_myrec"
• external_id (required) -- External ID value (letters, numbers, underscore, hyphen only)

…

jobnimbus-automation

通过 Rube MCP 自动执行 Jobnimbus 任务与流程操作，提升业务处理效率。

Zoho Books Automation

用自然语言自动处理 Zoho Books 的发票、账单、付款与联系人流程