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
| Name | Type | Description |
|---|---|---|
| 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 "https://cotlet.dev/api/v1/erpnext/overdue-invoices?min_days_overdue=7&limit=50" \
-H "Authorization: Bearer $COTLET_API_KEY" result = client.call("erpnext", "list_overdue_invoices", {"min_days_overdue":7,"limit":50}) const result = await cotlet.call('erpnext', 'list_overdue_invoices', {"min_days_overdue":7,"limit":50}); cotlet call erpnext list_overdue_invoices --data '{"min_days_overdue":7,"limit":50}' Example response
{
"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
}