IT Support

Alex or Marcel would request this: template is attached, you can create a new tab for the month they are requesting 

Query: (Change MONTH and perform query for each Branch : B, SC, W and combination of all branches)

 SELECT DISTINCT IM.StockCode, INV.AlternateKey1, INV.Description, SUM(IM.TrnQty) As QTY, 

 SUM(IM.TrnValue) AS Amount, INV.Supplier

 FROM   [SRV-SQL2012-2].SysproA.dbo.InvMovements IM 

 RIGHT  JOIN [SRV-SQL2012-2].SysproA.dbo.InvMaster INV ON IM.StockCode=INV.StockCode

 WHERE  IM.MovementType='S' AND IM.StockCode<>'900066' 

 AND    IM.TrnYear=2026 AND TrnMonth = 5    AND (INV.Supplier='BIOTHRM' OR INV.Supplier='PARBEL' OR INV.Supplier='SANYSLU') 

 AND    INV.ProductClass NOT  LIKE 'Z%'

 AND IM.BRANCH IN ('B', 'SC', 'W') 

GROUP BY INV.Supplier, IM.StockCode, INV.Description, INV.AlternateKey1

ORDER BY INV.Supplier, 4 desc