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' |
Husos Horarios son GMT. La hora en este momento es 01:33:13. |
www.mundosap.com 2006 - Spain
software crm, crm on demand, software call center, crm act, crm solutions, crm gratis, crm web