Acumatica API - Endpoint Default 25 200 001 icon

Acumatica API - Endpoint Default 25 200 001

Interact with Acumatica Endpoint Default/25.200.001

Actions478

Journal Transaction → Get List

AI-generated

Summary

Retrieve a list of journal transactions from the Acumatica ERP system, optionally filtered by various criteria such as Batch Number, Branch ID, Dates, Currency ID, Description, Hold status, Ledger ID, Module, Post Period, Status, and Transaction Date, or using a custom OData filter expression.

Inputs

  • Batch Nbr Filter — Filter results by Batch Number using operators like equals, contains, or starts with.
  • Branch ID Filter — Filter results by Branch ID using operators like equals, contains, or starts with.
  • Created Date Time Filter — Filter results by the creation date/time of the journal transaction with comparison operators such as equals, after, on or after, before, or on or before.
  • Currency ID Filter — Filter results by Currency ID using operators like equals, contains, or starts with.
  • Description Filter — Filter by the journal transaction description with operators like equals, contains, or starts with.
  • Hold Filter — Filter results by Hold status; only equality operator is supported with a boolean value.
  • Last Modified Date Time Filter — Filter results by last modification date/time using comparison operators similar to Created Date Time Filter.
  • Ledger ID Filter — Filter results by Ledger ID using operators like equals, contains, or starts with.
  • Module Filter — Filter results by Module using operators like equals, contains, or starts with.
  • Post Period Filter — Filter results by Post Period using operators like equals, contains, or starts with.
  • Status Filter — Filter results by Status using operators like equals, contains, or starts with.
  • Transaction Date Filter — Filter results by Transaction Date with comparison operators such as equals, after, on or after, before, or on or before.
  • Custom Filter — Apply an advanced custom OData $filter string in addition to or instead of standard filters, for example: CustomerID/value eq 'CUST001'.

Output shape

a list of journal transaction records matching the specified filters

Returned data includes journal transactions filtered according to provided criteria; multiple filters can be combined. The custom OData filter is applied in addition to these presets if specified. Pagination and total count behavior are subject to Acumatica API defaults and are not explicitly documented here.

Examples

Example 1: Retrieve all journal transactions with Status containing 'Open' and Currency ID equals 'USD'.

Set Status Filter to an operator 'Contains' with value 'Open'. Set Currency ID Filter operator to 'Equals' with value 'USD'.

Links

Discussion