Field Type | Description |
|---|---|
Object | Select Object for which you want to assign filter fields. |
Filter By | Select the Filter Field. |
Operator | Select the corresponding operator. |
Filter Value | Enter the Filter value. |
Object | Filters | Operators |
|---|---|---|
Accounts | ID | = |
Name | =,startswith, endswith, contains | |
Type | = | |
IsActive | = | |
TimeModified | =,>, >=, <, <= | |
BillExpenseItems, BillLineItems, Bills, BillLinkedTransactions | ID | = |
Date | =,>, >=, <, <= | |
ReferenceNumber | =,startswith, endswith, contains | |
VendorName | = | |
VendorId | =,>, >=, <, <= | |
AccountsPayable | = | |
AccountsPayableId | = | |
IsPaid | = | |
TimeModified | =,>, >=, <, <= | |
BillPaymentChecks, BillPaymentChecksAppliedTo, BillPaymentCreditCards, BillPaymentCreditCardsAppliedTo | ID | = |
Date | =,>, >=, <, <= | |
ReferenceNumber | =,startswith, endswith, contains | |
PayeeName | = | |
PayeeId | = | |
AccountsPayable | = | |
AccountsPayableId | = | |
IsPaid | = | |
TimeModified | =,>, >=, <, <= | |
CheckExpenseItems, CheckLineItems, Checks | ID | = |
Date | =,>, >=, <, <= | |
ReferenceNumber | =,startswith, endswith, contains | |
PayeeName | = | |
PayeeId | = | |
Account | = | |
AccountId | = | |
IsPaid | = | |
TimeModified | =,>, >=, <, <= | |
Class | ID | = |
Name | =,startswith, endswith, contains | |
IsActive | = | |
CreditCardChargeExpenseItems, CreditCardChargeLineItems, CreditCardCharges, CreditCardCreditExpenseItems, CreditCardCreditLineItems, CreditCardCredits | ID | = |
Date | =,>, >=, <, <= | |
ReferenceNumber | =,startswith, endswith, contains | |
Account | = | |
AccountId | = | |
TimeModified | =,>, >=, <, <= | |
CreditMemoLineItems, CreditMemos | ID | = |
Date | =,>, >=, <, <= | |
ReferenceNumber | =,startswith, endswith, contains | |
CsutomerName | = | |
CustomerId | = | |
AccountRecieveable | = | |
AccountsReceivableId | = | |
TimeModified | =,>, >=, <, <= | |
Customers | ID | = |
Date | =,>, >=, <, <= | |
IsActive | =,startswith, endswith, contains | |
Balance | =,>, >=, <, <= | |
TimeModified | =,>, >=, <, <= | |
DateDrivenTerms | Name | =,startswith, endswith, contains |
IsActive | = | |
TimeModified | =,>, >=, <, <= | |
DepositLineItems, Deposits | ID | = |
Date | =,>, >=, <, <= | |
DepositToAccount | = | |
DepositToAccountId | = | |
TimeModified | =,>, >=, <, <= | |
EmployeeEarnings, Employees, | ID | = |
Name | =,startswith, endswith, contains | |
IsActive | = | |
TimeModified | =,>, >=, <, <= | |
EstimateLineItems, Estimates | ID | = |
Date | =,>, >=, <, <= | |
ReferenceNumber | =,startswith, endswith, contains | |
CustomerName | = | |
CustomerId | = | |
TimeModified | =,>, >=, <, <= | |
InventoryAdjustmentLineItems, InventoryAdjustments, | ID | = |
Date | =,>, >=, <, <= | |
ReferenceNumber | =,startswith, endswith, contains | |
CustomerName | = | |
CustomerId | = | |
Account | = | |
AccountId | = | |
TimeModified | =,>, >=, <, <= | |
InvoiceLineItems, Invoices | ID | = |
Date | =,>, >=, <, <= | |
ReferenceNumber | =,startswith, endswith, contains | |
CustomerName | = | |
CustomerId | = | |
Account | = | |
AccountId | = | |
IsPaid | = | |
TimeModified | =,>, >=, <, <= | |
ItemLineItems, Items, | ID | = |
Name | =,startswith, endswith, contains | |
Type | = | |
IsActive | = | |
TimeModified | =,>, >=, <, <= | |
ItemReceiptExpenseItems, ItemReceiptLineItems, ItemReceipts, | ID | = |
Date | =,>, >=, <, <= | |
ReferenceNumber | =,startswith, endswith, contains | |
VendorName | = | |
VendorId | = | |
Payee | = | |
PayeeId | = | |
Account | = | |
AccountId | = | |
IsPaid | = | |
TimeModified | =,>, >=, <, <= | |
JournalEntries, JournalEntryLines, | ID | = |
Date | =,>, >=, <, <= | |
TimeCreated | = | |
VendorName | = | |
VendorId | = | |
LineEntityName | = | |
LineEntityId | = | |
LineAccount | = | |
LineAccountId | = | |
IsPaid | = | |
TimeModified | =,>, >=, <, <= | |
PurchaseOrderLineItems, purchaseOrders | ID | = |
Date | =,>, >=, <, <= | |
ReferenceNumber | =,startswith, endswith, contains | |
VendorName | = | |
VendorId | = | |
TimeModified | =,>, >=, <, <= | |
ReceivePayments, ReceivePaymentsAppliedTo, SalesReceiptLineItems, SalesReceipts, | ID | = |
Date | =,>, >=, <, <= | |
ReferenceNumber | =,startswith, endswith, contains | |
CustomerName | = | |
CustomerId | = | |
DepositToAccountName | = | |
DepositToAccountId | = | |
TimeModified | =,>, >=, <, <= | |
SalesOrderLineItems, SalesOrders, | ID | = |
Date | =,>, >=, <, <= | |
ReferenceNumber | =,startswith, endswith, contains | |
CustomerName | = | |
CustomerId | = | |
TimeModified | =,>, >=, <, <= | |
SalesReps, ShippingMethods, StandardTerms | ID | = |
Name | =,startswith, endswith, contains | |
IsActive | = | |
TimeModified | =,>, >=, <, <= | |
TimeTracking | ID | = |
Date | =,startswith, endswith, contains | |
EmployeeName | = | |
EmployeeId | = | |
TimeModified | =,>, >=, <, <= | |
Transfer Inventory, TransferInventoryLineItems | ID | = |
TXNDate (TXN: Transaction) | =,>, >=, <, <= | |
ReferenceNumber | =,startswith, endswith, contains | |
TimeModified | =,>, >=, <, <= | |
VehicleMileage,Vendors | ID | = |
Name | =,startswith, endswith, contains | |
TimeModified | =,>, >=, <, <= | |
VendorCreditExpenseItems, VendorCreditLineItems, VendorCredits, | ID | = |
Date | =,>, >=, <, <= | |
ReferenceNumber | =,startswith, endswith, contains | |
VendorName | = | |
VendorId | = | |
AccountsPayableId | = | |
AccountsPayableName | = | |
TimeModified | =,>, >=, <, <= |
