SELECT
     COALESCE(sum(F.total),0) AS Compra,
    CC.saldo - sum(F.total) AS deuda,
     C."razon_social" AS cliente,
     CC."saldo" AS saldo
FROM
     "public"."factura" F INNER JOIN "public"."cliente" C ON F."uncliente_id_cliente" = C."id_cliente"
     INNER JOIN "public"."ctacte" CC ON C."razon_social" = CC."razonsocial"
WHERE
     F.fecha >= $P{fechaInicial} AND F.fecha <= $P{fechaFinal}
GROUP BY
     razon_social,
     saldo