as of 5/22/19 - this is a quick overview of what we do for QTI invoices on the balance sheet.

- verbage for QTI (wip) stuff: (in the top_secret/cfc/search_10.cfc page)
	the QTI stuff only runs if running on normal dates (dateSwitch = 2) (line 196)

	the top query is called "qryGetQTIInvoices" - just invoice numbers from the transition_invoices table (line 200)
		- as a note, we may need to figure out which ones are still QTI's and which ones are finished.
			currently, it grabs both and treats them the same. the problem may be with the inventory
			date. ones still in QTI status will have the start transition date where as the closed
			ones will have the actual booked (last of three) dates. that may be a problem.

	there is a list called "qtiInvoice_list" with all QTI invoices (as a group) (line 214)

	there is a query called "qryGetQTILineItems" that pulls from the po_invoice_lines_53 table based off of the qtiInvoice_list (line 216)
		- contains extended line cost, extended line price, invoice number, and po/inv line id's

	there is a query called "qryGetQTITotals" that sums up things from the qryGetQTILineItems query (line 242)
		- total qti cost, total qti price

	the qtiInvoice_list gets re-filtered based off of the line items (line 247)

	there is a query called "qryGetDepositedQTIPayments" that pulls in data from the invoice_payments_53 table based off of
	the qtiInvoice_list (line 249)
		- total paid, pmt count

	-- going down a bit...
	assets - the general parts inventory just pulls based off of date, no tie-in to QTI invoices (line 839)
		- that may be a problem...

	assets - there is a new if statement that was added for in transit inventory on QTI invoices (line 911)
		- see notes above on the general inventory reports... there may be a date range difference here

	assets - accounts receivable - for QTI invoices - total qti price from qryGetQTITotals (line 976)

	assets - normal a/r's don't include the QTI invoices - not in qtiInvoice_list (line 993)

	liabilities - both daily and monthly tax liabilities do not include QTI invoices (line 1051)

	liabilities - a/p's - payments made on QTI invoices (line 1224)

	liabilities - COGS on QTI invoices (line 1775)

	equity - net profit - future potential from QTI invoices (line 1799)