query_purchase_orders
List and filter Acumatica purchase orders to support procurement analytics, track open or pending POs, and summarize vendor spend.
Instructions
List and filter Acumatica purchase orders. Use this for procurement analytics, finding open or pending POs, or summarizing spend by vendor.
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'", "VendorID eq 'VD001'", "Date gt '2025-01-01'" | |
| orderby | No | OData $orderby. Example: "Date desc" |