Qty and Value On-hand on specific date

DECLARE @Company nvarchar(4)
DECLARE @Date datetime
DECLARE @Partition bigint

SELECT @Partition  = Par.RECID FROM dbo.PARTITIONS AS Par WHERE Par.PARTITIONKEY = 'initial'
SET @Company='USMF'
SET @Date='2017-01-01 00:00:00.000'


SELECT IT.ITEMID, sum(ITr.QTY) AS 'Quantity', sum(CASE WHEN ITr.STATUSISSUE = 2 THEN ITr.COSTAMOUNTPHYSICAL WHEN ITr.STATUSRECEIPT = 2 THEN ITr.COSTAMOUNTPHYSICAL ELSE ITr.COSTAMOUNTPOSTED + ITr.COSTAMOUNTADJUSTMENT END) AS 'Value'
FROM dbo.INVENTTABLE AS IT
  JOIN dbo.INVENTTRANS AS ITr ON IT.PARTITION = ITr.PARTITION AND IT.DATAAREAID = ITr.DATAAREAID AND IT.ITEMID = ITr.ITEMID
  WHERE ITr.STATUSISSUE <=2 and ITr.STATUSRECEIPT <=2 AND ITr.DATAAREAID = @Company AND ITr.PARTITION = @Partition AND ITr.DATEPHYSICAL <= @Date
      GROUP BY IT.ITEMID