Acumatica API - Endpoint Default 25 200 001 icon

Acumatica API - Endpoint Default 25 200 001

Interact with Acumatica Endpoint Default/25.200.001

Actions478

Cash Sale → Get List

AI-generated

Summary

Retrieve a list of Cash Sale records from Acumatica, applying optional filters to narrow down results by various fields such as Amount, Balance, Customer ID, Date, Status, and others.

Inputs

  • Amount Filter — Filter Cash Sales by their amount using operators like equals, greater than, less than, etc.
  • Balance Filter — Filter by balance amount on the Cash Sale with comparison operators.
  • Cash Account Filter — Filter Cash Sales by Cash Account with options to match exactly, contain, or start with a string.
  • Created Date Time Filter — Filter by the creation date and time of the Cash Sale using date comparisons.
  • Customer ID Filter — Filter Cash Sales by Customer ID using exact match, contains, or starts with filters.
  • Date Filter — Filter Cash Sales by their date with various date comparison operators.
  • Description Filter — Filter by text in the description field of the Cash Sale using string operators.
  • Hold Filter — Filter Cash Sales by whether the record has a hold (boolean true/false).
  • Last Modified Date Time Filter — Filter by the last modified timestamp of the Cash Sale record.
  • Payment Method Filter — Filter by Payment Method text with string matching operators.
  • Payment Ref Filter — Filter by Payment Reference string with matching operators.
  • Project Filter — Filter by Project identifier string using various string operators.
  • Reference Nbr Filter — Filter by Reference Number string with string matching options.
  • Status Filter — Filter by Status text with equals, contains, or starts with options.
  • Tax Total Filter — Filter by Tax Total amount using numeric comparison operators.
  • Type Filter — Filter by Type field text with string matching operators.
  • Custom Filter — Provide an advanced OData $filter expression string for custom filtering beyond predefined fields.

Output shape

a list of Cash Sale records matching the applied filters

Supports multiple optional filters that are combined into an OData $filter query; the output includes all fields of Cash Sale records that meet the filter criteria. Uses Acumatica API resource conventions.

Examples

Example 1: Filter Cash Sales with Amount greater than 1000 and Status containing 'Open'.

Set Amount Filter operator to 'Greater Than' and value to 1000; set Status Filter operator to 'Contains' and value to 'Open'.

Links

Discussion