Dear all,
In below query, ORCT (Incoming Payment) join is not working with OINV (AR Invoice).
SELECT T0."DocNum" AS "Invoice Number", T2."DocNum" AS "Credit Memo Number" ,
T5."DocDate", T5."DocTotal"
FROM OINV T0
INNER JOIN INV1 T1 ON T1."DocEntry" = T0."DocEntry"
INNER JOIN ORIN t2 ON t2."ObjType" = T1."TargetType"
INNER JOIN RIN1 t3 ON T3."DocEntry" = T2."DocEntry" AND T3."BaseEntry" = T0."DocEntry"
left join ORCT T5 on T0."ReceiptNum"=T5."DocNum"
GROUP BY T0."DocNum", T2."DocNum", T5."DocDate", T5."DocTotal"
ORDER BY T0."DocNum";
Regards,
Nikunj Mehta