Index: OBJTimpl/WMSOrder/OphalenPickLijnenConsolidatie.cls.xml =================================================================== diff -u -r70791 -r71858 --- OBJTimpl/WMSOrder/OphalenPickLijnenConsolidatie.cls.xml (.../OphalenPickLijnenConsolidatie.cls.xml) (revision 70791) +++ OBJTimpl/WMSOrder/OphalenPickLijnenConsolidatie.cls.xml (.../OphalenPickLijnenConsolidatie.cls.xml) (revision 71858) @@ -97,7 +97,7 @@ #dim Status as %String = "" #Dim SqlStatement as %String = "" - Set SqlStatement = "select distinct orders.ID CONSNR,olines.name LIJNNR,olines.QTYTARGET,pa.QTY AANTAL,item.id IDENTNR " + Set SqlStatement = "select orders.ID CONSNR,olines.name LIJNNR,olines.QTYTARGET,pa.QTY AANTAL,item.id IDENTNR " _" ,isnull((select top 1 fl.FULLNAME from DCEREPORT_PICK_ACTUALS p1 " _" left join DCEREPORT_LOCATIONS fl on fl.OID= p1.FROM_LOCATION_OID " _" where p1.PICKORDER_OID = pa.PICKORDER_OID and p1.PICKLINE_OID = pa.PICKLINE_OID " @@ -130,10 +130,11 @@ _" inner join DCEREPORT_LOCATIONS fromloc on fromloc.OID= pa.FROM_LOCATION_OID and fromloc.FULLNAME not like 'ST.%' " _" left join DCEREPORT_LOCATIONS toloc on toloc.OID= pa.TO_LOCATION_OID " _" left join DCEREPORT_ITEMS item on item.OID = pa.ITEM_OID " - _" inner join DCEREPORT_outbound_actuals oa on oa.CONTAINER_OID = pa.TO_CONTAINER_OID " + _" inner join DCEREPORT_outbound_actuals oa on oa.CONTAINER_OID = pa.TO_CONTAINER_OID and oa.OUTBOUNDLINE_OID = olines.oid" _" inner join DCEREPORT_LOCATIONS ml on ml.OID = oa.TO_LOCATION_OID " _" where orders.ID ='" _ ConsolidatieNr _ "' " _" and orders.STATUS = 14 " + _" and ml.fullname<>'ST.VP-KLEIN'" ; Verpakkingstation tussengevoegd bijgevolg dubbeltelling. PV 06-06-2023 _" order by olines.name " try