Acumatica API - Endpoint Default 23 200 001 icon

Acumatica API - Endpoint Default 23 200 001

Interact with Acumatica Endpoint Default/23.200.001

Actions478

Physical Inventory Review → Get List

AI-generated

Summary

Retrieve a list of Physical Inventory Review records filtered by optional criteria.

Inputs

  • createdDateTimeFilter — Filter results by Created Date Time with operator (Equals, After, On or After, Before, On or Before) and a date/time value.
  • descriptionFilter — Filter results by Description using operator (Equals, Contains, Starts With) and a value.
  • freezeDateFilter — Filter results by Freeze Date with operator options and a date/time value.
  • referenceNbrFilter — Filter results by Reference Nbr using operator (Equals, Contains, Starts With) and a value.
  • statusFilter — Filter results by Status using operator (Equals, Contains, Starts With) and a value.
  • totalPhysicalQtyFilter — Filter results by Total Physical Qty using numeric operator (Equals, Greater Than, Greater Than or Equal, Less Than, Less Than or Equal) and a numeric value.
  • totalVarianceCostFilter — Filter results by Total Variance Cost using numeric operator options and a numeric value.
  • totalVarianceQtyFilter — Filter results by Total Variance Qty using numeric operator options and a numeric value.
  • typeIDFilter — Filter results by Type ID using operator (Equals, Contains, Starts With) and a value.
  • warehouseIDFilter — Filter results by Warehouse ID using operator (Equals, Contains, Starts With) and a value.
  • customFilter — Advanced OData $filter expression (e.g., CustomerID/value eq 'CUST001') to further filter results.

Output shape

a list of Physical Inventory Review items

Pagination may be supported; all filter fields are optional; errors are returned in a standard envelope.

Examples

Example 1: Get all inventory reviews created after January 1, 2024

Set Created Date Time Filter → operator: gt, value: 2024-01-01T00:00:00

Example 2: Find reviews with Reference Nbr equal to 'INV12345'

Set Reference Nbr Filter → operator: eq, value: INV12345

Example 3: Filter by Total Physical Qty greater than 100 using advanced OData

Set Total Physical Qty Filter → operator: gt, value: 100 and optionally use customFilter: "TotalPhysicalQty/value gt 100"

Links

Discussion