Acumatica API - Endpoint Default 23 200 001Install

Summary

Retrieve a filtered list of Invoice records from Acumatica using OData query parameters.

Inputs

• AmountFilter — Filter results by Amount using an operator (eq, gt, ge, lt, le) and a numeric value.
• BalanceFilter — Filter results by Balance using an operator (eq, gt, ge, lt, le) and a numeric value.
• BillingPrintedFilter — Filter results by Billing Printed using an operator (eq) and a boolean value.
• BillToContactOverrideFilter — Filter results by Bill To Contact Override using an operator (eq) and a boolean value.
• CreatedDateTimeFilter — Filter results by Created Date Time using an operator (eq, After, On or After, Before, On or Before) and a dateTime value.
• CustomerFilter — Filter results by Customer using an operator (Equals, Contains, Starts With) and a string value.
• CustomerOrderFilter — Filter results by Customer Order using an operator (Equals, Contains, Starts With) and a string value.
• DateFilter — Filter results by Date using an operator (eq, After, On or After, Before, On or Before) and a dateTime value.
• DescriptionFilter — Filter results by Description using an operator (Equals, Contains, Starts With) and a string value.
• DueDateFilter — Filter results by Due Date using an operator (eq, After, On or After, Before, On or Before) and a dateTime value.
• HoldFilter — Filter results by Hold using an operator (eq) and a boolean value.
• LastModifiedDateTimeFilter — Filter results by Last Modified Date Time using an operator (eq, After, On or After, Before, On or Before) and a dateTime value.
• LinkARAccountFilter — Filter results by Link AR Account using an operator (Equals, Contains, Starts With) and a string value.
• LinkBranchFilter — Filter results by Link Branch using an operator (Equals, Contains, Starts With) and a string value.
• LocationIDFilter — Filter results by Location ID using an operator (Equals, Contains, Starts With) and a string value.
• PostPeriodFilter — Filter results by Post Period using an operator (Equals, Contains, Starts With) and a string value.
• ProjectFilter — Filter results by Project using an operator (Equals, Contains, Starts With) and a string value.
• ReferenceNbrFilter — Filter results by Reference Nbr using an operator (Equals, Contains, Starts With) and a string value.
• StatusFilter — Filter results by Status using an operator (Equals, Contains, Starts With) and a string value.
• ShipToContactOverrideFilter — Filter results by Ship To Contact Override using an operator (eq) and a boolean value.
• IsTaxValidFilter — Filter results by Is Tax Valid using an operator (eq) and a boolean value.
• TaxTotalFilter — Filter results by Tax Total using an operator (eq, gt, ge, lt, le) and a numeric value.
• TermsFilter — Filter results by Terms using an operator (Equals, Contains, Starts With) and a string value.
• TypeFilter — Filter results by Type using an operator (Equals, Contains, Starts With) and a string value.
• customFilter — Advanced OData $filter expression (e.g., CustomerID/value eq 'CUST001') or any custom OData $filter string.

Output shape

list of Invoice records

The operation returns a collection of Invoice objects; pagination is controlled by the Acumatica server, and an empty list is returned when no records match the filters.

Examples

Example 1: Get all invoices with Amount greater than 1000

Set AmountFilter operator to 'gt' and value to 1000; leave other filters empty.

Example 2: Retrieve invoices for a specific customer using advanced OData

Set CustomerFilter Operator to 'Contains' and Value to 'ACME', then fill customFilter with "Customer eq 'ACME'"

Links

• n8n community nodes installation guide