on 10-27-2009 4:03 PM
Hola:
Tenemos SAP BO 2007 A y se programo en Gestiones de Alarma que se ejecutara el ultimo dia del mes una consulta grabada en el query manager que solicita parámetros, pero cuando llega la fecha se ejecuta el query solicita los parámetros pero no arroja los resultados. Hay que configurar algo más? o porque pasa esto?.
Agradezco su atención de antemano.
Hola:
Disculpa, donde encuentro el caso sobre alarmas que comentas?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Paul:
Gracias por su apoyo, revisaré el link que me envia.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hola...
Existe un caso reciente planteado sobre las alertas, en el cual se plantean ciertas limitaciones de estas. Te sugeriría que le eches un vistazo a dicho caso.
Saludos Cordiales,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hola:
Este es el query, de hecho si arroja los resultados cuando lo ejecuto de manera normal, pero cuando lo programo para que se ejecute un dia en especifico no salen los datos.
declare @trimestre as varchar(50)
declare @inifecha as datetime
declare @finfecha as datetime
set @trimestre = (SELECT TOP 1 R0.U_TRIMESTRE from [dbo].[@TFAC_EMP] R0 where R0.U_TRIMESTRE = '[%1]')
set @trimestre = '[%1]'
set @inifecha= (case when @trimestre ='1' then (SELECT TOP 1 R0.u_fecha from [dbo].[@TFAC_EMP] R0 where R0.code = 1)
when @trimestre ='2' then (SELECT TOP 1 R0.u_fecha from [dbo].[@TFAC_EMP] R0 where R0.code = 2)
when @trimestre ='3' then (SELECT TOP 1 R0.u_fecha from [dbo].[@TFAC_EMP] R0 where R0.code = 3)
when @trimestre ='4' then (SELECT TOP 1 R0.u_fecha from [dbo].[@TFAC_EMP] R0 where R0.code = 4)
else 0 end)
set @finfecha = (case when @trimestre ='1' then (SELECT TOP 1 R0.u_fecha from [dbo].[@TFAC_EMP] R0 where R0.code = 2)
when @trimestre ='2' then (SELECT TOP 1 R0.u_fecha from [dbo].[@TFAC_EMP] R0 where R0.code = 3)
when @trimestre ='3' then (SELECT TOP 1 R0.u_fecha from [dbo].[@TFAC_EMP] R0 where R0.code = 4)
else '2009/12/31' end)
SELECT
T0.[DocDate],
T0.[CardCode],
T0.[DocNum],
(sum(T2.[linetotal])) as Subtotal,
T0.[DocStatus],
T1.[SlpName]
FROM
OINV T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode INNER JOIN INV1 T2 ON T0.DocEntry = T2.DocEntry
WHERE
T1.[Slpname]='[%0]' and (t0.[docdate] >= @inifecha and t0.[docdate]< @finfecha) and T2.[TargetType] <> '14'
GROUP BY T0.[DocDate],T0.[CardCode],T0.[DocNum], (T0.[DocTotal] - T0.[VatSum]),T0.[DocStatus], T1.[SlpName]
UNION
SELECT
' ',' ',' ', (sum(T2.[linetotal])) as Subtotal,' ',' '
FROM
OINV T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode INNER JOIN INV1 T2 ON T0.DocEntry = T2.DocEntry
WHERE
T1.[Slpname]='[%0]' and (t0.[docdate] >= @inifecha and t0.[docdate]< @finfecha) and T2.[TargetType] <> '14'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hola...
Podrias exponer aquí el query de modo de poder tener un alcance un poco mas amplio??
Saludos Cordiales,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.