Acumatica API - Endpoint Default 24 200 001Install

Summary

Retrieve a list of Sales Invoice records from Acumatica filtered by any combination of provided criteria such as amounts, dates, customer IDs, statuses, and other sales invoice attributes using OData filter syntax.

Inputs

• Amount Filter — Filter results by the Sales Invoice amount with operators like equals, greater than, less than, etc.
• Balance Filter — Filter results by the Sales Invoice balance using comparison operators.
• Cash Discount Filter — Filter results by cash discount amount.
• Credit Hold Filter — Filter results by whether the Sales Invoice is on credit hold (boolean).
• Currency Filter — Filter results by currency code with options like equals, contains, or starts with.
• Customer ID Filter — Filter results by customer identifier with string operators.
• Customer Order Filter — Filter results by customer order reference.
• Date Filter — Filter results by invoice date with date comparison operators.
• Description Filter — Filter results by invoice description text.
• Detail Total Filter — Filter by detail total amount.
• Discount Total Filter — Filter by discount total amount.
• Due Date Filter — Filter results by invoice due date.
• Is Tax Valid Filter — Filter by whether tax is valid on the invoice (boolean).
• Freight Price Filter — Filter by freight price amount.
• Hold Filter — Filter by whether the invoice is on hold (boolean).
• Last Modified Date Time Filter — Filter by last modification date and time.
• Payment Total Filter — Filter by total payments made on the invoice.
• Project Filter — Filter by project related to the invoice.
• Reference Nbr Filter — Filter by reference number with string operators.
• Status Filter — Filter by invoice status with string operators.
• Tax Total Filter — Filter by total tax amount on the invoice.
• Type Filter — Filter by type of invoice.
• VAT Exempt Total Filter — Filter by total VAT exempt amount.
• VAT Taxable Total Filter — Filter by total VAT taxable amount.
• Bill To Address Override Filter — Filter by whether billing address override is set (boolean).
• Bill To Contact Override Filter — Filter by whether billing contact override is set (boolean).
• Created Date Filter — Filter by invoice creation date.
• External Ref Filter — Filter by external reference with string operators.
• Last Modified Date Filter — Filter by last modified date (date-only).
• Ship To Address Override Filter — Filter by whether shipping address override is set (boolean).
• Ship To Contact Override Filter — Filter by whether shipping contact override is set (boolean).
• Tax Calc Mode Filter — Filter by tax calculation mode.
• Custom Filter — Apply an advanced custom OData $filter expression to further filter results, in addition to standard filters.

Output shape

a list of Sales Invoice records each containing fields matching the filter criteria

Filters accept various operators such as equals, greater than, less than, contains, and support date, boolean, numeric, and string types. Custom OData filter expressions can be provided in addition to the built-in filters to refine the query. Returned data reflects the filtered subset of all Sales Invoice records.

Links

• n8n community nodes installation guide