From 6f356cecc35fa3b1b2a730703fa2d7fbeaddf0d7 Mon Sep 17 00:00:00 2001
From: Tomas Cohen Arazi <tomascohen@theke.io>
Date: Fri, 5 Jul 2019 14:47:09 -0300
Subject: [PATCH] Bug 22563: Typo in query (manualinvoice)

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
---
 C4/Accounts.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/C4/Accounts.pm b/C4/Accounts.pm
index 304911628d..34a3ef91a9 100644
--- a/C4/Accounts.pm
+++ b/C4/Accounts.pm
@@ -163,7 +163,7 @@ sub manualinvoice {
           ? $checkouts->next
           : Koha::Old::Checkouts->search(
             { itemnumber => $itemnum, borrowernumber => $borrowernumber },
-            { order_by   => { 'DESC' => 'returndate' }, rows => 1 }
+            { order_by   => { -desc => 'returndate' }, rows => 1 }
         )->next;
         $issue_id = $checkout ? $checkout->issue_id : undef;
     }
-- 
2.39.5