From 4e3301aeab592c9bcb067cf7d209720c9fd6c83f Mon Sep 17 00:00:00 2001 From: =?utf-8?q?Fr=C3=A9d=C3=A9rick=20Capovilla?= Date: Tue, 17 May 2011 11:39:11 -0400 Subject: [PATCH] Correct GetLateOrders so it ignores cancelled orders --- C4/Acquisition.pm | 1 + 1 files changed, 1 insertions(+), 0 deletions(-) diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm index c1b837b..e3102bc 100644 --- a/C4/Acquisition.pm +++ b/C4/Acquisition.pm @@ -1430,6 +1430,7 @@ sub GetLateOrders { OR datereceived IS NULL OR aqorders.quantityreceived < aqorders.quantity ) + AND (aqorders.datecancellationprinted IS NULL OR aqorders.datecancellationprinted='0000-00-00') "; my $having = ""; if ($dbdriver eq "mysql") { -- 1.5.6.5