SELECT
        --ngay,
        --MONTH(@dauKi) thang,
        --YEAR(@dauKi) nam,
        SUM(ISNULL(m.qty, 0)) qty,
        SUM(ISNULL(qty, 0) * ISNULL(cost, 0)) AS value,
        site_ref AS site,
        (m.item) item  ,
        --@dauKi,
        b.ProjNum
    FROM ERP.SyteLine_Apps.dbo.matltran_mst m
        LEFT JOIN (
		 SELECT MAX(CAST(b.CreateDate AS DATE)) CreateDate,
           b.Item,
           b.ProjNum,
           b.ResourceId, S.site
    FROM ERP.SyteLine_Apps.dbo.ZVN_ProjProduction_mst b WITH (NOLOCK)
        LEFT JOIN ERP.SyteLine_Apps.dbo.site S WITH (NOLOCK)
            ON S.Uf_VendNum = b.ResourceId
    WHERE S.site = 'pvd'
          --AND LEFT(b.Item, 2) IN ( 'AA', 'AC', 'AN' )
          AND b.ProjNum =
          (
              SELECT TOP 1
                     c.ProjNum
              FROM ERP.SyteLine_Apps.dbo.ZVN_ProjProduction_mst c WITH (NOLOCK)
			   LEFT JOIN ERP.SyteLine_Apps.dbo.site S WITH (NOLOCK)
            ON S.Uf_VendNum = b.ResourceId
    WHERE S.site = 'pvd'
              and b.Item = c.Item --LIKE 'AA173036A050B1050' AND

              GROUP BY c.ProjNum
              ORDER BY c.ProjNum DESC
          )
    GROUP BY b.Item,
             b.ProjNum,
             ResourceId,S.site

		) b
            ON m.item = b.Item
        LEFT JOIN ERP.SyteLine_Apps.dbo.site S WITH (NOLOCK)
            ON S.Uf_VendNum = b.ResourceId
    WHERE--	s.site ='pvd' and
           CAST(m.trans_date AS DATE) < '2019-06-01'
          AND LEFT(m.item, 2) IN ( 'AA', 'AC', 'AN' )
          AND m.whse = 'btl'
          AND m.site_ref = 'pvd' -- AND m.Uf_ZVN_acct='1551'
          AND m.loc IS NOT NULL
    GROUP BY (m.item),
             site_ref ,
             b.ProjNum;

			 --SELECT * FROM ERP.SyteLine_Apps.dbo.site