Me referia a colocar el Max en la subconsulta
algo asÍ:
Código SQL
[-]
SELECT F.VENDEDOR, V.NOMVEN,COALESCE(SUM(F.IMPORFAC),0)- (( SELECT COALESCE(SUM(I.IMPMOV-I.IVAFAC),0) FROM TCXC_CLIMOVIM I WHERE (I.TIPOMOV='NX') AND I.FACTURA = MAX(F.TIPOMOV)||MAX(F.FOLIOFISCAL) AND I.FECHAMOV BETWEEN '01.02.2006' AND '28.02.2006' AND I.VENDEDOR = F.VENDEDOR)) TOTALFROM TFAC_FACTURAS FJOIN TFAC_VENDEDORES V ON (V.CLAVEN = F.VENDEDOR)WHERE F.TIPOMOV='XX' AND F.FECHAFAC BETWEEN '01.02.2006' AND '28.02.2006' AND F.DESGLODOC = 1 AND (F.TASAIVA = 1 OR F.TASAIVA = 3)GROUP BY F.VENDEDOR,V.NOMVENORDER BY 3 DESC
Ojalá te ayude