SELECT N'03-Xuất cọc công trường',N'BTL => KHGB', ISNULL(SUM(qty),0)
FROM dbo.matltran m
LEFT JOIN dbo.trnitem t ON m.ref_num = t.trn_num AND t.trn_line = m.ref_line_suf
WHERE
dbo.FAB_ComparePeriod(m.trans_date,@year,@month) = 1
AND LEFT(m.item,2) IN ('AA','AC','AN')
AND m.loc IS NOT NULL
AND m.whse = @whse
AND m.ref_type = 'T'
AND t.from_whse = @whse
AND t.to_whse = 'KHGB'