Acumatica API - Endpoint Default 24 200 001Install

Summary

Retrieve a list of Item Warehouse records from Acumatica, applying optional filters to narrow down the results based on various warehouse and inventory-related fields.

Inputs

• Created Date Time Filter — Filter Item Warehouses by their creation date and time using operators like equals, after, before, etc.
• Default Issue From Filter — Filter by Default Issue From value using operators equals, contains, or starts with.
• Default Receipt To Filter — Filter by Default Receipt To value using operators equals, contains, or starts with.
• Default Subitem Filter — Filter by Default Subitem value using operators equals, contains, or starts with.
• Inventory Account Filter — Filter by Inventory Account using operators equals, contains, or starts with.
• Inventory ID Filter — Filter by Inventory ID using operators equals, contains, or starts with.
• Inventory Subaccount Filter — Filter by Inventory Subaccount using operators equals, contains, or starts with.
• Last Modified Date Time Filter — Filter by last modified date/time using operators equals, after, before, etc.
• Max Qty Filter — Filter by maximum quantity with numeric comparison operators like equals, greater than, less than, etc.
• MSRP Filter — Filter by MSRP (Manufacturer's Suggested Retail Price) with numeric comparison operators.
• Override Inventory Account Subaccount Filter — Filter by boolean Override Inventory Account Subaccount equals true or false.
• Override Preferred Vendor Filter — Filter by boolean Override Preferred Vendor equals true or false.
• Override Price Filter — Filter by boolean Override Price equals true or false.
• Override Replenishment Settings Filter — Filter by boolean Override Replenishment Settings equals true or false.
• Override Service Level Filter — Filter by boolean Override Service Level equals true or false.
• Override Standard Cost Filter — Filter by boolean Override Standard Cost equals true or false.
• Override Product Manager Filter — Filter by boolean Override Product Manager equals true or false.
• Override Max Qty Filter — Filter by boolean Override Max Qty equals true or false.
• Override Reorder Point Filter — Filter by boolean Override Reorder Point equals true or false.
• Override Safety Stock Filter — Filter by boolean Override Safety Stock equals true or false.
• Preferred Location Filter — Filter by Preferred Location using operators equals, contains, or starts with.
• Preferred Vendor Filter — Filter by Preferred Vendor using operators equals, contains, or starts with.
• Product Manager Filter — Filter by Product Manager using operators equals, contains, or starts with.
• Product Workgroup Filter — Filter by Product Workgroup using operators equals, contains, or starts with.
• Reorder Point Filter — Filter by Reorder Point with numeric comparison operators.
• Replenishment Class Filter — Filter by Replenishment Class using operators equals, contains, or starts with.
• Replenishment Method Filter — Filter by Replenishment Method using operators equals, contains, or starts with.
• Replenishment Source Filter — Filter by Replenishment Source using operators equals, contains, or starts with.
• Replenishment Warehouse Filter — Filter by Replenishment Warehouse using operators equals, contains, or starts with.
• Safety Stock Filter — Filter by Safety Stock with numeric comparison operators.
• Seasonality Filter — Filter by Seasonality using operators equals, contains, or starts with.
• Service Level Filter — Filter by Service Level with numeric comparison operators.
• Status Filter — Filter by Status using operators equals, contains, or starts with.
• Warehouse ID Filter — Filter by Warehouse ID using operators equals, contains, or starts with.
• Custom Filter — Provide a custom OData $filter string for advanced filtering, applied in addition to field-specific filters.

Output shape

a list of Item Warehouse records matching the specified filters

The returned data will contain multiple records of Item Warehouse objects as per the filters applied. Filters support various operators such as equals, contains, greater than, less than, and boolean equality, allowing for precise control over the records retrieved. The custom filter allows for advanced OData query expressions beyond the predefined filters.

Links

• n8n community nodes installation guide