From 90a1db42c6fad82a5e3f955f069293238b631f8c Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Fri, 20 Mar 2020 10:13:04 +0000 Subject: [PATCH] Bug 22569: Refine GetTransfersFromTo to filter out unsent transfers GetTransfersFromTo is used solely by the transferstorecieve page which assumes items have already been sent. With the introduction of daterequested we allow for a state where a transfer has been scheduled but not yet sent (See stockrotation for such a case) and so we need to filter these transfers out from the transferstorecieve report. --- C4/Circulation.pm | 1 + 1 file changed, 1 insertion(+) diff --git a/C4/Circulation.pm b/C4/Circulation.pm index 8c10fd8e02..1889f8b35b 100644 --- a/C4/Circulation.pm +++ b/C4/Circulation.pm @@ -3475,6 +3475,7 @@ sub GetTransfersFromTo { FROM branchtransfers WHERE frombranch=? AND tobranch=? + AND datesent IS NOT NULL AND datearrived IS NULL "; my $sth = $dbh->prepare($query); -- 2.20.1