list_sales_orders
Search and list sales orders with optional filters by status, customer, date, or total. Use for retrieving order records or building order reports.
Instructions
Search and list sales orders with optional filtering
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| skip | No | Number of records to skip | |
| sort | No | Property to sort by (e.g., orderDate, orderNumber) | |
| count | No | Number of records to return (max 100) | |
| smart | No | Smart search across order fields | |
| status | No | Filter by order status (single value or array) | |
| include | No | Related data to include (e.g., customer, lines, lines.product) | |
| totalTo | No | Filter by maximum total | |
| sortDesc | No | Sort in descending order | |
| totalFrom | No | Filter by minimum total | |
| customerId | No | Filter by customer ID | |
| locationId | No | Filter by location ID | |
| orderDateTo | No | Filter by order date (to) - ISO format | |
| orderNumber | No | Filter by order number | |
| includeCount | No | Include total record count in response | |
| orderDateFrom | No | Filter by order date (from) - ISO format | |
| requiredDateTo | No | Filter by required date (to) | |
| requiredDateFrom | No | Filter by required date (from) |