Filters supported for QuickBooks Desktop

See Filters for how to use them.

AP Invoice

• issue_date: <=, >=, =
• number: <=, >=, =
• source_update_time: : <=, >=, =, BETWEEN
• status: =
• vendor_id: =

AP Payment

• ledger_account_id: =
• number: <=, >=, =
• payment_date: <=, >=, =
• source_update_time: : <=, >=, =, BETWEEN
• vendor_id: =

AR Invoice

• customer_id: =
• number: <=, >=, =
• issue_date: <=, >=, =
• status: =
• source_update_time: : <=, >=, =, BETWEEN

AR Payment

• customer_id: =
• ledger_account_id: =
• number: <=, >=, =
• source_update_time: : <=, >=, =, BETWEEN
• transaction_date: <=, >=, =

Bank Account

• currency_code: =
• name: =, ILIKE, BETWEEN
• source_update_time: : <=, >=, =, BETWEEN
• status: =
• type: =

Customer

• balance: =, <, <=, >, >=
• name: =, ILIKE, BETWEEN
• source_update_time: : <=, >=, =, BETWEEN
• status: =

Estimate

• customer_id: =
• issue_date: <=, >=, =
• source_update_time: : <=, >=, =, BETWEEN

Expense

• bank_account_id: =
• number: <=, >=, =
• payment_date: <=, >=, =
• source_update_time: : <=, >=, =, BETWEEN
• vendor_id: =

Item

• name: =, ILIKE, BETWEEN
• source_update_time: : <=, >=, =, BETWEEN
• status: =

Ledger Account

• currency_code: =
• name: =, ILIKE, BETWEEN
• source_update_time: : <=, >=, =, BETWEEN
• status: =
• type: =

Purchase Order

• number: <=, >=, =
• order_date: <=, >=, =
• source_update_time: : <=, >=, =, BETWEEN
• vendor_id: =

Vendor

• name: =, ILIKE, BETWEEN
• source_update_time: : <=, >=, =, BETWEEN
• status: =