List sales invoices

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

GET https://cotlet.dev/api/v1/erpnext/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.

Request

cURL
curl https://cotlet.dev/api/v1/erpnext/sales-invoices \
  -H "Authorization: Bearer $COTLET_API_KEY"
Python
result = client.call("erpnext", "list_sales_invoices")
Node.js
const result = await cotlet.call('erpnext', 'list_sales_invoices');
CLI
cotlet call erpnext list_sales_invoices

Example response

JSON

{
  "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
}

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.