Mine

SELECT DISTINCT d.ITEMRELATION, c.CONFIGID, d.FROMDATE, d.TODATE, d.ACCOUNTCODE, d.ACCOUNTRELATION, d.AMOUNT, u.TXT
FROM         PRICEDISCTABLE AS d INNER JOIN
                      INVENTDIM AS i ON d.INVENTDIMID = i.INVENTDIMID INNER JOIN
                      CONFIGTABLE AS c ON i.CONFIGID = c.CONFIGID INNER JOIN
                      UNIT AS u ON d.UNITID = u.UNITID
WHERE     (((d.DATAAREAID) = 'lbs') AND ((d.RELATION) = 4) AND ((c.DATAAREAID) = 'lbs')) AND NOT (d.ITEMRELATION = 'PB045035H2F' AND d.UNITID = 'lm')
GROUP BY d.ITEMRELATION, c.CONFIGID, d.FROMDATE, d.TODATE, d.ACCOUNTCODE, d.ACCOUNTRELATION, d.AMOUNT, u.TXT
ORDER BY d.ITEMRELATION, c.CONFIGID;

Changed to;

SELECT DISTINCT 
                      d.ITEMRELATION, c.CONFIGID, d.FROMDATE, d.TODATE, d.ACCOUNTCODE, MAX(d.ACCOUNTRELATION) AS ASACCOUNTRELATION, MAX(d.AMOUNT) 
                      AS AMOUNT, MAX(u.TXT) AS TXT
FROM         PRICEDISCTABLE d INNER JOIN
                      INVENTDIM i ON d.INVENTDIMID = i.INVENTDIMID INNER JOIN
                      CONFIGTABLE c ON i.CONFIGID = c.CONFIGID INNER JOIN
                      UNIT u ON d.UNITID = u.UNITID
WHERE     (d.DATAAREAID = 'lbs') AND (d.RELATION = 4) AND (c.DATAAREAID = 'lbs') AND (NOT (d.ITEMRELATION = 'PB045035H2F')) OR
                      (d.DATAAREAID = 'lbs') AND (d.RELATION = 4) AND (c.DATAAREAID = 'lbs') AND (NOT (d.UNITID = 'lm'))
GROUP BY d.ITEMRELATION, c.CONFIGID, d.FROMDATE, d.TODATE, d.ACCOUNTCODE
ORDER BY d.ITEMRELATION, c.CONFIGID