Acumatica API - Endpoint Default 24 200 001Install

Summary

Retrieve a list of Sales Order records from Acumatica, filtered by numerous optional criteria such as approval status, customer ID, date ranges, amounts, and various other Sales Order fields.

Inputs

• Approved Filter — Filter results by whether the Sales Order is approved (true or false).
• Base Currency ID Filter — Filter results by the Base Currency ID, supporting operators Equals, Contains, and Starts With.
• Bill To Address Override Filter — Filter results by Bill To Address Override flag (boolean).
• Bill To Address Validated Filter — Filter results by whether the Bill To Address has been validated (boolean).
• Bill To Contact Override Filter — Filter results by Bill To Contact Override flag (boolean).
• Branch Filter — Filter results by Branch, supporting Equals, Contains, and Starts With operators.
• Cash Account Filter — Filter results by Cash Account, supporting Equals, Contains, and Starts With operators.
• Contact ID Filter — Filter results by Contact ID, supporting Equals, Contains, and Starts With operators.
• Control Total Filter — Filter results by Control Total amount with relational operators (Equals, Greater Than, Greater Than or Equal, Less Than, Less Than or Equal).
• Credit Hold Filter — Filter results by Credit Hold flag (boolean).
• Currency ID Filter — Filter results by Currency ID, supporting Equals, Contains, and Starts With operators.
• Currency Rate Filter — Filter results by Currency Rate with relational operators.
• Currency Rate Type ID Filter — Filter results by Currency Rate Type ID, supporting Equals, Contains, and Starts With operators.
• Customer ID Filter — Filter results by Customer ID, supporting Equals, Contains, and Starts With operators.
• Customer Order Filter — Filter results by Customer Order, supporting Equals, Contains, and Starts With operators.
• Date Filter — Filter results by Date with operators (Equals, After, On or After, Before, On or Before).
• Description Filter — Filter results by Description text, supporting Equals, Contains, and Starts With operators.
• Destination Warehouse ID Filter — Filter results by Destination Warehouse ID, supporting Equals, Contains, and Starts With operators.
• Disable Automatic Discount Update Filter — Filter results by Disable Automatic Discount Update flag (boolean).
• Disable Automatic Tax Calculation Filter — Filter results by Disable Automatic Tax Calculation flag (boolean).
• Effective Date Filter — Filter results by Effective Date with operators.
• External Ref Filter — Filter results by External Ref, supporting Equals, Contains, and Starts With operators.
• Hold Filter — Filter results by Hold flag (boolean).
• Is Tax Valid Filter — Filter results by whether the tax is valid (boolean).
• Last Modified Filter — Filter results by Last Modified date with operators.
• Location ID Filter — Filter results by Location ID, supporting Equals, Contains, and Starts With operators.
• Max Risk Score Filter — Filter results by Max Risk Score with relational operators.
• Ordered Qty Filter — Filter results by Ordered Quantity with relational operators.
• Order Nbr Filter — Filter results by Order Number, supporting Equals, Contains, and Starts With operators.
• Order Total Filter — Filter results by Order Total amount with relational operators.
• Order Type Filter — Filter results by Order Type, supporting Equals, Contains, and Starts With operators.
• Payment Method Filter — Filter results by Payment Method, supporting Equals, Contains, and Starts With operators.
• Preferred Warehouse ID Filter — Filter results by Preferred Warehouse ID, supporting Equals, Contains, and Starts With operators.
• Project Filter — Filter results by Project, supporting Equals, Contains, and Starts With operators.
• Reciprocal Rate Filter — Filter results by Reciprocal Rate with relational operators.
• Requested On Filter — Filter results by Requested On date with operators.
• Ship To Address Override Filter — Filter results by Ship To Address Override flag (boolean).
• Ship To Address Validated Filter — Filter results by whether Ship To Address is validated (boolean).
• Ship To Contact Override Filter — Filter results by Ship To Contact Override flag (boolean).
• Ship Via Filter — Filter results by Ship Via, supporting Equals, Contains, and Starts With operators.
• Status Filter — Filter results by Status, supporting Equals, Contains, and Starts With operators.
• Tax Total Filter — Filter results by Tax Total amount with relational operators.
• VAT Exempt Total Filter — Filter results by VAT Exempt Total amount with relational operators.
• VAT Taxable Total Filter — Filter results by VAT Taxable Total amount with relational operators.
• External Order Original Filter — Filter results by External Order Original flag (boolean).
• External Refund Ref Filter — Filter results by External Refund Reference, supporting Equals, Contains, and Starts With operators.
• Will Call Filter — Filter results by Will Call flag (boolean).
• Payment Ref Filter — Filter results by Payment Reference, supporting Equals, Contains, and Starts With operators.
• Usr External Order Original Filter — Filter results by User External Order Original flag (boolean).
• External Order Origin Filter — Filter results by External Order Origin, supporting Equals, Contains, and Starts With operators.
• External Order Source Filter — Filter results by External Order Source, supporting Equals, Contains, and Starts With operators.
• Tax Calc Mode Filter — Filter results by Tax Calculation Mode, supporting Equals, Contains, and Starts With operators.
• Created Date Filter — Filter results by Created Date with operators.
• Custom Filter — Apply an advanced custom OData $filter expression to refine results beyond standard fields.

Output shape

a list of Sales Order records matching the applied filters

Supports extensive optional filters for precise querying. The output contains multiple items, each representing a Sales Order with all available fields per Acumatica's response.

Links

• n8n community nodes installation guide