Ayuda Reporte Notas De Credito

Colapsar
X
 
  • Tiempo
  • Mostrar
Limpiar Todo
nuevos mensajes
  • Hugoapm
    Junior Member
    • ago
    • 2

    #1

    Ayuda Reporte Notas De Credito

    Por favor necesito que me ayuden a revisar si está bien, es para un reporte de Notas de credito

    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'
Trabajando...