FINANCIAL_ITEM_SEARCH
 
Item Search can be used in conjunction with either:

  DETAILS    
  Prefix LineItem  
  SUB SEARCHES    
  Expense FINANCIAL_EXPENSE_SEARCH  
  FinancialAccount SETUP_FINANCIAL_ACCOUNT_SEARCH  
  Invoice FINANCIAL_INVOICE_SEARCH  
  OrderItem PRODUCT_ORDER_ITEM_SEARCH Joins from OtherObject / OtherObjectContext
  Payment FINANCIAL_PAYMENT_SEARCH  
  Receipt FINANCIAL_RECEIPT_SEARCH  
  AVAILABLE FIELDS TYPE  
  Amount Numeric  
  Area Numeric Linked area
  AreaText Text (50) See above
  Capital Text (1) Y/N.
  Description Text (100)  
  ExpenseCreditAmount Numeric Sum of the amount from linked Credit Notes. Only makes sense if the Item's Object is 2 (Expense)
  ExpenseOutstandingAmount Numeric PreadjustmentAmount - Sum of the amount from linked Payments- Sum of the amount from linked Credit Notes. Only makes sense if the Item's Object is 2 (Expense)
  FinancialAccount Numeric Linked financial account
  FinancialAccountText Text (50) See above
  Id Numeric  
  InvoiceCreditAmount Numeric Sum of the amount from linked Credit Notes. Only makes sense if the Item's Object is 5 (Invoice)
  InvoiceOutstandingAmount Numeric PreadjustmentAmount - Sum of the amount from linked Receipts - Sum of the amount from linked Credit Notes. Only makes sense if the Item's Object is 5 (Invoice)
  Notes Text (2000)  
  Object Numeric  
  ObjectContext Numeric  
  ObjectText Text (50)  
  OtherObject Numeric  
  OtherObjectContext Numeric  
  OtherObjectText Text (50)  
  PaymentAmount Numeric Sum of the amount from linked Payments. Only makes sense if the Item's Object is 2 (Expense)
  PreAdjustmentAmount Numeric Amount before Credit Notes (if any) were applied
  PreAdjustmentTax Numeric GST before Credit Notes (if any) were applied
  Project Numeric  
  ProjectText Text (50)  
  ReceiptAmount Numeric Sum of the amount from linked Receipts. Only makes sense if the Item's Object is 5 (Invoice)
  Reference Text (50)  
  SourceAmount Numeric If the amount is in a foreign currency, the amount in that currency
  SourceCurrency Numeric  
  SourceCurrencyRate Numeric  
  SourceCurrencyText Text (50)  
  Tax Numeric  
  TaxReport Numeric ID of the BAS / VAT etc that the receipt was in
  TaxReportField Text Field that the receipt was included in
  TaxReportText Text Reference of the above
  TaxType Numeric Depending on your country the values change. Eg for Australia, 1=GST Applies,2=GST Free - Export,3=GST Free - Other,4=GST Free - Input
  TaxTypeExpenseText Text (50) Use this field if searching on Payments or Expenses
  TaxTypeRevenueText Text (50) Use this field if searching on Receipts or Invoices
Help!