{
"supplier": {
"id": 749,
"code": "QUINC01",
"name": "Quincaillerie Fictive ltée"
},
"as_of_date": "2026-10-07",
"filter": {
"days_overdue_min": 0,
"bucket_type": "standard",
"sort_by": "due_date_asc",
"limit": 2
},
"summary": {
"items_count": 5,
"invoices_count": 4,
"credits_count": 1,
"total_due": 9320,
"invoices_due": 9870,
"credits_total": 550,
"overdue_count": 3,
"overdue_amount": 8120,
"current_amount": 1750,
"oldest_invoice_date": "2026-04-01",
"oldest_due_date": "2026-05-01",
"max_days_overdue": 159,
"weighted_avg_days_overdue": 87.4,
"aging_breakdown": {
"days_0_30": 1750,
"days_30_60": 0,
"days_60_90": 2750,
"days_over_90": 4820
},
"currency": "CAD"
},
"items": [
{
"invoice": {
"id": 2287,
"number": "24518",
"type": {
"id": 2,
"code": "invoice",
"label": "Facture"
},
"reference": "FC-2026-0412"
},
"invoice_date": "2026-04-01",
"due_date": "2026-05-01",
"days_overdue": 159,
"bucket": {
"id": 3,
"code": "days_over_90",
"label": "91 jours et plus"
},
"amount_invoiced": 5370,
"amount_paid": 0,
"amount_remaining": 5370,
"is_credit": false,
"is_paid": false,
"is_current_day": false,
"_links": {
"invoice_detail": "/api/suppliers/invoices-ap/by-id/2287",
"payment_allocations": "/api/suppliers/invoice-ap/by-id/2287/payment-allocations"
}
},
{
"invoice": {
"id": 2301,
"number": "24664",
"type": {
"id": 1,
"code": "credit",
"label": "Crédit"
},
"reference": "Note de crédit 7781"
},
"invoice_date": "2026-05-01",
"due_date": "2026-05-01",
"days_overdue": 159,
"bucket": {
"id": 3,
"code": "days_over_90",
"label": "91 jours et plus"
},
"amount_invoiced": -550,
"amount_paid": 0,
"amount_remaining": -550,
"is_credit": true,
"is_paid": false,
"is_current_day": false,
"_links": {
"invoice_detail": "/api/suppliers/invoices-ap/by-id/2301",
"payment_allocations": "/api/suppliers/invoice-ap/by-id/2301/payment-allocations"
}
}
],
"metadata": {
"organisation_id": "construction_demo",
"extracted_at": "2026-10-07T14:05:50-04:00",
"sdk_indexes_used": {
"invoice_ap": 3,
"payment_ap_line": 1
},
"scope": "open_invoices_only",
"truncated": true,
"limit_applied": 2,
"offset_applied": 0,
"has_more": true,
"next_offset": 2
},
"cache": {
"status": "miss",
"key_hash": "sha1:3f1c2a9e8b7d6c5f4e3a2b1c0d9e8f7a6b5c4d3e",
"cached_at": "2026-10-07T14:05:50-04:00",
"expires_at": "2026-10-07T18:05:50-04:00",
"age_seconds": 0,
"ttl_remaining_seconds": 14400,
"ttl_policy": "current_period_4h",
"force_refreshed": false
},
"_links": {
"self": "/api/suppliers/by-id/749/unpaid-invoices?as_of=2026-10-07&bucket_type=standard&days_overdue_min=0&sort_by=due_date_asc&limit=2&offset=0",
"next": "/api/suppliers/by-id/749/unpaid-invoices?as_of=2026-10-07&bucket_type=standard&days_overdue_min=0&sort_by=due_date_asc&limit=2&offset=2",
"supplier_overview": "/api/suppliers/by-id/749/overview",
"supplier_statement": "/api/suppliers/by-id/749/statement?from=2025-10-07&to=2026-10-07",
"supplier_aging": "/api/suppliers/aging/by-id/749",
"payables_to_pay": "/api/payables/to-pay?as_of=2026-10-07"
}
}