@@ -, +, @@ budgets over inactive budgets --- C4/Budgets.pm | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) --- a/C4/Budgets.pm +++ a/C4/Budgets.pm @@ -777,10 +777,11 @@ sub GetBudgetByCode { my $dbh = C4::Context->dbh; my $query = qq{ - SELECT * + SELECT aqbudgets.* FROM aqbudgets + JOIN aqbudgetperiods USING (budget_period_id) WHERE budget_code = ? - ORDER BY budget_id DESC + ORDER BY budget_period_active DESC, budget_id DESC LIMIT 1 }; my $sth = $dbh->prepare( $query ); --