Totals of invoices and bills, grouped (aging)
query_invoicesAdds up invoices you sent (owed_to_you) and bills you received (you_owe), grouped by up to two of: counterparty, aging (current, 1-30, 31-60, 61-90, 90+ days overdue), status, company, side, due_month, issue_month. Measures per currency: outstanding, total, paid, count, avg_days_overdue. By default only unpaid ones (open, overdue, partially paid, disputed); include_paid adds paid ones. Example: who owes the most, by aging: side owed_to_you, group_by ["counterparty","aging"]. search_invoices lists the invoices behind a group.
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "query_invoices"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| side | No | both | |
| limit | No | ||
| order | No | largest (default): by outstanding; key: by group (default when grouping by aging or a month). | |
| company | No | Company name or id, "Personal", or "all". Omit for every company this connection can see. | |
| group_by | No | ||
| measures | No | ||
| counterparty | No | ||
| include_paid | No |