Acumatica API - Endpoint Default 25 200 001Install

Summary

Retrieve a list of Sales Orders from Acumatica filtered by specified criteria to refine the results.

Inputs

• Approved Filter — Filter results by whether the Sales Order is approved (boolean, equals).
• Base Currency ID Filter — Filter results by Base Currency ID using operators Equals, Contains, or Starts With.
• Bill To Address Override Filter — Filter results by whether the Bill To Address Override is true or false.
• Bill To Address Validated Filter — Filter results by whether the Bill To Address has been validated (boolean, equals).
• Bill To Contact Override Filter — Filter results by whether the Bill To Contact Override is true or false.
• Branch Filter — Filter results by Branch using operators Equals, Contains, or Starts With.
• Cash Account Filter — Filter results by Cash Account using operators Equals, Contains, or Starts With.
• Contact ID Filter — Filter results by Contact ID using operators Equals, Contains, or Starts With.
• Control Total Filter — Filter results by Control Total using comparison operators like Equals, Greater Than, Less Than, etc.
• Credit Hold Filter — Filter results by whether the Sales Order is on Credit Hold (boolean, equals).
• Currency ID Filter — Filter results by Currency ID using operators Equals, Contains, or Starts With.
• Currency Rate Filter — Filter results by Currency Rate using comparison operators.
• Currency Rate Type ID Filter — Filter results by Currency Rate Type ID using operators Equals, Contains, or Starts With.
• Customer ID Filter — Filter results by Customer ID using operators Equals, Contains, or Starts With.
• Customer Order Filter — Filter results by Customer Order using operators Equals, Contains, or Starts With.
• Date Filter — Filter results by Date using date comparison operators like Equals, After, Before, etc.
• Description Filter — Filter results by Description using operators Equals, Contains, or Starts With.
• Destination Warehouse ID Filter — Filter results by Destination Warehouse ID using operators Equals, Contains, or Starts With.
• Disable Automatic Discount Update Filter — Filter results by Disable Automatic Discount Update (boolean, equals).
• Disable Automatic Tax Calculation Filter — Filter results by Disable Automatic Tax Calculation (boolean, equals).
• Effective Date Filter — Filter results by Effective Date using date comparison operators.
• External Ref Filter — Filter results by External Reference using operators Equals, Contains, or Starts With.
• Hold Filter — Filter results by Hold (boolean, equals).
• Is Tax Valid Filter — Filter results by whether the tax is valid (boolean, equals).
• Last Modified Filter — Filter results by Last Modified date using date comparison operators.
• Location ID Filter — Filter results by Location ID using operators Equals, Contains, or Starts With.
• Max Risk Score Filter — Filter results by Max Risk Score using comparison operators.
• Ordered Qty Filter — Filter results by Ordered Quantity using comparison operators.
• Order Nbr Filter — Filter results by Order Number using operators Equals, Contains, or Starts With.
• Order Total Filter — Filter results by Order Total using comparison operators.
• Order Type Filter — Filter results by Order Type using operators Equals, Contains, or Starts With.
• Payment Method Filter — Filter results by Payment Method using operators Equals, Contains, or Starts With.
• Preferred Warehouse ID Filter — Filter results by Preferred Warehouse ID using operators Equals, Contains, or Starts With.
• Project Filter — Filter results by Project using operators Equals, Contains, or Starts With.
• Reciprocal Rate Filter — Filter results by Reciprocal Rate using comparison operators.
• Requested On Filter — Filter results by Requested On date using date comparison operators.
• Ship To Address Override Filter — Filter results by whether the Ship To Address Override is true or false.
• Ship To Address Validated Filter — Filter results by whether the Ship To Address has been validated (boolean, equals).
• Ship To Contact Override Filter — Filter results by whether the Ship To Contact Override is true or false.
• Ship Via Filter — Filter results by Ship Via using operators Equals, Contains, or Starts With.
• Status Filter — Filter results by Status using operators Equals, Contains, or Starts With.
• Tax Total Filter — Filter results by Tax Total using comparison operators.
• VAT Exempt Total Filter — Filter results by VAT Exempt Total using comparison operators.
• VAT Taxable Total Filter — Filter results by VAT Taxable Total using comparison operators.
• External Order Original Filter — Filter results by whether External Order Original is true or false.
• External Refund Ref Filter — Filter results by External Refund Reference using operators Equals, Contains, or Starts With.
• Will Call Filter — Filter results by Will Call (boolean, equals).
• Payment Ref Filter — Filter results by Payment Reference using operators Equals, Contains, or Starts With.
• Usr External Order Original Filter — Filter results by Usr External Order Original (boolean, equals).
• External Order Origin Filter — Filter results by External Order Origin using operators Equals, Contains, or Starts With.
• External Order Source Filter — Filter results by External Order Source using operators Equals, Contains, or Starts With.
• Tax Calc Mode Filter — Filter results by Tax Calculation Mode using operators Equals, Contains, or Starts With.
• Created Date Filter — Filter results by Created Date using date comparison operators.
• Custom Filter — Apply an advanced OData $filter expression string to further refine the list (e.g., "CustomerID/value eq 'CUST001'").

Output shape

a list of Sales Order objects matching the applied filters

Returns an array of Sales Order records from Acumatica API. Supports multiple complex filters with OData syntax and a custom $filter string for advanced querying.

Links

• n8n community nodes installation guide