List overdue invoices
Invoices with the Overdue status, oldest due date first, with days overdue.
MCP tool erpnext_read → list_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. |
tools/call
{
"jsonrpc": "2.0",
"id": 1,
"method": "tools/call",
"params": {
"name": "erpnext_read",
"arguments": {
"operation": "list_overdue_invoices",
"arguments": {
"min_days_overdue": 7,
"limit": 50
}
}
}
}Example response
{
"content": [
{
"type": "text",
"text": "{ ... same JSON as structuredContent ... }"
}
],
"structuredContent": {
"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
},
"isError": false
}