Acumatica API - Endpoint Default 25 200 001Install

Summary

Retrieve a list of Sales Invoice records from the Acumatica ERP system, applying multiple optional filters to narrow the results.

Inputs

• Amount Filter — Filter by Amount with operators such as equals, greater than, less than, etc.
• Balance Filter — Filter by Balance with operators such as equals, greater than, less than, etc.
• Cash Discount Filter — Filter by Cash Discount with operators such as equals, greater than, less than, etc.
• Credit Hold Filter — Filter by Credit Hold status (boolean equality only).
• Currency Filter — Filter by Currency with operators equals, contains, or starts with.
• Customer ID Filter — Filter by Customer ID with operators equals, contains, or starts with.
• Customer Order Filter — Filter by Customer Order with operators equals, contains, or starts with.
• Date Filter — Filter by Date with operators like equals, after, before, on or after, on or before.
• Description Filter — Filter by Description with operators equals, contains, or starts with.
• Detail Total Filter — Filter by Detail Total with operators such as equals, greater than, less than, etc.
• Discount Total Filter — Filter by Discount Total with operators such as equals, greater than, less than, etc.
• Due Date Filter — Filter by Due Date with operators like equals, after, before, on or after, on or before.
• Is Tax Valid Filter — Filter by whether Tax is Valid (boolean equality only).
• Freight Price Filter — Filter by Freight Price with operators such as equals, greater than, less than, etc.
• Hold Filter — Filter by Hold status (boolean equality only).
• Last Modified Date Time Filter — Filter by last modified date/time with operators like equals, after, before, on or after, on or before.
• Payment Total Filter — Filter by Payment Total with operators such as equals, greater than, less than, etc.
• Project Filter — Filter by Project with operators equals, contains, or starts with.
• Reference Nbr Filter — Filter by Reference Number with operators equals, contains, or starts with.
• Status Filter — Filter by Status with operators equals, contains, or starts with.
• Tax Total Filter — Filter by Tax Total with operators such as equals, greater than, less than, etc.
• Type Filter — Filter by Type with operators equals, contains, or starts with.
• VAT Exempt Total Filter — Filter by VAT Exempt Total with operators such as equals, greater than, less than, etc.
• VAT Taxable Total Filter — Filter by VAT Taxable Total with operators such as equals, greater than, less than, etc.
• Bill To Address Override Filter — Filter by Bill To Address Override (boolean equality only).
• Bill To Contact Override Filter — Filter by Bill To Contact Override (boolean equality only).
• Created Date Filter — Filter by Created Date with operators like equals, after, before, on or after, on or before.
• External Ref Filter — Filter by External Reference with operators equals, contains, or starts with.
• Last Modified Date Filter — Filter by Last Modified Date with operators like equals, after, before, on or after, on or before.
• Ship To Address Override Filter — Filter by Ship To Address Override (boolean equality only).
• Ship To Contact Override Filter — Filter by Ship To Contact Override (boolean equality only).
• Tax Calc Mode Filter — Filter by Tax Calculation Mode with operators equals, contains, or starts with.
• Custom Filter — Provide a custom OData $filter expression string to apply advanced filter criteria beyond the provided fields.

Output shape

a list of Sales Invoice records matching the applied filters

Supports applying multiple filters combined in an OData $filter query format. Custom OData filter strings can be used for complex queries in addition to individual filters. Returns all matching Sales Invoice records as an array.

Examples

Example 1: Retrieve all sales invoices with an Amount greater than 1000 and Status containing 'Open'

Set Amount Filter operator to 'Greater Than' with value 1000, and Status Filter operator 'Contains' with value 'Open'.

Links

• n8n community nodes installation guide