Query Acumatica sales orders using the SO-SalesOrder generic inquiry. Use this for lists, analytics, and summaries. Supports OData $filter and $orderby.

Get a single Acumatica sales order with full line item detail. Use this when you need line-level data for a specific known order.

List Acumatica stock/inventory items. Supports OData filtering. Use this to explore inventory, find items by class or status, or get item lists.

Get a specific Acumatica inventory item with warehouse stock quantities.

List and filter Acumatica shipments. Use this for shipment analytics, tracking open or completed shipments, or finding shipments by customer or warehouse.

Get a single Acumatica shipment with full line item detail.

List and filter Acumatica sales invoices (AR). Use this for revenue analytics, finding open or overdue invoices, or summarizing invoice activity by customer.

Get a single Acumatica sales invoice with full line item detail.

List and filter Acumatica purchase orders. Use this for procurement analytics, finding open or pending POs, or summarizing spend by vendor.

Get a single Acumatica purchase order with full line item detail.

List and filter Acumatica customers. Use this to look up customers by name, class, status, or credit terms for analytics and reporting.

Get a specific Acumatica customer with full detail including billing, shipping, and credit info.

List all available OData entity sets (Generic Inquiries) exposed by Acumatica. Call this first to discover valid entity names before using query_odata.

Query any Acumatica Generic Inquiry via OData. Use list_odata_entities first to find valid entity names. Supports OData $filter, $select, $orderby, $top, and $skip.

List all available OData v4 DAC entity sets exposed by Acumatica. Unlike list_odata_entities (Generic Inquiries), this exposes raw DAC tables (SOOrder, BAccount, InventoryItem, GLTran, etc.). Use the returned names with query_odata_v4.

Query any Acumatica DAC table directly via OData v4. Exposes raw DAC entities (e.g. SOOrder, BAccount, InventoryItem, GLTran, APTran, INTran). Use list_odata_v4_entities to discover valid entity names. Supports OData $filter, $select, $orderby, $top, and $skip. IMPORTANT: Large tables (e.g. GLTran) will timeout without a filter — always apply a date range or other filter. Always use $select to limit returned fields.