Skip to Content
0
Nov 14, 2012 at 01:56 PM

Link batchtransaction from delivery in invoice CR layout

509 Views

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