Acumatica API - Endpoint Default 23 200 001 icon

Acumatica API - Endpoint Default 23 200 001

Interact with Acumatica Endpoint Default/23.200.001

Actions478

Inventory Adjustment → Get List

AI-generated

Summary

Retrieve a list of Inventory Adjustment records from Acumatica, optionally filtering by fields such as Date, Description, External Ref, Hold, Last Modified Date Time, Reference Nbr, Status, Total Cost, Total Qty, and a custom OData $filter expression.

Inputs

  • DateFilter — Filter results by Date with operator (eq, gt, ge, lt, le) and date/time value
  • DescriptionFilter — Filter results by Description with operator (eq, contains, startswith) and string value
  • ExternalRefFilter — Filter results by External Ref with operator (eq, contains, startswith) and string value
  • HoldFilter — Filter results by Hold with operator (eq) and boolean value
  • LastModifiedDateTimeFilter — Filter results by Last Modified Date Time with operator (eq, gt, ge, lt, le) and date/time value
  • ReferenceNbrFilter — Filter results by Reference Nbr with operator (eq, contains, startswith) and string value
  • StatusFilter — Filter results by Status with operator (eq, contains, startswith) and string value
  • TotalCostFilter — Filter results by Total Cost with operator (eq, gt, ge, lt, le) and numeric value
  • TotalQtyFilter — Filter results by Total Qty with operator (eq, gt, ge, lt, le) and numeric value
  • customFilter — Advanced OData $filter expression (e.g. CustomerID/value eq 'CUST001'). Applied in addition to any filter fields above.

Output shape

array of Inventory Adjustment objects

The node returns the JSON payload from Acumatica's GET /InventoryAdjustment endpoint, typically an array of adjustment records.

Examples

Example 1: Get all adjustments after a certain date

Set DateFilter operator to 'gt' and provide the desired date.

Example 2: Find adjustments with a specific reference number containing 'ADJ'

Set ReferenceNbrFilter operator to 'contains' and value to 'ADJ'.

Example 3: Combine multiple filters and add a custom OData clause

Enable DateFilter, TotalQtyFilter, and set customFilter to e.g. 'Status/value eq OPEN' to further refine results.

Links

Discussion