Untitled Document

SELECT pili.po_invoice_line_id, pili.invoice_number, pili.part_number, (pili.line_quantity * -1) AS quantity, pili.item_price, pili.line_item_date, pili.customer_id, pili.store_id, (pili.item_price_extended * -1) AS itemtotal, pili.extended_tax_total AS tax, ((pili.item_price_extended * -1) + pili.extended_tax_total) AS total, part_categories.part_category_name FROM po_invoice_lines_#variables.tempCorpId# AS pili, part_categories WHERE part_categories.part_category_id = pili.part_category_id AND pili.corp_id = #variables.tempCorpId# AND pili.line_status = 1 AND pili.store_id NOT IN (1,22) AND pili.invoice_switch = 1 AND pili.invoice_number > 0 AND pili.customer_id > 1 AND pili.line_item_date BETWEEN #createODBCDate(variables.tempFromDate)# AND #createODBCDate(variables.tempToDate)# ORDER BY pili.invoice_number DESC

just return the blank array. masterInvoices_array as the results.

SELECT invoice_number, line_item_date, customer_id, store_id, SUM(tax) AS tax_sum, SUM(itemtotal) AS line_sum, SUM(total) AS invoice_total FROM qryGetSales GROUP BY invoice_number, customer_id, store_id, line_item_date ORDER BY invoice_number SELECT part_number, part_category_name, quantity, item_price, po_invoice_line_id FROM qryGetSales WHERE invoice_number = #variables.tempInvoiceNumber# ORDER BY po_invoice_line_id Untitled Document //////////////////////////////////////////////////////
Invoices Array [

]

{"invoiceid": "D53245-32123",
"locationid": "D53245",
"customerid": 3,
"itemtotal": 200.00,
"tax": 12.00,
"total": 220.00,
"purchasedate": "10/03/2018",
"items":[
((((((( ##1 )))))) {"name":"Gloves","sku":"F4332","quantity":1,"price":100.00},
{"name":"Hat","sku":"F4331","quantity":4,"price":20.00},
{"name":"Scarf","sku":"F4330","quantity":1,"price":20.00}
}],

/////////////////////////////////////////////////////////////