Acumatica API - Endpoint Default 23 200 001Install

Summary

Retrieves a list of stock items filtered by multiple criteria.

Inputs

• ABCCodeFilter (required) — Filter results by ABC Code
• AutoIncrementalValueFilter (required) — Filter results by Auto Incremental Value
• AverageCostFilter (required) — Filter results by Average Cost
• BaseUOMFilter (required) — Filter results by Base UOM
• COGSAccountFilter (required) — Filter results by COGS Account
• COGSSubaccountFilter (required) — Filter results by COGS Subaccount
• ContentFilter (required) — Filter results by Content
• CountryOfOriginFilter (required) — Filter results by Country Of Origin
• CurrentStdCostFilter (required) — Filter results by Current Std Cost
• DefaultIssueLocationIDFilter (required) — Filter results by Default Issue Location ID
• DefaultPriceFilter (required) — Filter results by Default Price
• DefaultReceiptLocationIDFilter (required) — Filter results by Default Receipt Location ID
• DefaultSubitemFilter (required) — Filter results by Default Subitem
• DefaultWarehouseIDFilter (required) — Filter results by Default Warehouse ID
• DeferralAccountFilter (required) — Filter results by Deferral Account
• DeferralSubaccountFilter (required) — Filter results by Deferral Subaccount
• DescriptionFilter (required) — Filter results by Description
• DimensionVolumeFilter (required) — Filter results by Dimension Volume
• DimensionWeightFilter (required) — Filter results by Dimension Weight
• DiscountAccountFilter (required) — Filter results by Discount Account
• DiscountSubaccountFilter (required) — Filter results by Discount Subaccount
• ImageUrlFilter (required) — Filter results by Image Url
• InventoryAccountFilter (required) — Filter results by Inventory Account
• InventoryIDFilter (required) — Filter results by Inventory ID
• InventorySubaccountFilter (required) — Filter results by Inventory Subaccount
• IsAKitFilter (required) — Filter results by Is A Kit
• ItemClassFilter (required) — Filter results by Item Class
• ItemStatusFilter (required) — Filter results by Item Status
• ItemTypeFilter (required) — Filter results by Item Type
• LandedCostVarianceAccountFilter (required) — Filter results by Landed Cost Variance Account
• LandedCostVarianceSubaccountFilter (required) — Filter results by Landed Cost Variance Subaccount
• LastCostFilter (required) — Filter results by Last Cost
• LastModifiedFilter (required) — Filter results by Last Modified
• LastModifiedDateTimeFilter (required) — Filter results by Last Modified Date Time
• LastStdCostFilter (required) — Filter results by Last Std Cost
• LotSerialClassFilter (required) — Filter results by Lot Serial Class
• MarkupFilter (required) — Filter results by Markup
• MaxCostFilter (required) — Filter results by Max Cost
• MinCostFilter (required) — Filter results by Min Cost
• MinMarkupFilter (required) — Filter results by Min Markup
• MSRPFilter (required) — Filter results by MSRP
• PackagingOptionFilter (required) — Filter results by Packaging Option
• PackSeparatelyFilter (required) — Filter results by Pack Separately
• PendingStdCostFilter (required) — Filter results by Pending Std Cost
• POAccrualAccountFilter (required) — Filter results by PO Accrual Account
• POAccrualSubaccountFilter (required) — Filter results by PO Accrual Subaccount
• PostingClassFilter (required) — Filter results by Posting Class
• PriceClassFilter (required) — Filter results by Price Class
• PriceManagerFilter (required) — Filter results by Price Manager
• PriceWorkgroupFilter (required) — Filter results by Price Workgroup
• ProductManagerFilter (required) — Filter results by Product Manager
• ProductWorkgroupFilter (required) — Filter results by Product Workgroup
• PurchasePriceVarianceAccountFilter (required) — Filter results by Purchase Price Variance Account
• PurchasePriceVarianceSubaccountFilter (required) — Filter results by Purchase Price Variance Subaccount
• PurchaseUOMFilter (required) — Filter results by Purchase UOM
• ReasonCodeSubaccountFilter (required) — Filter results by Reason Code Subaccount
• SalesAccountFilter (required) — Filter results by Sales Account
• SalesSubaccountFilter (required) — Filter results by Sales Subaccount
• SalesUOMFilter (required) — Filter results by Sales UOM
• StandardCostRevaluationAccountFilter (required) — Filter results by Standard Cost Revaluation Account
• StandardCostRevaluationSubaccountFilter (required) — Filter results by Standard Cost Revaluation Subaccount
• StandardCostVarianceAccountFilter (required) — Filter results by Standard Cost Variance Account
• StandardCostVarianceSubaccountFilter (required) — Filter results by Standard Cost Variance Subaccount
• SubjectToCommissionFilter (required) — Filter results by Subject To Commission
• TaxCategoryFilter (required) — Filter results by Tax Category
• TariffCodeFilter (required) — Filter results by Tariff Code
• UseOnEntryFilter (required) — Filter results by Use On Entry
• ValuationMethodFilter (required) — Filter results by Valuation Method
• VolumeUOMFilter (required) — Filter results by Volume UOM
• WeightUOMFilter (required) — Filter results by Weight UOM
• CurySpecificMSRPFilter (required) — Filter results by Cury Specific MSRP
• CurySpecificPriceFilter (required) — Filter results by Cury Specific Price
• AvailabilityFilter (required) — Filter results by Availability
• CustomURLFilter (required) — Filter results by Custom URL
• ExportToExternalFilter (required) — Filter results by Export To External
• MetaDescriptionFilter (required) — Filter results by Meta Description
• MetaKeywordsFilter (required) — Filter results by Meta Keywords
• PageTitleFilter (required) — Filter results by Page Title
• SearchKeywordsFilter (required) — Filter results by Search Keywords
• TemplateItemIDFilter (required) — Filter results by Template Item ID
• VisibilityFilter (required) — Filter results by Visibility
• NotAvailableFilter (required) — Filter results by Not Available
• customFilter (required) — Custom OData $filter string (e.g. "OrderDate/value gt 2024-01-01T00:00:00")

Output shape

a list of stock items

Returns up to the system‑defined page size; may be empty if no matches.

Examples

Example 1: Filter by ABC Code and Item Status to get active kit items

Set ABCCodeFilter operator to "Contains" and value to "KIT"; set ItemStatusFilter operator to "Equals" and value to "Active".

Links

• n8n community nodes installation guide