--30 & 90 day issues query
SELECT Table1.itemnum, Sum(Table1.quantity) AS SumOfquantityIssue
FROM Table1
WHERE Table1.transdate>getdate()-30
AND Table1.issuetype ='ISSUE'
AND Table1.gldebitacct Is Not Null
AND Table1.fromstoreloc in('WFOWH','WFOPY')
GROUP BY Table1.itemnum
    ORDER BY Table.itemnum;

itemnum   SumOfquantityIssue
  1007       -1.00

--30 & 90 day transfers query
SELECT Table1.itemnum, Sum(Table1.quantity) AS SumOfquantityTransfer
FROM Table1
WHERE Table1.transdate>getdate()-30
AND Table1.issuetype ='TRANSFER'
AND Table1.gldebitacct Is Not Null
AND Table1.fromstoreloc in('WFOWH','WFOPY')
GROUP BY Table1.itemnum
ORDER BY Table1.itemnum;

itemnum SumOfquantityTransfer
   1007    1.00
   2347    20.05

Itemnum      SumOfquantityIssue   SumOfquantityTransfer  Total_Sum
 1007             1.00                -1.00                 0.00
 2347            20.05                 0.00                20.05