Acumatica API - Endpoint Default 24 200 001Install

Summary

Retrieve a filtered list of Tax records from the Acumatica API using various specified filter criteria.

Inputs

• Calculate On Filter — Filter results by 'Calculate On' field using operators Equals, Contains, or Starts With with a string value.
• Cash Discount Filter — Filter results by 'Cash Discount' field using operators Equals, Contains, or Starts With with a string value.
• Created Date Time Filter — Filter results by 'Created Date Time' using date/time comparison operators Equals, After, On or After, Before, or On or Before.
• Deductible VAT Filter — Filter results by 'Deductible VAT' field using the Equals operator with a boolean value.
• Description Filter — Filter results by 'Description' using operators Equals, Contains, or Starts With with a string value.
• Enter From Tax Bill Filter — Filter results by 'Enter From Tax Bill' using the Equals operator with a boolean value.
• Exclude From Taxon Tax Calculation Filter — Filter results by 'Exclude From Taxon Tax Calculation' using the Equals operator with a boolean value.
• Include In VAT Exempt Total Filter — Filter results by 'Include In VAT Exempt Total' using the Equals operator with a boolean value.
• Include In VAT Taxable Total Filter — Filter results by 'Include In VAT Taxable Total' using the Equals operator with a boolean value.
• Last Modified Date Time Filter — Filter results by 'Last Modified Date Time' using date/time comparison operators Equals, After, On or After, Before, or On or Before.
• Not Valid After Filter — Filter results by 'Not Valid After' using date/time comparison operators Equals, After, On or After, Before, or On or Before.
• Pending VAT Filter — Filter results by 'Pending VAT' using the Equals operator with a boolean value.
• Reverse VAT Filter — Filter results by 'Reverse VAT' using the Equals operator with a boolean value.
• Statistical VAT Filter — Filter results by 'Statistical VAT' using the Equals operator with a boolean value.
• Tax Agency Filter — Filter results by 'Tax Agency' using operators Equals, Contains, or Starts With with a string value.
• Tax Claimable Account Filter — Filter results by 'Tax Claimable Account' using operators Equals, Contains, or Starts With with a string value.
• Tax Claimable Subaccount Filter — Filter results by 'Tax Claimable Subaccount' using operators Equals, Contains, or Starts With with a string value.
• Tax Expense Account Filter — Filter results by 'Tax Expense Account' using operators Equals, Contains, or Starts With with a string value.
• Tax Expense Subaccount Filter — Filter results by 'Tax Expense Subaccount' using operators Equals, Contains, or Starts With with a string value.
• Tax ID Filter — Filter results by 'Tax ID' using operators Equals, Contains, or Starts With with a string value.
• Tax Payable Account Filter — Filter results by 'Tax Payable Account' using operators Equals, Contains, or Starts With with a string value.
• Tax Payable Subaccount Filter — Filter results by 'Tax Payable Subaccount' using operators Equals, Contains, or Starts With with a string value.
• Tax Type Filter — Filter results by 'Tax Type' using operators Equals, Contains, or Starts With with a string value.
• Custom Filter — Provide an advanced custom OData $filter string expression to apply in addition to any above filters (e.g. "CustomerID/value eq 'CUST001'").

Output shape

a list of Tax records matching the combined OData filters.

The output includes all Tax records that satisfy the specified filters combined as an OData $filter query. Boolean filters accept only equality checks. String filters support equals, contains, and starts with operators. Date filters support equality and range comparison operators. The customFilter input lets users specify complex OData expressions for further refinement.

Examples

Example 1: Retrieve all Tax records with Tax Type starting with 'Sales' and Created Date Time on or after 2023-01-01.

Set Tax Type Filter operator to 'Starts With' with value 'Sales'. Set Created Date Time Filter operator to 'On or After' with value '2023-01-01T00:00:00'.

Links

• n8n community nodes installation guide