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:
-
Date -
created_after,updated_before, etc. -
Type -
type[] -
Status -
status[]
Different ACCOUNTINGs handle combinations of these filter types differently.
Netsuite
- 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,otherChargeSaleaccounting_items_status[]accepted values:ACTIVE,ARCHIVED
QuickBooks
- 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_INVENTORYaccounting_items_status[]accepted values:ACTIVE,ARCHIVED
Xero
accounting_items_item_type[]accepted values:INVENTORY,NON_INVENTORY
Updated 15 days ago