NetSuite Automation

NetSuite Automation

Automate Oracle NetSuite ERP operations including creating customers and sales orders, running SuiteQL queries, upserting records by external ID, and inspecting record metadata for comprehensive business management.

Toolkit docs: composio.dev/toolkits/netsuite

Setup

This skill requires the Rube MCP server connected at https://rube.app/mcp.

Before executing any tools, ensure an active connection exists for the netsuite toolkit. If no connection is active, initiate one via RUBE_MANAGE_CONNECTIONS.

Core Workflows

1. Create Sales Orders

Create customer orders with line items including item references, quantities, and pricing.

Tool: NETSUITE_CREATE_SALES_ORDER

Key Parameters:

• entity (required) -- Customer reference: {"id": "<internal_id>"}
• item (required) -- Container with items array, each containing:
  • 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
• tranDate -- Transaction date in YYYY-MM-DD format
• memo -- Header memo
• orderStatus -- "A" (Pending Approval) or "B" (Pending Fulfillment)
• otherrefnum -- External reference or PO number

Example: