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 | Microsoft Dynamics Business Central | Freshbooks | Zohobook | Sage 200 Standard | SAP S/4HANA Cloud Public Edition |
|---|---|---|---|---|---|---|---|---|
accounting_items_created_after | A | A | NA | NA | NA | NA | NA | A |
accounting_items_created_before | A | A | NA | NA | NA | NA | NA | A |
accounting_items_updated_after | A | A | A | NA | NA | NA | NA | A |
accounting_items_updated_before | A | A | NA | NA | NA | NA | NA | A |
accounting_items_item_type[] | A | A | A | NA | NA | NA | NA | A |
accounting_items_status[] | A | A | NA | NA | NA | NA | NA | A |
accounting_accounts_created_after | NA | A | NA | NA | A | NA | A | A |
accounting_accounts_created_before | NA | A | NA | NA | A | NA | A | A |
accounting_accounts_updated_after | A | A | A | A | NA | A | A | A |
accounting_accounts_updated_before | A | A | A | A | NA | NA | A | A |
accounting_accounts_type[] | A | A | A | A | NA | A | A | NA |
accounting_accounts_status[] | A | A | A | A | A | A | A | NA |
accounting_accounts_name[] | NA | A | A | A | NA | A | A | NA |
accounting_accounts_company_id[] | NA | NA | NA | NA | NA | NA | NA | NA |
accounting_contacts_created_after | A | A | NA | NA | NA | NA | A | A |
accounting_contacts_created_before | A | A | NA | NA | NA | NA | A | A |
accounting_contacts_updated_after | A | A | A | A | A | NA | A | A |
accounting_contacts_updated_before | A | A | A | A | A | NA | A | A |
accounting_contacts_contact_type[] | A | A | A | A | A | A | A | NA |
accounting_contacts_status[] | A | A | A | NA | A | A | A | A |
accounting_contacts_name[] | NA | A | A | A | NA | A | A | A |
accounting_contacts_company_id[] | A | NA | NA | NA | NA | NA | NA | NA |
accounting_invoices_created_after | A | A | A | A | A | A | NA | A |
accounting_invoices_created_before | A | A | A | A | A | A | NA | A |
accounting_invoices_updated_after | A | A | A | A | A | A | NA | A |
accounting_invoices_updated_before | A | A | A | A | A | NA | NA | A |
accounting_invoices_invoice_contact_id[] | A | A | A | A | A | A | A | A |
accounting_invoices_bill_contact_id[] | A | A | A | A | A | A | A | A |
accounting_invoices_type[] | A | A | A | A | A | A | A | A |
accounting_invoices_status[] | NA | A | A | A | A | A | NA | A |
accounting_invoices_due_date | A | A | A | A | NA | A | A | NA |
accounting_invoices_bill_number[] | A | A | A | A | NA | A | A | A |
accounting_invoices_invoice_number[] | A | A | A | A | A | A | A | A |
accounting_payments_created_after | A | A | A | NA | A | NA | NA | A |
accounting_payments_created_before | A | A | A | NA | A | NA | NA | A |
accounting_payments_updated_after | A | A | A | A | A | A | NA | A |
accounting_payments_updated_before | A | A | NA | A | A | NA | NA | A |
accounting_payments_invoice_account_id[] | NA | NA | A | A | NA | NA | NA | NA |
accounting_payments_bill_account_id[] | NA | NA | A | A | NA | NA | NA | NA |
accounting_payments_vendor_id[] | A | A | A | NA | NA | A | A | A |
accounting_payments_customer_id[] | A | A | A | NA | A | A | A | A |
accounting_payments_status[] | NA | NA | NA | NA | NA | NA | NA | A |
accounting_payments_payment_linked_to[] | A | A | NA | NA | A | A | A | A |
accounting_expenses_created_after | A | A | NA | NA | NA | NA | NA | NA |
accounting_expenses_created_before | A | A | NA | NA | NA | NA | NA | NA |
accounting_expenses_updated_after | A | A | NA | NA | NA | NA | NA | NA |
accounting_expenses_updated_before | A | A | NA | NA | NA | NA | NA | NA |
accounting_journalEntries_created_after | A | A | NA | NA | NA | NA | NA | NA |
accounting_journalEntries_created_before | A | A | NA | NA | NA | NA | NA | NA |
accounting_journalEntries_updated_after | A | A | A | A | NA | A | NA | NA |
accounting_journalEntries_updated_before | A | A | NA | A | NA | NA | NA | NA |
accounting_journalEntries_status[] | NA | NA | NA | NA | NA | A | NA | NA |
accounting_purchaseOrders_created_after | A | A | A | A | NA | A | A | A |
accounting_purchaseOrders_created_before | A | A | A | A | NA | A | A | A |
accounting_purchaseOrders_updated_after | A | A | A | A | NA | A | A | A |
accounting_purchaseOrders_updated_before | A | A | NA | A | NA | NA | A | A |
accounting_purchaseOrders_status[] | NA | NA | A | NA | NA | A | A | A |
accounting_employees_created_after | A | A | NA | NA | NA | NA | NA | NA |
accounting_employees_created_before | A | A | NA | NA | NA | NA | NA | NA |
accounting_employees_updated_after | A | A | NA | A | NA | NA | NA | NA |
accounting_employees_updated_before | A | A | NA | A | NA | NA | NA | NA |
accounting_employees_status[] | A | A | NA | A | NA | NA | NA | 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,ARCHIVEDaccounting_contacts_contact_type[]accepted values:CUSTOMER,VENDORaccounting_accounts_type[]accepted values:BANK_ACCOUNT,LEDGER_ACCOUNTaccounting_accounts_status[]accepted values:ACTIVE,INACTIVEaccounting_contacts_status[]accepted values:ACTIVE,INACTIVEaccounting_invoices_type[]accepted values:INVOICE,BILLaccounting_payments_payment_linked_to[]accepted values:INVOICE,BILLaccounting_employees_status[]accepted values:ACTIVE,INACTIVE
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,ARCHIVEDaccounting_contacts_contact_type[]accepted values:CUSTOMER,VENDORaccounting_accounts_type[]accepted values:BANK_ACCOUNT,LEDGER_ACCOUNTaccounting_accounts_status[]accepted values:ACTIVE,INACTIVEaccounting_contacts_status[]accepted values:ACTIVE,INACTIVEaccounting_invoices_type[]accepted values:INVOICE,BILLaccounting_invoices_status[]accepted values:PAID,DUEaccounting_employees_status[]accepted values:ACTIVE,INACTIVE
Xero
accounting_items_item_type[]accepted values:INVENTORY,NON_INVENTORYaccounting_accounts_type[]accepted values:BANK_ACCOUNT,LEDGER_ACCOUNTaccounting_accounts_status[]accepted values:ACTIVE,INACTIVEaccounting_contacts_contact_type[]accepted values:CUSTOMER,VENDORaccounting_contacts_status[]accepted values:ACTIVE,INACTIVEaccounting_invoices_type[]accepted values:INVOICE,BILLaccounting_invoices_status[]accepted values:DRAFT,VOID,PAID,SENTaccounting_purchaseOrders_status[]accepted values:DRAFT,AUTHORISED,BILLED,DELETED
SAP S/4HANA Cloud Public Edition
- Date filters (
created_after,created_before,updated_after,updated_before) are combined with AND among themselves. Every other filter (status,type, contact/vendor/customer id,name, number filters, etc.) is combined with OR - including across different filter types, not just multiple values within one filter. The date-AND-group and the everything-else-OR-group are then combined with AND. For example:(created_after = X AND updated_before = Y) AND (status = A OR vendor_id IN [...])- so passing bothstatusand avendor_idtogether returns records matching either, not both. accounting_items_item_type[]accepted values:INVENTORY,SERVICE,NON_INVENTORYaccounting_items_status[]accepted values:ACTIVE,ARCHIVEDaccounting_contacts_status[]accepted values:ACTIVE,INACTIVEaccounting_invoices_type[]accepted values:INVOICE,BILLaccounting_invoices_status[]accepted values:ACCOUNTED,OPENfortype: INVOICE;ACCOUNTED,SUBMITTED,CANCELLED,DRAFTfortype: BILLaccounting_invoices_updated_after/accounting_invoices_updated_beforeare only honored fortype: INVOICE- the underlying SAP entity fortype: BILLhas no equivalent change-timestamp field wired up.accounting_payments_status[]accepted values:SUCCESS,PENDINGaccounting_payments_payment_linked_to[]accepted values:INVOICE,BILLaccounting_payments_vendor_id[]/accounting_payments_customer_id[]are only meaningful whentypematches (VENDOR/CUSTOMERrespectively) - passing the other one isn't an error, it just won't match anything.accounting_purchaseOrders_status[]accepted values:DRAFT,OPEN,SUBMITTED,APPROVED,CANCELLED
Updated 15 days ago
Did this page help you?