Acumatica API - Endpoint Default 25 200 001Install

Summary

Retrieve a list of Invoice records from the Acumatica API, optionally filtered by multiple property-based criteria using OData syntax.

Inputs

• Amount Filter — Filter results by the invoice Amount using operators like equals, greater than, less than, etc.
• Balance Filter — Filter results by the invoice Balance with operators such as equals or comparisons.
• Billing Printed Filter — Boolean filter to include only invoices where Billing Printed equals the specified value.
• Bill To Contact Override Filter — Boolean filter for invoices matching the Bill To Contact Override flag.
• Created Date Time Filter — Filter invoices by Created Date and Time with date comparisons like equals, after, before, etc.
• Customer Filter — Filter by Customer field using operators equals, contains, or starts with.
• Customer Order Filter — Filter by Customer Order with string matching operators.
• Date Filter — Filter by Date field using various date/time comparison operators.
• Description Filter — Filter invoices by Description using string operators such as contains or equals.
• Due Date Filter — Filter by Due Date with date comparison operators.
• Hold Filter — Boolean filter for the Hold status of invoices.
• Last Modified Date Time Filter — Filter by last modification date and time using comparison operators.
• Link AR Account Filter — Filter invoices by Link AR Account with string operators.
• Link Branch Filter — Filter invoices by Link Branch using string match operators.
• Location ID Filter — Filter by Location ID with string matching.
• Post Period Filter — Filter by Post Period using string operators.
• Project Filter — Filter invoices relating to a specific Project using string operators.
• Reference Nbr Filter — Filter by Reference Number using string matching.
• Status Filter — Filter invoices by Status text values using string operators.
• Ship To Contact Override Filter — Boolean filter for the Ship To Contact Override attribute.
• Is Tax Valid Filter — Boolean filter indicating whether the tax status is valid.
• Tax Total Filter — Filter by Tax Total amount with numeric comparison operators.
• Terms Filter — Filter invoices by Terms string with operators like contains or equals.
• Type Filter — Filter invoices by Type field using string comparison operators.
• Custom Filter — Apply an advanced custom OData $filter expression to refine invoice list results.

Output shape

a list of Invoice records matching the specified filter criteria

The output is a list of invoices returned from the Acumatica API, filtered by any combination of the provided criteria. Filters are applied as OData $filter queries. The 'Custom Filter' allows advanced OData expressions supplementing the predefined filtering options.

Links

• n8n community nodes installation guide