Vincular OINV y ODLN

[vhzl123]

Hola!

Quiero generar una query que me devuelta los albanes de un año que se han facturado un año posterior.

He generado el codigo que adjunto pero me mezcla albaranes y facturas. No me muestra la factura correcta para ese albarán.

¿Me puede ayudar alguien con esto? Gracias!!

SELECT DISTINCT
    T3."CardCode" AS "Cliente",
    T3."DocNum" AS "NumAlbaran",
    T3."DocEntry" AS "NavegarAlbaran",
    T0."CardCode",
    T0."DocNum" AS "NumFactura",
    T3."DocDate" AS "FechaContabilizacionAlbaran",
    T0."DocDate" AS "FechaContabilizacionFactura"
FROM 
    OINV T0  
INNER JOIN 
    INV1 T1 ON T0."DocEntry" = T1."DocEntry"
LEFT JOIN
    DLN1 T2 ON T1."BaseEntry" = T2."DocEntry" 
LEFT JOIN 
    ODLN T3 ON T1."DocEntry" = T3."DocEntry"
WHERE 
    YEAR(T3."DocDate") = '2023' 
    AND YEAR(T0."DocDate") = '2024'

[jitin_chawla]

Hi,

Check this below:

SELECT DISTINCT
    T3."CardCode" AS "Cliente",
    T3."DocNum" AS "NumAlbaran",
    T3."DocEntry" AS "NavegarAlbaran",
    T0."CardCode",
    T0."DocNum" AS "NumFactura",
    T3."DocDate" AS "FechaContabilizacionAlbaran",
    T0."DocDate" AS "FechaContabilizacionFactura"
FROM 
    OINV T0  
INNER JOIN 
    INV1 T1 ON T0."DocEntry" = T1."DocEntry"
LEFT JOIN
    DLN1 T2 ON T1."BaseEntry" = T2."DocEntry" 
LEFT JOIN 
    ODLN T3 ON T2."DocEntry" = T3."DocEntry"
WHERE T1.BaseType = '15' AND
    YEAR(T3."DocDate") = '2023' 
    AND YEAR(T0."DocDate") = '2024'

Kr,

Jitin