Por Favor Ayuda Reporte Para Ver Detalle Notas De Credito

[Hugoapm]

SELECT
T0."DocNum" AS "NC Interna",
T0."U_LDT_NumeroGTI" AS "NC Electrónica",
T0."TaxDate" AS "Fecha",
T0."CardCode",
T0."CardName",
T0."NumAtCard" AS "Zona",
T2."ItemCode" As "Código Artículo",
T2."Dscription" AS "Detalle Artículo",
T0."U_Memo" AS "Concepto",
T2."Quantity" As "Cantidad",
T6."U_PreProd" AS "Presentación",
T2."Price" AS "Precio Unitario",
T2."LineTotal" AS "Sub-Total",
T2."VatSum" AS "IVA",
T2."TaxOnly" AS "Solo IVA",
T2."LineTotal"+T2."VatSum" AS "Total"
FROM
"ORIN" T0 INNER JOIN
"RIN1" T1 ON T0."DocEntry" = T1."DocEntry" LEFT JOIN
"INV1" T2 ON T1."BaseEntry" = T2."DocEntry" AND T1."BaseLine" = T2."LineNum" AND T1."BaseType" = 13 INNER JOIN
"OINV" T3 ON T2."DocEntry" = T3."DocEntry" INNER JOIN
"OCTG" T4 ON T3."GroupNum" = T4."GroupNum" JOIN "OSLP" T5 ON T3."SlpCode" = T5."SlpCode"
inner Join OITM T6 ON T6."ItemCode" = T2."ItemCode"
WHERE
T0."TaxDate" >= [%0]
AND T3."TaxDate" <= [%1]
AND T0."CANCELED" = 'N'