Skip to Content
0
Nov 12, 2012 at 02:43 PM

Batch Query Delivery

1084 Views

Hi,

I need to insert batchdetails of the delivery.

I created an query but get to many lines.

Does somebody see the problem in my query?

If the query give the right result i use it in my crystal report as a subreport based on docentry.

SELECT T0.DocNum, T1.ItemCode , T1.Dscription , T1.Quantity, T2.BatchNum from ODLN T0

LEFT OUTER JOIN DLN1 T1 on T0.DocEntry = T1.DocEntry

LEFT JOIN IBT1 T2 on T2.BaseType = T0.ObjType AND T2.BaseNum = T0.DocNum

Where T0.DocEntry = 9

Greetings

Mark