INFORME DE VENTAS CR CONT. Y NOTAS DE CREDITO

[Former Member]

Buenas tardes

tengo el siguiente querry

SELECT T0.NumAtCard, t0.docdate, t0.cardcode, t0.cardname, T0.SlpCode,T1.SlpName,

case

when T0.groupnum='-1' then 'F.Contado'

else 'F.Crédito' END as 'Tipo Venta',

(select doctotal from oinv where docnum = t0.docnum)as 'Total',

(select doctotal from oinv where docnum = t0.docnum and T0.groupnum='-1')as 'Total Contado',

(select doctotal from oinv where docnum = t0.docnum and T0.groupnum <>'-1') as 'Total Credito'

FROM OINV T0  INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode

--where T0.DocDate >=[%0] and T0.DocDate <=[%1]

--T0.DocType='I' and

UNION ALL

SELECT T0.NumAtCard, t0.docdate, t0.cardcode, t0.cardname, T0.SlpCode,T1.SlpName,

case

when T0.groupnum='-1' then 'Contado'

else 'Nota Crédito' END as 'Tipo Venta',

(select doctotal from ORIN where docnum = t0.docnum)as 'Total',

(select doctotal from ORIN where docnum = t0.docnum and T0.groupnum='-1')as 'Total Contado',

(select doctotal from ORIN where docnum = t0.docnum and T0.groupnum <>'-1') as 'Total Credito'

FROM ORIN T0  INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode

--where T0.DocDate >=[%2] and T0.DocDate <=[%3]

--T0.DocType='I' and

where T0.DocDate >='01-05-2015' and T0.DocDate <='31-05-2015'

ORDER BY T0.DocDate

El cual funciona perfectamente en SQL SERVER, pero cuando lo intento pasar a SAP en el generador de consulta me sale el siguiente mensaje de error

Registro de consulta no finalizado Error (QE-3006)

Por favor necesito ayuda

[gerardo_mendez]

Hola Eric.

De entrada prueba cambiando el parámetro de las fechas por '20150501' y '20150531'

Prueba y nos comentas.

Saludos.