Guía de consultas para detalle de nota de crédito y devolución con número de orden de venta

Prueba esta consulta

SELECT T1."DocEntry" AS "Link",
CASE
WHEN T1."DocStatus" = 'C' THEN 'Cerrado'
ELSE 'Abierto'
END AS "Estado de OV",
T1."CardName" AS "Nombre del Cliente",
T1."DocNum" AS "Núm. OV",
T1."DocDate" AS "Fecha OV",
t8."InvntryUom" as "Ud. Inv",
t0."InvQty" AS "Cant. OV",
T3."DocNum" AS "Núm. Entrega",
T3."DocDate" AS "Fecha Entrega",
T5."DocNum" AS "Núm. Factura",
T5."DocDate" AS "Fecha Factura",
T15."DocNum" AS "Núm. Nota de Crédito",
T15."DocDate" AS "Fecha Nota de Crédito",
T0."ItemCode" AS "Código de Producto",
T0."Dscription" AS "Nombre de Producto",
t4."unitMsr" as "Ud. Venta",
T4."Quantity" as "Núm. de Paquetes",
T4."NumPerMsr" as "Unidades por Paquete",
t4."InvQty" as "Cant. Entregada (Unidades)",
T0."OpenQty" as "Cant. OV Abierta"
FROM RDR1 T0
INNER JOIN ORDR T1 ON T0."DocEntry" = T1."DocEntry"
LEFT OUTER JOIN DLN1 T2 ON T2."BaseEntry" = T0."DocEntry" AND T2."BaseLine" = T0."LineNum"
LEFT OUTER JOIN ODLN T3 ON T2."DocEntry" = T3."DocEntry"
LEFT OUTER JOIN INV1 T4 ON T4."BaseEntry" = T3."DocEntry" AND T4."BaseLine" = T2."LineNum" AND T4."BaseType" = '15'
LEFT OUTER JOIN OINV T5 ON T5."DocEntry" = T4."DocEntry"
LEFT OUTER JOIN RIN1 T14 ON T14."BaseEntry" = T4."DocEntry" AND T14."BaseLine" = T4."LineNum" AND T14."BaseType" = '13'
LEFT OUTER JOIN ORIN T15 ON T15."DocEntry" = T14."DocEntry"
LEFT OUTER JOIN OITM T8 ON T0."ItemCode" = T8."ItemCode"
LEFT OUTER JOIN OITB T18 ON T8."ItmsGrpCod" = T18."ItmsGrpCod"
WHERE T1."DocDate" >='[%0]'
and T1."DocDate" <='[%1]'
and t18."ItmsGrpNam" ='[%2]'
order by T1."DocNum" ,T1."DocDate"