Skip to Content
0

Query Pagos Recibidos

Nov 17, 2016 at 03:19 AM

42

avatar image

Estimados expertos necesito de su gran ayuda, ando generando un query de pagos recibidos solo que quisiera agregar campos de OSLP (SlpName) y de OHEM (FirtsName)


esta es mi cosulta.

SELECT T0.[DocNum],
T0.[DocDate],
T0.[CardCode],
T0.[CardName],
T0.[CashSum],
T0.[CheckSum],
T0.[CreditSum],
T0.[TrsfrSum],
T0.[DocTotal],
T0.[CounterRef],
T0.[Comments],
T0.[JrnlMemo],
T0.[PrjCode]

FROM ORCT T0
WHERE T0.[DocDate] BETWEEN [%0] and [%1]
AND T0.Canceled = 'N'

de antemano agradezco su gran apoyo y de su valiosa ayuda.

Saludos.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Best Answer
Gonzalo Gomez Nov 17, 2016 at 04:56 PM
1

eh??

No se que quieres decir con eso de combinación interna....

Ahi tienes la consulta sql que cumple con lo que pides....Ctrl+C y Ctrl+V

Share
10 |10000 characters needed characters left characters exceeded
Gonzalo Gomez Nov 17, 2016 at 11:19 AM
1

Si los datos que quieres añadir son los de la ficha del IC sería esto:

SELECT T0.[DocNum], T0.[DocDate], T0.[CardCode], T0.[CardName], T0.[CashSum], T0.[CheckSum], T0.[CreditSum], T0.[TrsfrSum], T0.[DocTotal], T0.[CounterRef], T0.[Comments], T0.[JrnlMemo], T0.[PrjCode], T2.[SlpName], T3.[firstName] FROM ORCT T0 inner join OCRD T1 on t0.cardcode=T1.cardcode LEFT JOIN OSLP T2 ON T1.SlpCode = T2.SlpCode LEFT JOIN OHEM T3 ON T1.DfTcnician = T3.empID WHERE T0.[DocDate] BETWEEN [%0] and [%1] AND T0.Canceled = 'N'

Share
10 |10000 characters needed characters left characters exceeded
Noé González Nov 17, 2016 at 04:47 PM
0

Estimado Gonzalo mil gracias por tu ayuda pero no entiendo eso de "combinacion interna"

Share
10 |10000 characters needed characters left characters exceeded
Noé González Nov 17, 2016 at 05:15 PM
0

en tú consulta aparece lo siguiente:

"[Nombre] dE ORCT T0 T1 Combinación interna OCRD en t0. cardcode ="

es por lo que no entiendo.


saludos.


Share
10 |10000 characters needed characters left characters exceeded
Noé González Nov 17, 2016 at 05:20 PM
0

Estimado Gonzalo mil gracias, tenía mal configurado mi explorador.

reitero mi gratitud por tu gran y valiosa ayuda.

Saludos.

Share
10 |10000 characters needed characters left characters exceeded