on 02-04-2016 11:39 PM
Buenas tardes foro
por este medio me comunico con ustedes para saber si alguien me puede apoyar para la creación de un query que detone una alarma al momento de que se cancele una factura de cliente.
Estimado Antonio,
Prueba con esta
SELECT
T0.DocEntry, T0.DocNum, T0.CardName
FROM OINV T0
WHERE DATEDIFF(DD, GETDATE(), T0.DocDate)<= 0 and T0.Canceled = 'Y'
Slds,
IFV
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
99 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.