Acumatica API - Endpoint Default 24 200 001Install

Summary

Retrieve a filtered list of inventory allocation inquiry records from the Acumatica API using various optional numeric and string filter criteria.

Inputs

• Available Filter — Filter records based on the 'Available' numeric field using operators like equals, greater than, less than, etc.
• Available For Issue Filter — Filter records based on the 'Available For Issue' numeric field.
• Available For Shipping Filter — Filter records based on the 'Available For Shipping' numeric field.
• Base Unit Filter — Filter records by 'Base Unit' using string operators such as equals, contains, starts with.
• In Transit Filter — Filter records based on the 'In Transit' numeric field.
• In Transit To SO Filter — Filter records based on the 'In Transit To SO' numeric field.
• Inventory ID Filter — Filter records by 'Inventory ID' with string operators.
• Inventory Issues Filter — Filter records based on 'Inventory Issues' numeric field.
• Inventory Receipts Filter — Filter records based on 'Inventory Receipts' numeric field.
• Kit Assembly Demand Filter — Filter by 'Kit Assembly Demand' numeric field.
• Kit Assembly Supply Filter — Filter by 'Kit Assembly Supply' numeric field.
• Location Filter — Filter records by 'Location' string field.
• On Hand Filter — Filter by 'On Hand' numeric field.
• On Location Not Available Filter — Filter by 'On Location Not Available' numeric field.
• Purchase For SO Filter — Filter by 'Purchase For SO' numeric field.
• Purchase For SO Prepared Filter — Filter by 'Purchase For SO Prepared' numeric field.
• Purchase Orders Filter — Filter by 'Purchase Orders' numeric field.
• Purchase Prepared Filter — Filter by 'Purchase Prepared' numeric field.
• Purchase Receipts Filter — Filter by 'Purchase Receipts' numeric field.
• Receipts For SO Filter — Filter by 'Receipts For SO' numeric field.
• SO Allocated Filter — Filter by 'SO Allocated' numeric field.
• SO Back Ordered Filter — Filter by 'SO Back Ordered' numeric field.
• SO Booked Filter — Filter by 'SO Booked' numeric field.
• SO Prepared Filter — Filter by 'SO Prepared' numeric field.
• SO Shipped Filter — Filter by 'SO Shipped' numeric field.
• SO To Purchase Filter — Filter by 'SO To Purchase' numeric field.
• Total Addition Filter — Filter by 'Total Addition' numeric field.
• Total Deduction Filter — Filter by 'Total Deduction' numeric field.
• Warehouse ID Filter — Filter records by 'Warehouse ID' string field.
• Custom Filter — Apply an advanced custom OData $filter expression as an additional filter.

Output shape

a list of inventory allocation inquiry records matching the applied filters

Supports multiple optional filters on numeric and string fields; filters are combined into an OData $filter query. The output is a JSON array of matching records from the Acumatica Inventory Allocation Inquiry endpoint.

Examples

Example 1: Retrieve all inventory allocations where 'Available' is greater than 10 and 'Warehouse ID' contains 'WH1'

Set 'Available Filter' operator to 'gt', value to 10. Set 'Warehouse ID Filter' operator to 'contains', value to 'WH1'.

Links

• n8n community nodes installation guide