Native ACCOUNTING Filter Support Matrix

This shows the support for native filters across different ACCOUNTING platforms, with exceptions noted below.

Filter Type	Netsuite	Quickbooks	Xero
`accounting_items_created_after`	A	A	NA
`accounting_items_created_before`	A	A	NA
`accounting_items_updated_after`	A	A	A
`accounting_items_updated_before`	A	A	NA
`accounting_items_item_type[]`	A	A	A
`accounting_items_status[]`	A	A	NA

Remarks

Filters are organized into logical categories that can be combined to narrow down your search results. Here are the common types of filters:

Different ACCOUNTINGs handle combinations of these filter types differently.

All active filters are combined using AND. A record must match every condition. For example: (created_after = XYZ AND updated_before = ABC AND status IN [...])
accounting_items_item_type[] accepted values: INVENTORY, nonInventoryPurchase, nonInventoryResale, nonInventorySale, servicePurchase, serviceResale, serviceSale, otherChargePurchase, otherChargeResale, otherChargeSale
accounting_items_status[] accepted values: ACTIVE, ARCHIVED
Only a single status value is evaluated; if multiple are provided, only the first is applied.

All active filters are combined using AND. A record must match every condition. For example: (created_after = XYZ AND updated_before = ABC AND status IN [...])
accounting_items_item_type[] accepted values: INVENTORY, SERVICE, NON_INVENTORY
accounting_items_status[] accepted values: ACTIVE, ARCHIVED
Only a single status value is evaluated; if multiple are provided, only the first is applied.

accounting_items_item_type[] accepted values: INVENTORY, NON_INVENTORY
- Filtering only applies when one type is specified. If both INVENTORY and NON_INVENTORY are provided, no type filter is applied and all items are returned.

Updated 1 minute ago