WHEN 'ADDINV' THEN '552'
WHEN 'INVSUB' THEN '551'
END AS ADJUSTMENT ,
Add negative sign if matlfer.xtype = 'INVSUB'
Our database doesn't have negatives, but I need to send data with them and i've tried variables and other things, but none have worked as I wanted. Basically I need it to show as this.