Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

buscar todos los pagos de una factura

estoy construyendo una query que me permita rastrear todos los pagos de una factura, el problema es:

la tabla OINV solo retiene el ultimo pago hecho (en el campo ReceiptNum se guarda el id de la tabla ORCT)

¿como puedo rastrear TODOS los pagos recibidos de esa factura?

saludos.-

Former Member
Former Member replied

El campo RCT2.Docentry guarda las el dato de la factura

FROM OINV

LEFT JOIN RCT2 ON RCT2.DocEntry = OINV.DocEntry

INNER JOIN ORCT ON ORCT.DocEntry = RCT2.DocNum

Slds

Edited by: Floyola on May 11, 2011 1:04 PM

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question