Acumatica API - Endpoint Default 25 200 001Install

Summary

Retrieve a list of Tax records from Acumatica, applying optional OData filters on multiple Tax fields to narrow the results.

Inputs

• Calculate On Filter — Filter Tax records based on the 'Calculate On' field using operators Equals, Contains, or Starts With.
• Cash Discount Filter — Filter Tax records by 'Cash Discount' using Equals, Contains, or Starts With operators.
• Created Date Time Filter — Filter Tax records by created date and time with comparison operators like Equals, After, On or After, Before, or On or Before.
• Deductible VAT Filter — Filter Tax records by Deductible VAT boolean value (Equals only).
• Description Filter — Filter Tax records by Description using Equals, Contains, or Starts With operators.
• Enter From Tax Bill Filter — Filter Tax records by boolean Enter From Tax Bill field (Equals only).
• Exclude From Taxon Tax Calculation Filter — Filter Tax records by boolean Exclude From Taxon Tax Calculation field (Equals only).
• Include In VAT Exempt Total Filter — Filter Tax records by Include In VAT Exempt Total boolean field (Equals only).
• Include In VAT Taxable Total Filter — Filter Tax records by Include In VAT Taxable Total boolean field (Equals only).
• Last Modified Date Time Filter — Filter Tax records by last modified date and time with comparison operators (Equals, After, On or After, Before, On or Before).
• Not Valid After Filter — Filter Tax records by Not Valid After date with comparison operators.
• Pending VAT Filter — Filter Tax records by Pending VAT boolean value (Equals only).
• Reverse VAT Filter — Filter Tax records by Reverse VAT boolean value (Equals only).
• Statistical VAT Filter — Filter Tax records by Statistical VAT boolean value (Equals only).
• Tax Agency Filter — Filter Tax records by Tax Agency using Equals, Contains, or Starts With operators.
• Tax Claimable Account Filter — Filter Tax records by Tax Claimable Account using Equals, Contains, or Starts With operators.
• Tax Claimable Subaccount Filter — Filter Tax records by Tax Claimable Subaccount using Equals, Contains, or Starts With operators.
• Tax Expense Account Filter — Filter Tax records by Tax Expense Account using Equals, Contains, or Starts With operators.
• Tax Expense Subaccount Filter — Filter Tax records by Tax Expense Subaccount using Equals, Contains, or Starts With operators.
• Tax ID Filter — Filter Tax records by Tax ID using Equals, Contains, or Starts With operators.
• Tax Payable Account Filter — Filter Tax records by Tax Payable Account using Equals, Contains, or Starts With operators.
• Tax Payable Subaccount Filter — Filter Tax records by Tax Payable Subaccount using Equals, Contains, or Starts With operators.
• Tax Type Filter — Filter Tax records by Tax Type using Equals, Contains, or Starts With operators.
• Custom Filter — Apply an advanced custom OData $filter expression string, combined with specified filters for fine-grained querying.

Output shape

a list of Tax records matching the applied filters

Results are filtered server-side using the constructed OData filter expressions from the input filter fields and custom filter string. Pagination or result-limiting behavior is not explicitly stated.

Examples

Example 1: Retrieve all Tax records with a Tax Type starting with 'Sales' and created after January 1, 2024.

Set the 'Tax Type Filter' with operator 'Starts With' and value 'Sales', and set the 'Created Date Time Filter' with operator 'After' and value '2024-01-01T00:00:00'.

Links

• n8n community nodes installation guide