Este fue el Query que realicé…
SELECT DISTINCT
b.DocNum NoPagoRecibido , b.TaxDate 'Fecha Pago Recibido ',
b.CardCode 'Código Cliente', b.CardName 'Nombre Cliente', b.DocTotal 'ImportePagad',a.SumApplied 'pagado' ,
CASE WHEN a.InvType = 18 THEN 'FA' WHEN a.InvType = 19 THEN 'NC' ELSE 'AN' END Documento,a3.DocEntry,
e.DocDate 'FechaAnticipo',a3.DocNum, a3.PaidDpm, a3.DocDate, a3.DocTotal, a3.VatSum, (a3.DocTotal /1.128) .20 'Terreno', (a3.DocTotal /1.128) .80 'Cosntrucción', e.DocTotal 'ImporteAnticipo', a3.NumAtCard, a3.Comments, e.DocDueDate 'FechaVencimientoAnticipo',
CASE WHEN e.DocEntry = a.DocEntry AND e.ObjType = a.InvType then SUM (a.SumApplied) ELSE 0 END pagos1
FROM RCT2 a
LEFT JOIN ORCT b ON b.DocNum = a.DocNum
LEFT JOIN ODPI e ON e.DocEntry = a.DocEntry AND e.ObjType = a.InvType
LEFT JOIN (SELECT distinct a1.DocNum, a2.DocEntry, a1.PaidDpm ,a1.DocDate , a1.DocTotal, a1.VatSum, NumAtCard, a1.Comments
from ORDR a1
INNER JOIN DPI1 a2 ON a2.BaseEntry = a1.DocEntry AND a2.BaseType = 17
GROUP BY a1.DocNum, a2.DocEntry, a1.DocDate, a1.DocTotal, a1.VatSum,a1.NumAtCard, a1.Comments, a1.PaidDpm ) a3 ON a3.DocEntry = a.baseAbs
WHERE b.Canceled = 'N' AND a3.DocNum >=1 AND a3.DocNum = a3.DocNum
GROUP BY b.DocNum , b.TaxDate, e.DocEntry,a.DocEntry, e.ObjType,
b.CardCode , b.CardName ,b.DocTotal ,a.SumApplied ,a3.DocEntry,
e.DocDate ,a3.DocNum, a3.DocDate, a3.DocTotal, a3.VatSum, (a3.DocTotal /1.128) .20 , (a3.DocTotal /1.128) .80 , e.DocTotal , a3.NumAtCard, a3.Comments, a.InvType, e.DocDueDate, a3.PaidDpm