Acumatica API - Endpoint Default 24 200 001Install

Summary

Retrieve a list of Warehouse records from the Acumatica API applying optional filters on various Warehouse fields.

Inputs

• Active Filter — Filter results by the Active boolean field with 'Equals' operator.
• COGS Expense Account Filter — Filter results by COGS Expense Account field using operators: Equals, Contains, or Starts With.
• COGS Expense Subaccount Filter — Filter results by COGS Expense Subaccount field using operators: Equals, Contains, or Starts With.
• Description Filter — Filter results by Description field using operators: Equals, Contains, or Starts With.
• Discount Account Filter — Filter results by Discount Account field using operators: Equals, Contains, or Starts With.
• Discount Subaccount Filter — Filter results by Discount Subaccount field using operators: Equals, Contains, or Starts With.
• Drop Ship Location ID Filter — Filter results by Drop Ship Location ID field using operators: Equals, Contains, or Starts With.
• Freight Charge Account Filter — Filter results by Freight Charge Account field using operators: Equals, Contains, or Starts With.
• Freight Charge Subaccount Filter — Filter results by Freight Charge Subaccount field using operators: Equals, Contains, or Starts With.
• Inventory Account Filter — Filter results by Inventory Account field using operators: Equals, Contains, or Starts With.
• Inventory Subaccount Filter — Filter results by Inventory Subaccount field using operators: Equals, Contains, or Starts With.
• Landed Cost Variance Account Filter — Filter results by Landed Cost Variance Account field using operators: Equals, Contains, or Starts With.
• Landed Cost Variance Subaccount Filter — Filter results by Landed Cost Variance Subaccount field using operators: Equals, Contains, or Starts With.
• Last Modified Date Time Filter — Filter results by Last Modified Date Time with operators: Equals, After (gt), On or After (ge), Before (lt), On or Before (le).
• Misc Charge Account Filter — Filter results by Misc Charge Account field using operators: Equals, Contains, or Starts With.
• Misc Charge Subaccount Filter — Filter results by Misc Charge Subaccount field using operators: Equals, Contains, or Starts With.
• Non Stock Picking Location ID Filter — Filter results by Non Stock Picking Location ID field using operators: Equals, Contains, or Starts With.
• Override Inventory Account Subaccount Filter — Filter results by Override Inventory Account Subaccount boolean field with 'Equals' operator.
• PO Accrual Account Filter — Filter results by PO Accrual Account field using operators: Equals, Contains, or Starts With.
• PO Accrual Subaccount Filter — Filter results by PO Accrual Subaccount field using operators: Equals, Contains, or Starts With.
• Purchase Price Variance Account Filter — Filter results by Purchase Price Variance Account field using operators: Equals, Contains, or Starts With.
• Purchase Price Variance Subaccount Filter — Filter results by Purchase Price Variance Subaccount field using operators: Equals, Contains, or Starts With.
• Reason Code Subaccount Filter — Filter results by Reason Code Subaccount field using operators: Equals, Contains, or Starts With.
• Receiving Location ID Filter — Filter results by Receiving Location ID field using operators: Equals, Contains, or Starts With.
• RMA Location ID Filter — Filter results by RMA Location ID field using operators: Equals, Contains, or Starts With.
• Sales Account Filter — Filter results by Sales Account field using operators: Equals, Contains, or Starts With.
• Sales Subaccount Filter — Filter results by Sales Subaccount field using operators: Equals, Contains, or Starts With.
• Shipping Location ID Filter — Filter results by Shipping Location ID field using operators: Equals, Contains, or Starts With.
• Standard Cost Revaluation Account Filter — Filter results by Standard Cost Revaluation Account field using operators: Equals, Contains, or Starts With.
• Standard Cost Revaluation Subaccount Filter — Filter results by Standard Cost Revaluation Subaccount field using operators: Equals, Contains, or Starts With.
• Standard Cost Variance Account Filter — Filter results by Standard Cost Variance Account field using operators: Equals, Contains, or Starts With.
• Standard Cost Variance Subaccount Filter — Filter results by Standard Cost Variance Subaccount field using operators: Equals, Contains, or Starts With.
• Use Item Default Location For Picking Filter — Filter results by Use Item Default Location For Picking boolean field with 'Equals' operator.
• Warehouse ID Filter — Filter results by Warehouse ID field using operators: Equals, Contains, or Starts With.
• Custom Filter — Apply an advanced OData $filter expression as a custom filter string in addition to other filters.

Output shape

a list of Warehouse records matching the applied filters from the Acumatica endpoint

The returned list is filtered by the provided fixedCollection filters and any advanced OData filter expression in the Custom Filter field. Each filter is optional; if none are specified, all warehouses are returned.

Links

• n8n community nodes installation guide