From bd136bd78d0c8e2177bc861d42732635ae81d17d Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Mon, 6 Feb 2017 10:04:57 +0100 Subject: [PATCH] Bug 14535: Late orders does not show orders with price = 0 This patch removes the filter of unitpricesupplier <> 0 and unitpricelib <> 0 from GetLateOrders as used in lateorders.pl. This allows you to claim late orders without a price entered. Test plan: [1] Run t/db_dependent/Acquisition.t [2] Check if you see an order with no price in lateorders.pl. (If needed, remove prices from a few orders.) Signed-off-by: Marcel de Rooy Signed-off-by: Srdjan Signed-off-by: Jonathan Druart Signed-off-by: Kyle M Hall (cherry picked from commit 71f267fd3f3750510e3df5f2819d57ed45dcf919) Signed-off-by: Katrin Fischer --- C4/Acquisition.pm | 6 +----- 1 file changed, 1 insertion(+), 5 deletions(-) diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm index 45554da015..dcd533f505 100644 --- a/C4/Acquisition.pm +++ b/C4/Acquisition.pm @@ -2045,11 +2045,7 @@ sub GetLateOrders { $from .= " AND (closedate <= DATE_SUB(CAST(now() AS date),INTERVAL ? DAY)) " ; push @query_params, $delay; } - $having = " - HAVING quantity <> 0 - AND unitpricesupplier <> 0 - AND unitpricelib <> 0 - "; + $having = "HAVING quantity <> 0"; } else { # FIXME: account for IFNULL as above $select .= " -- 2.39.5