Skip to Content
avatar image
Former Member

Query Pagos Recibidos

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Nov 17, 2016 at 04:56 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 17, 2016 at 11:19 AM

    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'

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 17, 2016 at 04:47 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 17, 2016 at 05:15 PM

    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.


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 17, 2016 at 05:20 PM

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

    reitero mi gratitud por tu gran y valiosa ayuda.

    Saludos.

    Add comment
    10|10000 characters needed characters exceeded