Acumatica API - Endpoint Default 23 200 001 icon

Acumatica API - Endpoint Default 23 200 001

Interact with Acumatica Endpoint Default/23.200.001

Actions478

Sales Prices Inquiry → Get List

AI-generated

Summary

Retrieve a list of Sales Price Inquiry records filtered by optional criteria

Inputs

  • EffectiveAsOfFilter — Filter results by Effective As Of
  • InventoryIDFilter — Filter results by Inventory ID
  • ItemClassIDFilter — Filter results by Item Class ID
  • PriceClassFilter — Filter results by Price Class
  • PriceCodeFilter — Filter results by Price Code
  • PriceManagerFilter — Filter results by Price Manager
  • PriceManagerIsMeFilter — Filter results by Price Manager Is Me
  • PriceTypeFilter — Filter results by Price Type
  • PriceWorkgroupFilter — Filter results by Price Workgroup
  • PriceWorkgroupIsMineFilter — Filter results by Price Workgroup Is Mine
  • TaxCalculationModeFilter — Filter results by Tax Calculation Mode
  • customFilter — Advanced OData $filter expression (e.g. CustomerID/value eq 'CUST001'). Applied in addition to any filter fields above or custom OData $filter string (e.g. "OrderDate/value gt 2024-01-01T00:00:00")

Output shape

a list of Sales Price Inquiry records

Pagination may be limited by Acumatica; optional fields can be omitted; errors are wrapped in a standard Acumatica error envelope

Examples

Example 1: Filter by Effective As Of date after a specific value

Set EffectiveAsOfFilter operator to "ge" and value to "2024-01-01T00:00:00"

Example 2: Apply a custom OData filter

Enter customFilter as "InventoryID/value eq '12345' and Price/value gt 100"

Example 3: Retrieve all records with no filters

Leave all filter fields empty; optionally set customFilter to an empty string

Links

Discussion