Index: BL/MB/UGLYPicking/OrderReservatie.cls.xml =================================================================== diff -u -r5651 -r7572 --- BL/MB/UGLYPicking/OrderReservatie.cls.xml (.../OrderReservatie.cls.xml) (revision 5651) +++ BL/MB/UGLYPicking/OrderReservatie.cls.xml (.../OrderReservatie.cls.xml) (revision 7572) @@ -406,7 +406,7 @@ FROM EWMS.Inventory Inv JOIN EWMS.Locations Loc ON Inv.loc_m = Loc.loc_m and Inv.loc_id = Loc.loc_id LEFT JOIN EWMS.TransLoc Trans ON Trans.loc_m = Loc.loc_m AND Trans.loc_g = Loc.loc_g AND Trans.loc_x = Loc.loc_x AND Trans.loc_y = Loc.loc_y - WHERE product = :ProdNr AND Inv.loc_m < 5 + WHERE product = :ProdNr AND Inv.loc_m < 5 AND NOT (Loc.loc_m = 4 AND Loc.loc_g = 2 and Loc.loc_x = 1 and Loc.loc_y = 1) ORDER BY Trans.loc_ispickbaar DESC , Inv.Is_Full ASC ,Inv.Insert_Time ASC ) &sql(OPEN crPPP) Quit:((SQLCODE<0) || ($L($G(%msg)))) $$$ERROR($$$GeneralError,%msg) //ERROR? -> Quit+return status