Acumatica API - Endpoint Default 23 200 001 icon

Acumatica API - Endpoint Default 23 200 001

Interact with Acumatica Endpoint Default/23.200.001

Actions478

Cash Sale → Get List

AI-generated

Summary

Acumatica API - Cash Sale Get List

Inputs

  • AmountFilter — Filter by amount using operator (eq, gt, ge, lt, le) and numeric value
  • BalanceFilter — Filter by balance using operator and numeric value
  • CashAccountFilter — Filter by cash account using operator (eq, contains, startswith) and string value
  • CreatedDateTimeFilter — Filter by creation date using operator (eq, gt, ge, lt, le) and date value
  • CustomerIDFilter — Filter by customer ID using operator (eq, contains, startswith) and string value
  • DateFilter — Filter by date using operator (eq, gt, ge, lt, le) and date value
  • DescriptionFilter — Filter by description using operator (eq, contains, startswith) and string value
  • HoldFilter — Filter by hold status using operator eq and boolean value
  • LastModifiedDateTimeFilter — Filter by last modified date using operator (eq, gt, ge, lt, le) and date value
  • PaymentMethodFilter — Filter by payment method using operator (eq, contains, startswith) and string value
  • PaymentRefFilter — Filter by payment reference using operator (eq, contains, startswith) and string value
  • ProjectFilter — Filter by project using operator (eq, contains, startswith) and string value
  • ReferenceNbrFilter — Filter by reference number using operator (eq, contains, startswith) and string value
  • StatusFilter — Filter by status using operator (eq, contains, startswith) and string value
  • TaxTotalFilter — Filter by tax total using operator (eq, gt, ge, lt, le) and numeric value
  • TypeFilter — Filter by type using operator (eq, contains, startswith) and string value
  • customFilter — Advanced OData $filter expression (e.g. CustomerID/value eq 'CUST001') applied in addition to other filters

Output shape

Array of Cash Sale records matching all specified filter criteria. Each record contains Cash Sale fields as defined by the Acumatica API schema.

All filter fields have displayOptions showing only for the 'getList' operation on CashSale resource. Filter values with default/empty states are skipped during request construction. The customFilter field accepts OData expressions combining field/operator/value with proper quoting for strings and unquoted for numbers/dates.

Examples

Example 1: Filter Cash Sales by Amount > 500

Set AmountFilter operator to 'gt' and value to 500

Example 2: Filter by Customer and Date Range

Set CustomerIDFilter to eq 'CUST001' and DateFilter to ge '2024-01-01'

Links

Discussion