on 11-07-2014 3:55 PM
Hola!
Quiero poner una búsqueda formateada que me muestre el saldo de las facturas de anticipo ya pagadas y pendientes de aplicar para el socio de negocio seleccionado.
¿Cómo puedo saber si la factura ya se aplicó o no?
Gracias!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hola, Intenta así:
SELECT T0.[DocNum], T0.[DocDate], T0.[CardCode], T0.[CardName], T0.[DocTotal], T0.[PaidToDate], T0.[DpmAppl] FROM ODPI T0 INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode WHERE T1.[CardCode] =[%1]
SELECT T0.[DocNum], T0.[DocDate], T0.[CardCode], T0.[CardName], T0.[DocTotal], T0.[PaidToDate], T0.[DpmAppl]
FROM ODPI T0 INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode WHERE T1.[CardCode] =[%1]
Saludos.
Alessandro.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.