From 909e172c17d0bb69fa9f9a25bf7d075b7dcc99c2 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Fri, 6 Mar 2020 11:38:03 +0000 Subject: [PATCH] Bug 24820: Use 'date' instead of 'timestamp' for cashup Prior to this patch we were comparing cash register action timestamp to accountlines date fields to fetch the list of outstanding accountlines. accountlines.date is a transient field used as 'updated_on' and so this was a logical mistake. We should be using the 'date' field which is fixed 'created_on' time. Signed-off-by: David Nind Signed-off-by: Katrin Fischer Signed-off-by: Martin Renvoize --- Koha/Cash/Register.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Koha/Cash/Register.pm b/Koha/Cash/Register.pm index d033ab6ff2..ca140b9ed2 100644 --- a/Koha/Cash/Register.pm +++ b/Koha/Cash/Register.pm @@ -126,7 +126,7 @@ sub outstanding_accountlines { my $local_conditions = $since->count - ? { 'timestamp' => { '>' => $since->get_column('timestamp')->as_query } } + ? { 'date' => { '>' => $since->get_column('timestamp')->as_query } } : {}; my $merged_conditions = $conditions -- 2.39.5