List sales invoices

Sales invoices with status, due date, total and outstanding amount.

MCP tool erpnext_read → list_sales_invoices

read

Lists Sales Invoice records, newest posting date first. Filter by status, customer or a posting date range. Status is the value ERPNext shows on the invoice. Outstanding amount is the balance left after payments, credit notes and adjustments. Pages hold up to 100 invoices; pass next_cursor back as cursor for the next page.

Parameters

Parameters: list_sales_invoices
NameTypeDescription
status string string Draft, Unpaid, Overdue, Partly Paid, Paid, Credit Note Issued, Return or Cancelled.
customer string string Customer ID from list_customers.
from_date string string Posting date from, YYYY-MM-DD.
to_date string string Posting date to, YYYY-MM-DD.
limit integer integer Records per page. Default: 20.
cursor string string Next page cursor from the previous call.

tools/call

JSON-RPC

{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "erpnext_read",
    "arguments": {
      "operation": "list_sales_invoices",
      "arguments": {}
    }
  }
}

Example response

JSON

{
  "content": [
    {
      "type": "text",
      "text": "{ ... same JSON as structuredContent ... }"
    }
  ],
  "structuredContent": {
    "invoices": [
      {
        "invoice": "ACC-SINV-2026-00042",
        "customer": "Northwind Studio",
        "posting_date": "2026-10-14",
        "due_date": "2026-11-13",
        "currency": "USD",
        "grand_total": 1650,
        "outstanding_amount": 1650,
        "status": "Unpaid"
      },
      {
        "invoice": "ACC-SINV-2026-00036",
        "customer": "Lumen Dental",
        "posting_date": "2026-09-17",
        "due_date": "2026-10-01",
        "currency": "USD",
        "grand_total": 450,
        "outstanding_amount": 450,
        "status": "Overdue"
      }
    ],
    "next_cursor": null
  },
  "isError": false
}

Sign in once. Your agent does the rest.

Sign up and add the apps you need. Free 7-day trial with 2,000 credits, no card needed.