Acumatica API - Endpoint Default 24 200 001Install

Summary

Retrieve a list of Stock Item records from the Acumatica API by applying optional filters to narrow down results based on various Stock Item properties.

Inputs

• ABC Code Filter — Filter Stock Item results by the ABC Code using operators: Equals, Contains, or Starts With.
• Auto Incremental Value Filter — Filter results by Auto Incremental Value with operators: Equals, Contains, or Starts With.
• Average Cost Filter — Filter by Average Cost using numeric comparison operators: Equals, Greater Than, Greater Than or Equal, Less Than, Less Than or Equal.
• Base UOM Filter — Filter by Base Unit of Measure (UOM) using string operators: Equals, Contains, Starts With.
• COGS Account Filter — Filter by Cost of Goods Sold (COGS) Account with string operators.
• COGS Subaccount Filter — Filter by COGS Subaccount with string operators.
• Content Filter — Filter by Content field using string operators.
• Country Of Origin Filter — Filter by Country Of Origin with string operators.
• Current Std Cost Filter — Filter by Current Standard Cost using numeric comparison operators.
• Default Issue Location ID Filter — Filter by Default Issue Location ID with string operators.
• Default Price Filter — Filter by Default Price using numeric comparison operators.
• Default Receipt Location ID Filter — Filter by Default Receipt Location ID with string operators.
• Default Subitem Filter — Filter by Default Subitem with string operators.
• Default Warehouse ID Filter — Filter by Default Warehouse ID with string operators.
• Deferral Account Filter — Filter by Deferral Account with string operators.
• Deferral Subaccount Filter — Filter by Deferral Subaccount with string operators.
• Description Filter — Filter by Description using string operators.
• Dimension Volume Filter — Filter by Dimension Volume using numeric comparison operators.
• Dimension Weight Filter — Filter by Dimension Weight with numeric comparisons.
• Discount Account Filter — Filter by Discount Account with string operators.
• Discount Subaccount Filter — Filter by Discount Subaccount with string operators.
• Image Url Filter — Filter by Image URL with string operators.
• Inventory Account Filter — Filter by Inventory Account with string operators.
• Inventory ID Filter — Filter by Inventory ID with string operators.
• Inventory Subaccount Filter — Filter by Inventory Subaccount with string operators.
• Is A Kit Filter — Filter by whether the item is a Kit; boolean with equals operator only.
• Item Class Filter — Filter by Item Class with string operators.
• Item Status Filter — Filter by Item Status using string operators.
• Item Type Filter — Filter by Item Type using string operators.
• Landed Cost Variance Account Filter — Filter by Landed Cost Variance Account with string operators.
• Landed Cost Variance Subaccount Filter — Filter by Landed Cost Variance Subaccount with string operators.
• Last Cost Filter — Filter by Last Cost using numeric comparison operators.
• Last Modified Filter — Filter by Last Modified date using date-time comparison operators.
• Last Modified Date Time Filter — Filter by Last Modified Date Time using date-time comparisons.
• Last Std Cost Filter — Filter by Last Standard Cost using numeric comparison operators.
• Lot Serial Class Filter — Filter by Lot Serial Class with string operators.
• Markup Filter — Filter by Markup using numeric comparison operators.
• Max Cost Filter — Filter by Max Cost using numeric comparisons.
• Min Cost Filter — Filter by Min Cost using numeric comparisons.
• Min Markup Filter — Filter by Min Markup using numeric comparisons.
• MSRP Filter — Filter by Manufacturer's Suggested Retail Price using numeric comparisons.
• Packaging Option Filter — Filter by Packaging Option using string operators.
• Pack Separately Filter — Filter by Pack Separately flag; boolean with equals operator only.
• Pending Std Cost Filter — Filter by Pending Standard Cost using numeric comparisons.
• PO Accrual Account Filter — Filter by Purchase Order Accrual Account with string operators.
• PO Accrual Subaccount Filter — Filter by Purchase Order Accrual Subaccount with string operators.
• Posting Class Filter — Filter by Posting Class with string operators.
• Price Class Filter — Filter by Price Class using string operators.
• Price Manager Filter — Filter by Price Manager with string operators.
• Price Workgroup Filter — Filter by Price Workgroup using string operators.
• Product Manager Filter — Filter by Product Manager using string operators.
• Product Workgroup Filter — Filter by Product Workgroup with string operators.
• Purchase Price Variance Account Filter — Filter by Purchase Price Variance Account with string operators.
• Purchase Price Variance Subaccount Filter — Filter by Purchase Price Variance Subaccount with string operators.
• Purchase UOM Filter — Filter by Purchase Unit of Measure using string operators.
• Reason Code Subaccount Filter — Filter by Reason Code Subaccount with string operators.
• Sales Account Filter — Filter by Sales Account using string operators.
• Sales Subaccount Filter — Filter by Sales Subaccount using string operators.
• Sales UOM Filter — Filter by Sales Unit of Measure with string operators.
• Standard Cost Revaluation Account Filter — Filter by Standard Cost Revaluation Account with string operators.
• Standard Cost Revaluation Subaccount Filter — Filter by Standard Cost Revaluation Subaccount with string operators.
• Standard Cost Variance Account Filter — Filter by Standard Cost Variance Account with string operators.
• Standard Cost Variance Subaccount Filter — Filter by Standard Cost Variance Subaccount with string operators.
• Subject To Commission Filter — Filter by Subject To Commission flag; boolean with equals operator only.
• Tax Category Filter — Filter by Tax Category using string operators.
• Tariff Code Filter — Filter by Tariff Code with string operators.
• Use On Entry Filter — Filter by Use On Entry flag; boolean with equals operator only.
• Valuation Method Filter — Filter by Valuation Method with string operators.
• Volume UOM Filter — Filter by Volume Unit of Measure using string operators.
• Weight UOM Filter — Filter by Weight Unit of Measure using string operators.
• Cury Specific MSRP Filter — Filter by Currency-Specific MSRP using numeric comparisons.
• Cury Specific Price Filter — Filter by Currency-Specific Price using numeric comparisons.
• Availability Filter — Filter by Availability using string operators.
• Custom URL Filter — Filter by Custom URL with string operators.
• Export To External Filter — Filter by Export To External flag; boolean with equals operator only.
• Meta Description Filter — Filter by Meta Description using string operators.
• Meta Keywords Filter — Filter by Meta Keywords with string operators.
• Page Title Filter — Filter by Page Title using string operators.
• Search Keywords Filter — Filter by Search Keywords using string operators.
• Template Item ID Filter — Filter by Template Item ID with string operators.
• Visibility Filter — Filter by Visibility using string operators.
• Not Available Filter — Filter by Not Available flag using string operators.
• Custom Filter — Provide a custom OData $filter string expression to apply additional advanced filtering.

Output shape

a list of Stock Item records matching the specified filter criteria

Filters are optional and combined as OData $filter expressions for the API call; results are returned as an array of objects representing Stock Items from Acumatica.

Links

• n8n community nodes installation guide