/*PostST with SerialTx (count)*/ SELECT P.Quantity, SN.QtyTx,* FROM (SELECT AccountLink,TxDate, cAuditNumber, SUM(Quantity) Quantity FROM PostST GROUP BY AccountLink, cAuditNumber,TxDate) P LEFT JOIN (SELECT M.SNStockLink, S.SNAuditNumber, count(*) as QtyTx FROM SerialTx S LEFT JOIN SerialMF M ON S.SNLink = M.SerialCounter WHERE S.SNTransType NOT IN (17) GROUP BY M.SNStockLink, S.SNAuditNumber) SN ON SN.SNStockLink = P.AccountLink AND SN.SNAuditNumber = P.cAuditNumber LEFT JOIN StkItem S ON P.AccountLink = S.StockLink WHERE S.SerialItem = 1 AND ABS(P.Quantity) <> SN.QtyTx --AND P.AccountLink = 164 AND P.TxDate >= '2021-10-01' |