Skip to Content
0
Jan 13, 2023 at 05:44 AM

ORCT join with OINV not working SAP Business One HANA

243 Views

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