Query showing the Cancelled AR Credit memo details SAP Business One HANA

[nikunjmehta2290]

Dear all,

Below query is showing the Cancelled AR Credit memo details SAP Business One HANA.

Need to stop the details for cancelled AR Credit memo.

SELECT

T5."DocNum" AS "AR Invoice No.",

T5."CardCode" as "Customer Code",

T5."DocTotal" as "AR Invoice Document total",

(T5."DocTotal" - T5."PaidToDate") as "AR Balance Due (Payment remain to pay)",

--(T0."DocTotal"-T0."VatSum") AS "Taxable Amount",

T0."DocNum" AS "AR Credit Memo No.",

T0."DocDate" as "AR Credit Memo document date",

T0."DocTotal" AS "AR Credit memo Amount",

/*T55."DocNum" as "Incoming Payment no"

,T55."DocDate" as "Payment date"

,T55."DocTotal" as "Payment amount" */

T10."DocNum" as "Incoming Payment no"

,T10."DocDate" as "Payment date"

,T10."DocTotal" as "Payment amount"

FROM ORIN T0

INNER JOIN RIN1 T1 ON T0."DocEntry" = T1."DocEntry"

left JOIN INV1 T4 ON T1."BaseEntry" = T4."DocEntry" and T1."BaseLine" = T4."LineNum"

left JOIN OINV T5 ON T4."DocEntry" = T5."DocEntry"

left JOIN RCT2 T9 ON T9."DocEntry" = T5."DocEntry"

left JOIN ORCT T10 ON T10."DocEntry" = T9."DocEntry"

--left join ORCT T55 on T5."ReceiptNum"=T55."DocEntry"

INNER JOIN OCRD T2 ON T0."CardCode"=T2."CardCode"

INNER JOIN OCRG T3 ON T2."GroupCode"=T3."GroupCode"

WHERE

T5."DocNum" = '2101030746' --AND T0."CANCELED"='N'

--and T10."Canceled" ='N'

GROUP BY

T0."DocNum", T5."DocNum", T0."ObjType", T3."GroupName", T0."DocDate", T5."CardCode", T0."DocTotal",

T5."DocTotal" ,T5."PaidToDate"

/*,T55."DocNum"

,T55."DocDate"

,T55."DocTotal" */

,T10."DocNum" ,T10."DocDate" ,T10."DocTotal"

ORDER BY T0."DocNum"

SAP Business One HANA

Regards,

Nikunj Mehta