List overdue invoices

Invoices with the Overdue status, oldest due date first, with days overdue.

GET https://cotlet.dev/api/v1/erpnext/overdue-invoices

read

Returns the invoices ERPNext shows as Overdue: past the due date with a balance remaining. Sorted by due date, oldest first. days_overdue counts from the due date to today. total_outstanding adds the outstanding amounts on the page. Pages hold up to 100 invoices; pass next_cursor back as cursor for the next page.

Parameters

Parameters: list_overdue_invoices
NameTypeDescription
customer string string Customer ID from list_customers.
min_days_overdue integer integer Only invoices at least this many days past the due date. Default: 1.
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/overdue-invoices?min_days_overdue=7&limit=50" \
  -H "Authorization: Bearer $COTLET_API_KEY"
Python
result = client.call("erpnext", "list_overdue_invoices", {"min_days_overdue":7,"limit":50})
Node.js
const result = await cotlet.call('erpnext', 'list_overdue_invoices', {"min_days_overdue":7,"limit":50});
CLI
cotlet call erpnext list_overdue_invoices --data '{"min_days_overdue":7,"limit":50}'

Example response

JSON

{
  "as_of": "2026-10-14",
  "invoices": [
    {
      "invoice": "ACC-SINV-2026-00031",
      "customer": "Harbor & Pine",
      "due_date": "2026-09-20",
      "days_overdue": 24,
      "currency": "USD",
      "outstanding_amount": 800
    },
    {
      "invoice": "ACC-SINV-2026-00036",
      "customer": "Lumen Dental",
      "due_date": "2026-10-01",
      "days_overdue": 13,
      "currency": "USD",
      "outstanding_amount": 450
    },
    {
      "invoice": "ACC-SINV-2026-00039",
      "customer": "Kestrel Logistics",
      "due_date": "2026-10-05",
      "days_overdue": 9,
      "currency": "USD",
      "outstanding_amount": 1250
    }
  ],
  "total_outstanding": 2500,
  "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.