on 11-16-2010 4:36 PM
Buen Dia.
Tengo la siguiente consulta para sacar el saldo de los anticipos a proveedores, pero necesito sacar uno con saldo a la fecha indicada, con historial y no con el saldo al dia como me aparece. Alguien tiene idea de como lo puedo generar.
SELECT a.DocNum AS 'No. de Documento', a.DocDate AS Fecha, a.CardCode AS Proveedor, a.CardName AS 'Nombre Proveedor', a.Doctotal, a.OpenBal AS 'Saldo Anticipo' FROM OVPM a WHERE a.Canceled ='N' AND a.PayNoDoc = 'Y' AND a.DocType ='S' AND a.NoDocSum > 1 AND a.DocDate >= '[%0]' AND a.DocDate <= '[%1]' AND a.OpenBal > 0 ORDER BY a.CardName, a.DocDate
De antemano Gracias.
Hola que tal,
Trata con la Siguiente query
SELECT
T0.CardCode,
T0.CardName,
SUM(T0.DocTotal) 'Total pagos',
SUM(T0.OpenBal) 'Total Anticipos'
FROM OVPM T0
WHERE T0.Canceled = 'N' AND T0.PayNoDoc = 'Y' AND T0.DocType = 'S' AND T0.DocDate BETWEEN '[[%0]]' AND '[[%1]]'
GROUP BY T0.CardCode, T0.Cardname
ORDER BY T0.CardCode
Saludos.
FLR
Edited by: Floyola on Nov 16, 2010 7:13 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
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.