find_invoices
Find invoices. filter='overdue' (due_date0 AND not paid/cancelled/refunded), 'outstanding' (balance_due>0 regardless of due date), 'paid'. Returns id (DB pk), invoice_number, totals, balance_due, due_date, status, customer name.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Max rows (default 50, max 300). | |
| filter | No | Invoice state filter. | |
| customer_id | No | customers.id to filter by. |