Acumatica API - Endpoint Default 25 200 001Install

Summary

Retrieve a list of Warehouse records from the Acumatica ERP system, applying optional filters to narrow down results based on various Warehouse properties.

Inputs

• Active Filter — Filter results by the active status of warehouses (boolean field) with equality operator only.
• COGS Expense Account Filter — Filter by Cost of Goods Sold Expense Account using operators Equals, Contains, or Starts With.
• COGS Expense Subaccount Filter — Filter by COGS Expense Subaccount with operators Equals, Contains, or Starts With.
• Description Filter — Filter warehouses by their description field with operators Equals, Contains, or Starts With.
• Discount Account Filter — Filter by Discount Account with options Equals, Contains, or Starts With.
• Discount Subaccount Filter — Filter by Discount Subaccount with options Equals, Contains, or Starts With.
• Drop Ship Location ID Filter — Filter by Drop Ship Location ID with options Equals, Contains, or Starts With.
• Freight Charge Account Filter — Filter by Freight Charge Account with options Equals, Contains, or Starts With.
• Freight Charge Subaccount Filter — Filter by Freight Charge Subaccount using Equals, Contains, or Starts With.
• Inventory Account Filter — Filter by Inventory Account with operators Equals, Contains, or Starts With.
• Inventory Subaccount Filter — Filter by Inventory Subaccount with operators Equals, Contains, or Starts With.
• Landed Cost Variance Account Filter — Filter by Landed Cost Variance Account using Equals, Contains, or Starts With.
• Landed Cost Variance Subaccount Filter — Filter by Landed Cost Variance Subaccount with Equals, Contains, or Starts With.
• Last Modified Date Time Filter — Filter warehouses based on their last modified date and time using operators Equals, After (gt), On or After (ge), Before (lt), or On or Before (le).
• Misc Charge Account Filter — Filter by Misc Charge Account using Equals, Contains, or Starts With.
• Misc Charge Subaccount Filter — Filter by Misc Charge Subaccount with options Equals, Contains, or Starts With.
• Non Stock Picking Location ID Filter — Filter by Non Stock Picking Location ID with operators Equals, Contains, or Starts With.
• Override Inventory Account Subaccount Filter — Filter by Override Inventory Account Subaccount as a boolean equality filter.
• PO Accrual Account Filter — Filter by PO Accrual Account with operators Equals, Contains, or Starts With.
• PO Accrual Subaccount Filter — Filter by PO Accrual Subaccount using Equals, Contains, or Starts With.
• Purchase Price Variance Account Filter — Filter by Purchase Price Variance Account using Equals, Contains, or Starts With.
• Purchase Price Variance Subaccount Filter — Filter by Purchase Price Variance Subaccount with options Equals, Contains, or Starts With.
• Reason Code Subaccount Filter — Filter by Reason Code Subaccount with operators Equals, Contains, or Starts With.
• Receiving Location ID Filter — Filter by Receiving Location ID with operators Equals, Contains, or Starts With.
• RMA Location ID Filter — Filter by RMA Location ID using Equals, Contains, or Starts With.
• Sales Account Filter — Filter by Sales Account with options Equals, Contains, or Starts With.
• Sales Subaccount Filter — Filter by Sales Subaccount using operators Equals, Contains, or Starts With.
• Shipping Location ID Filter — Filter by Shipping Location ID with operators Equals, Contains, or Starts With.
• Standard Cost Revaluation Account Filter — Filter by Standard Cost Revaluation Account using Equals, Contains, or Starts With.
• Standard Cost Revaluation Subaccount Filter — Filter by Standard Cost Revaluation Subaccount with options Equals, Contains, or Starts With.
• Standard Cost Variance Account Filter — Filter by Standard Cost Variance Account with options Equals, Contains, or Starts With.
• Standard Cost Variance Subaccount Filter — Filter by Standard Cost Variance Subaccount with options Equals, Contains, or Starts With.
• Use Item Default Location For Picking Filter — Filter by Use Item Default Location For Picking as a boolean equality filter.
• Warehouse ID Filter — Filter warehouses by their ID with operators Equals, Contains, or Starts With.
• Custom Filter — Apply an advanced OData $filter expression as a string to refine the results further.

Output shape

a list of Warehouse objects matching the specified filters

The operation accepts many optional filters, which are combined into an OData $filter expression sent to the Acumatica API. Results will include all warehouses matching the combined filters. The Custom Filter input allows advanced OData expressions for additional filtering. Results are returned as an array of Warehouse items containing their respective properties.

Links

• n8n community nodes installation guide