/*SerialMF vs WhseStk*/
SELECT S.Code As StockCode, W.Code as WHCode
        ,Diff = WS.WHQtyOnHand - SN.SNQty
        ,WS.WHQtyOnHand, SN.SNQty
        ,WS.* FROM WhseStk WS
        LEFT JOIN (SELECT SNStockLink, CurrentAccLink, COUNT(*) as SNQty FROM SerialMF S WHERE S.CurrentLoc = 1 GROUP BY S.SNStockLink, S.CurrentAccLink) SN
            ON WS.WHStockLink = SN.SNStockLink AND WS.WHWhseID = SN.CurrentAccLink
        LEFT JOIN StkItem S ON WS.WHStockLink = S.StockLink
        LEFT JOIN WhseMst W ON WS.WHWhseID = W.WhseLink
        WHERE WS.WHQtyOnHand <> SN.SNQty