@@ -, +, @@ --- C4/Acquisition.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) --- a/C4/Acquisition.pm +++ a/C4/Acquisition.pm @@ -489,7 +489,7 @@ sub GetBasketsInfosByBookseller { SUM(IF(aqorders.datereceived IS NULL, aqorders.quantity, 0)) AS expected_items FROM aqbasket LEFT JOIN aqorders ON aqorders.basketno = aqbasket.basketno - WHERE booksellerid = ? + WHERE booksellerid = ? AND aqorders.datecancellationprinted IS NULL GROUP BY aqbasket.basketno }; my $sth = $dbh->prepare($query); --