serial transection code doesn't work

[former_member832945]

OINV T0

INNER JOIN INV1 T1 ON T0."DocEntry" = T1."DocEntry"

INNER JOIN DLN1 T2 ON T1."BaseEntry"=T2."DocEntry"

INNER JOIN ODLN T3 ON T2."DocEntry" = T3."DocEntry"

LEFT outer JOIN SRI1 T4 on T3."ItemCode"=T4."ItemCode" and T4."DocEntry"=T4."BaseEntry" and T4."ObjType"= T4."BaseType"

LEFT outer JOIN OSRN T5 on T4."ItemCode"=T5."ItemCode" and T4."SysSerial"=T5."SysNumber"

[mgregur]

Hi,

change it to:

OINV T0
INNER JOIN INV1 T1 ON T0."DocEntry" = T1."DocEntry"
INNER JOIN DLN1 T2 ON T1."BaseEntry"=T2."DocEntry"
INNER JOIN ODLN T3 ON T2."DocEntry" = T3."DocEntry"
LEFT JOIN SRI1 T4 on T2."ItemCode"=T4."ItemCode" and T2."DocEntry"=T4."BaseEntry" and T2."ObjType"= T4."BaseType" AND T2."LineNum" = T4."BaseLinNum"
LEFT outer JOIN OSRN T5 on T4."ItemCode"=T5."ItemCode" and T4."SysSerial"=T5."SysNumber"

This is assuming you have Delivery Note as base document for your Invoice.

BR,

Matija