X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=C4%2FAcquisition.pm;h=17330e5dd912370576c91af36d8e8acea94a182e;hb=aeb48e2534663e36e488713feaac96dd794836ab;hp=83031becabd099229969c8222307edd2e2f2b35a;hpb=5cea05831a59dbae12e60437870908221708b47d;p=koha.git

diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm
index 83031becab..17330e5dd9 100644
--- a/C4/Acquisition.pm
+++ b/C4/Acquisition.pm
@@ -1795,8 +1795,8 @@ sub GetLateOrders {
     my $having = "";
     if ($dbdriver eq "mysql") {
         $select .= "
-        aqorders.quantity - IFNULL(aqorders.quantityreceived,0)                 AS quantity,
-        (aqorders.quantity - IFNULL(aqorders.quantityreceived,0)) * aqorders.rrp AS subtotal,
+        aqorders.quantity - COALESCE(aqorders.quantityreceived,0)                 AS quantity,
+        (aqorders.quantity - COALESCE(aqorders.quantityreceived,0)) * aqorders.rrp AS subtotal,
         DATEDIFF(CAST(now() AS date),closedate) AS latesince
         ";
         if ( defined $delay ) {