FINANCIAL_ITEM

	FINANCIAL_ITEM_SEARCH
	Item Search can be used in conjunction with either: Invoice Search Receipt Search Expense Search Payment Search

	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