Acumatica API - Endpoint Default 24 200 001Install

Summary

Retrieves a list of Acumatica Bills based on specified filters or a custom OData $filter expression.

Inputs

• AmountFilter — Filters results by Amount using an operator (e.g., equals, greater than).
• ApprovedForPaymentFilter — Filters results by Approved For Payment status.
• BalanceFilter — Filters results by Balance using an operator (e.g., equals, less than).
• BranchIDFilter — Filters results by Branch ID using an operator (e.g., equals, contains).
• CashAccountFilter — Filters results by Cash Account using an operator (e.g., equals, contains).
• CurrencyIDFilter — Filters results by Currency ID using an operator (e.g., equals, contains).
• DateFilter — Filters results by Date using an operator (e.g., on or after, before).
• DescriptionFilter — Filters results by Description using an operator (e.g., contains, starts with).
• DueDateFilter — Filters results by Due Date using an operator (e.g., on or after, before).
• HoldFilter — Filters results by Hold status.
• LocationIDFilter — Filters results by Location ID using an operator (e.g., equals, contains).
• PostPeriodFilter — Filters results by Post Period using an operator (e.g., equals, contains).
• ProjectFilter — Filters results by Project using an operator (e.g., equals, contains).
• ReferenceNbrFilter — Filters results by Reference Number using an operator (e.g., equals, contains).
• StatusFilter — Filters results by Status using an operator (e.g., equals, contains).
• TaxTotalFilter — Filters results by Tax Total using an operator (e.g., greater than, less than).
• TermsFilter — Filters results by Terms using an operator (e.g., equals, contains).
• TypeFilter — Filters results by Type using an operator (e.g., equals, contains).
• VendorFilter — Filters results by Vendor using an operator (e.g., equals, contains).
• VendorRefFilter — Filters results by Vendor Reference using an operator (e.g., equals, contains).
• IsTaxValidFilter — Filters results by Is Tax Valid status.
• LastModifiedDateTimeFilter — Filters results by Last Modified Date Time using an operator (e.g., after, before).
• customFilter — Advanced OData $filter expression applied in addition to other filter fields (e.g., CustomerID/value eq 'CUST001').

Output shape

A list of Bill records from Acumatica.

The source code generates these properties dynamically from the Acumatica OpenAPI schema. The operation constructs an OData $filter string from the selected filter parameters and sends it to the Acumatica API endpoint. Parameters with default or empty values are skipped.

Examples

Example 1: Retrieve all open bills greater than $5,000.

Set AmountFilter to 'Greater Than or Equal' with value 5000.

Example 2: Filter bills by vendor and status.

Set VendorFilter to 'Equals' and StatusFilter to 'Contains' to match specific criteria.

Example 3: Use a custom OData filter for complex queries.

Set customFilter to 'Date/value ge 2024-01-01T00:00:00' to get bills from a specific date.

Links

• n8n community nodes installation guide