Index: OBJTimpl/WMSOrder/OphalenPickLijnenConsolidatie.cls.xml =================================================================== diff -u -r72124 -r72126 --- OBJTimpl/WMSOrder/OphalenPickLijnenConsolidatie.cls.xml (.../OphalenPickLijnenConsolidatie.cls.xml) (revision 72124) +++ OBJTimpl/WMSOrder/OphalenPickLijnenConsolidatie.cls.xml (.../OphalenPickLijnenConsolidatie.cls.xml) (revision 72126) @@ -119,8 +119,9 @@ _" order by p3.DTSSTART asc)" _" ,'KardexOperator') USERID " _" ,pa.dtsstart PICKINGTIJDSTIP " - _" ,ml.fullname TOLOC " - _" from DCEREPORT_OUTBOUNDORDERS orders " + _" ,isnull(csiq.USRTXT23,ml.FULLNAME) TOLOC " + _" ,ml.fullname TOLOC_OLD " + _" from DCEREPORT_OUTBOUNDORDERS orders " _" inner join DCEREPORT_OUTBOUNDLINES olines on olines.OUTBOUNDORDER_OID = orders.oid " _" inner join DCEREPORT_PICKORDERS po on po.ORDER_OID = orders.OID " _" inner join DCEREPORT_PICKLINES pl on pl.ORDER_OID = olines.OUTBOUNDORDER_OID and pl.ORDERLINE_OID = olines.oid and pl.PICKORDER_OID = po.oid " @@ -131,7 +132,8 @@ _" 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 and oa.OUTBOUNDLINE_OID = olines.oid" - _" inner join DCEREPORT_LOCATIONS ml on ml.OID = oa.TO_LOCATION_OID " + _" inner join DCEREPORT_LOCATIONS ml on ml.OID = oa.TO_LOCATION_OID " + _" inner join OBJT_CONTAINERSTORAGEITEMQTY csiq on csiq.OID = tocont.OID " _" where orders.ID ='" _ ConsolidatieNr _ "' " _" and orders.STATUS = 14 " _" and ml.fullname not like 'ST.%'" ; Verpakkingstation tussengevoegd bijgevolg dubbeltelling. PV 06-06-2023