query_sales_orders
Query Acumatica sales orders for lists, analytics, and summaries. Filter and sort using OData expressions to retrieve specific records.
Instructions
Query Acumatica sales orders using the SO-SalesOrder generic inquiry. Use this for lists, analytics, and summaries. Supports OData $filter and $orderby.
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'", "OrderDate gt '2025-01-01'", "CustomerID eq 'TUXTON'" | |
| orderby | No | OData $orderby. Example: "OrderDate desc" | |
| inventoryID | No | Filter to orders that contain this inventory item in any line, e.g. "WIDGET-001" | |
| includeDetails | No | Set true to expand line items inline. Increases payload size significantly; use with a low top value. |