--recibos total abonos
SELECT R.TipDoc,R.Recibo,R.IdCia,R.IdCliente,VrNeto,ISNUll(RecVrAbonos,0) AS TotalAbonos,ISNULL(VrAFavor,0) AS TotalAFavor
,ISNULL(SaAbonos,0) AS AbonoSAfavor
FROM Trn_FinRecibos AS R LEFT JOIN (SELECT TipRec,Recibo,IdCia,IdCliente,SUM(TotalAbono) AS RecVrAbonos
FROM Trn_FinAbonos GROUP BY TipRec,Recibo,IdCia,IdCliente) AS A ON R.TipDoc=A.TipRec AND R.Recibo=A.Recibo AND R.IdCia=A.IdCia
LEFT JOIN (SELECT TipDoc,Recibo,IdCia,IdCliente,VrAFavor
FROM Trn_FinAfavor) AS AF ON R.TipDoc=AF.TipDoc AND R.Recibo=AF.Recibo AND R.IdCia=AF.IdCia
--abonos a favor
LEFT JOIN (SELECT TipRec,Recibo,IdCia,IdCliente,SUM(TotalAbono) AS SaAbonos
FROM Trn_FinAbonos WHERE TipoAplica=2 GROUP BY TipRec,Recibo,IdCia,IdCliente) AS ASF ON R.TipDoc=ASF.TipRec AND R.Recibo=ASF.Recibo AND R.IdCia=ASF.IdCia
WHERE R.IdCliente='?'

--============ cuotas abonos ==========
SELECT C.TipDoc,C.IdPrestamo,C.IdCia,C.Item,C.IdCliente,VrTotal,ISNULL(TotAbonos,0) AS TotalAbonos,VrTotal-ISNULL(TotAbonos,0) AS VrSaldo
FROM Trn_FinCuotas AS C LEFT JOIN (SELECT TipDoc,IdPrestamo,IdCiaPre,ItemPre,IdCliente
,SUM(TotalAbono) AS TotAbonos FROM Trn_FinAbonos GROUP BY TipDoc,IdPrestamo,IdCiaPre,ItemPre,IdCliente)
AS A ON C.TipDoc=A.TipDoc AND C.IdPrestamo=A.IdPrestamo AND C.IdCia=A.IdCiaPre AND C.Item=A.ItemPre
WHERE C.IdCliente='?'
ORDER BY C.TipDoc,C.IdPrestamo,C.IdCia,C.Item