Acumatica API - Endpoint Default 25 200 001 icon

Acumatica API - Endpoint Default 25 200 001

Interact with Acumatica Endpoint Default/25.200.001

Actions478

Inventory Summary Inquiry → Get List

AI-generated

Summary

Retrieve a filtered list of Inventory Summary Inquiry records from Acumatica using optional filters for Expand By Lot Serial Number, Inventory ID, Location ID, Subitem, Warehouse ID, and an advanced custom OData filter expression.

Inputs

  • Expand By Lot Serial Nbr Filter — Filter results where the Expand By Lot Serial Number matches the specified boolean value.
  • Inventory ID Filter — Filter results by Inventory ID using operators Equals, Contains, or Starts With.
  • Location ID Filter — Filter results by Location ID using operators Equals, Contains, or Starts With.
  • Subitem Filter — Filter results by Subitem using operators Equals, Contains, or Starts With.
  • Warehouse ID Filter — Filter results by Warehouse ID using operators Equals, Contains, or Starts With.
  • Custom Filter — Provide an advanced OData $filter expression to apply additional filtering beyond the predefined filter fields.

Output shape

a list of records representing Inventory Summary Inquiry entries matching the applied filters

The returned list includes all records meeting the specified filter criteria combined with any advanced custom OData filter expression. If no filters are applied, the operation returns all available Inventory Summary Inquiry records. Filtering supports string matching operators and boolean matching for Expand By Lot Serial Number.

Examples

Example 1: Retrieve all Inventory Summary Inquiry records where Inventory ID starts with 'ABC' and Warehouse ID equals 'WH1'

Set Inventory ID Filter with operator 'Starts With' and value 'ABC'; set Warehouse ID Filter with operator 'Equals' and value 'WH1'. Leave other filters unset or at defaults.

Example 2: Get records where Expand By Lot Serial Number is true

Set the Expand By Lot Serial Nbr Filter value to true with operator 'Equals'. Other filters can be left unset.

Example 3: Use a custom OData filter to get records where Inventory ID is 'CUST001' and the warehouse is 'Main'

Set Custom Filter to "InventoryID/value eq 'CUST001' and WarehouseID/value eq 'Main'". Leave predefined filters unset.

Links

Discussion