sql	" SELECT V.CODVENTA AS CODVENTA, 
 RTRIM(V.NUMVENTA) AS NUMCOMPROBANTE, 
 V.CODMONEDA AS CODMONEDA, 
 V.CODSUCURSAL AS CODSUCURSAL, 
 V.CODCLIENTE AS CODCLIENTE, 
 V.CODCOMPROBANTE AS CODCOMPROBANTE, 
 CAST(V.FECHAVENTA AS DATETIME) AS FECCOMPROBANTE, 
 ISNULL(CL.CODPLANCUENTA,0) AS CUENTADEBECREDITO, 
 ISNULL(T.CODPLANCUENTA,0) AS CUENTADEBECONTADO, 
 CASE WHEN (V.ESTADO) <> 1 THEN 0 
 ELSE 1 END AS ANULADO, 
 V.COTIZACION1 AS COTIZACION1, 
 V.COTIZACION2 AS COTIZACION2, 
 ISNULL((V.TIPOVENTA), 0) AS TIPOIVA, 
 (V.MODALIDADPAGO) AS MODALIDADPAGO, 
 RTRIM((CL.APELLIDO))+ ' ' + RTRIM((CL.NOMBRE)) AS CLIENTE, CONVERT(INT, M.DECIMALES) AS DECIMALES 
 FROM VENTAS V, SUCURSAL S, CLIENTES CL, TIPOCOMPROBANTE T, MONEDA M 
 WHERE V.CODCLIENTE = CL.CODCLIENTE 
 AND V.CODSUCURSAL = S.CODSUCURSAL 
 AND V.CODCOMPROBANTE = T.CODCOMPROBANTE 
 AND V.CODEMPRESA = 1 
 AND CL.CODPLANCUENTA IS NOT NULL 
 /*AND T.CODPLANCUENTA IS NOT NULL */
 AND V.CODMONEDA = M.CODMONEDA 
 AND (SELECT COUNT(VD.CODPRODUCTO) FROM VENTASDETALLE VD INNER JOIN CUENTASUCURSAL CS ON 
 VD.CODPRODUCTO = CS.CODPRODUCTO AND CS.CODSUCURSAL = V.CODSUCURSAL WHERE VD.CODVENTA = V.CODVENTA 
 AND (CS.CUENTAVENTAPRIVADO IS NULL OR CS.CUENTAVENTAPUBLICO IS NULL OR CS.CUENTAVENTAEXENTA IS NULL)) = 0 
 AND (SELECT COUNT(CV.CODVENTA) FROM CONVENTAS CV WHERE CV.CODVENTA = V.CODVENTA) = 0 
 AND (SELECT COUNT(VD.CODPRODUCTO) FROM VENTASDETALLE VD INNER JOIN CUENTASUCURSAL CS ON 
 VD.CODPRODUCTO = CS.CODPRODUCTO AND CS.CODSUCURSAL = V.CODSUCURSAL WHERE VD.CODVENTA = V.CODVENTA) = 
 (SELECT COUNT(VD.CODPRODUCTO) FROM VENTASDETALLE VD WHERE VD.CODVENTA = V.CODVENTA) 
 AND V.ESTADO <> 5 
 AND V.FECHAVENTA >= CAST('01/10/2013' AS DATETIME) AND V.FECHAVENTA <= CAST('31/10/2013' AS DATETIME)  
 AND (SELECT COUNT(CV.CODVENTA) FROM CONVENTAS CV WHERE CV.CODVENTA = V.CODVENTA) = 0 
 AND (SELECT COUNT (DISTINCT CFC.CODFORCOBRO) 
 FROM CAJAFORMACOBRO CFC 
 INNER JOIN TIPOFORMACOBRO TFC ON CFC.CODFORCOBRO = TFC.CODFORCOBRO 
 INNER JOIN CAJAINGRESOS CI ON CFC.CODINGRESO = CI.CODINGRESO 
 INNER JOIN CAJAFACTURASCOBRADAS FC ON CI.CODINGRESO = FC.CODINGRESO 
 WHERE FC.CODVENTA = V.CODVENTA 
 AND TFC.CODPLANCUENTA IS NULL) = 0 
 ORDER BY FECCOMPROBANTE, NUMCOMPROBANTE 
"	String