X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=C4%2FBookseller.pm;h=c8389a34410798a2b10159273da1c9efbe68e9ed;hb=3bca90eb0c0fc91f64f3e479ac6ab25e54d4f1aa;hp=5874a936819650305a9da467a15eaf7145754385;hpb=9dc42e9ec4bb6ab0511000018adaa0f7883c905f;p=koha.git

diff --git a/C4/Bookseller.pm b/C4/Bookseller.pm
index 5874a93681..c8389a3441 100644
--- a/C4/Bookseller.pm
+++ b/C4/Bookseller.pm
@@ -125,7 +125,7 @@ sub GetBooksellersWithLateOrders {
             )
             AND aqorders.rrp <> 0
             AND aqorders.ecost <> 0
-            AND aqorders.quantity - IFNULL(aqorders.quantityreceived,0) <> 0
+            AND aqorders.quantity - COALESCE(aqorders.quantityreceived,0) <> 0
             AND aqbasket.closedate IS NOT NULL
     ";
     if ( defined $delay ) {