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