select orh.TraderCode as CustomerCode
,orh.TraderName as CustomerName
,plu.Code as PLUCode
,plu.Text1 as PLUDescription
,SUM(dms.NetWeight) as WGT
,SUM(dms.units) as Cases
from vw_ce_dms_transactions dms
left join datafiles_data plu
ON plu.datafiledataid = dms.PLUID
LEFT JOIN dbo.vw_ce_oms_order_header orh ON dms.WONo = orh.OrderNo
WHERE TransactionDateTime between '20180101' and '20181231'
and TransactionType = 'PALLET_DISPATCH_LOADING'
and Cancelled = 0
GROUP BY orh.TraderCode, orh.TraderName, plu.Code, plu.Text1