query_invoices
List and filter sales invoices from Acumatica AR to analyze revenue, find open or overdue invoices, and summarize activity by customer.
Instructions
List and filter Acumatica sales invoices (AR). Use this for revenue analytics, finding open or overdue invoices, or summarizing invoice activity by customer.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top | No | Max records to return (default 50, max 500) | |
| skip | No | Records to skip for pagination | |
| filter | No | OData $filter expression. Examples: "Status eq 'Open'", "Type eq 'Invoice'", "Customer eq 'CUST001'", "Date gt '2025-01-01'" | |
| orderby | No | OData $orderby. Example: "Date desc" | |
| inventoryID | No | Filter to invoices that contain this inventory item in any line, e.g. "WIDGET-001" |