HI,
I created an crystal report with a subreport for batchnumbers.
This works fine when I create the report of the delivery document.
But now I also want to see the batchnumbers in the layout of my invoice.
I want to use this query but how should I link it that I always get the right information in my subreport for the Delivery and Invoice report
SELECT T0.LineNum, T0.BaseLinNum,T0.ItemCode,T0.ItemName,
T0.BatchNum as Lotno,T1.SuppSerial,T1.IntrSerial,
T0.Quantity AS Quantity, T3.FrgnName, T3.SWW, T3.CodeBars,
T3.BHeight1 FROM IBT1 T0
INNER JOIN OIBT T1 ON (T0.BatchNum = T1.BatchNum AND T0.ItemCode = T1.ItemCode)
INNER JOIN OITM T3 ON T0.ItemCode = T3.ItemCode WHERE T0.[BaseEntry] = INV1.BaseEntry AND
T0.BaseType = INV1.BaseType AND (T0.WhsCode = T1.WhsCode) AND T0.Quantity >0
ORDER BY T0.BaseLinNum,T1.SuppSerial,T1.IntrSerial
Or is there a better way to get the batchnumbers in my Invoice report?
I also tried it with IBT1 & IBT1_Link but cannot get the right links.
THX
Mark