SELECT product_date dt,account_id, account_name, account_accounttypeID,
SUM(SUM(invoicedetail_quantity * invoicedetail_price)) cr, 0 dr
FROM product
JOIN invoice_detail ON invoicedetail_itemID = product_id
JOIN invoice ON invoice_id = invoicedetail_invoiceID
JOIN account ON account_id = product_inventoryaccountID
WHERE invoice_companyID = '49'
AND invoicedetail_itemtype = 'PR'
AND invoice_invoicedate BETWEEN '2016-01-01' AND '2016-01-31'
AND invoice_status = 1
Задача ещё не решена.
Других решений пока нет …