@@ -, +, @@ GROUP BY at /home/vagrant/kohaclone/C4/Budgets.pm line 558. at /home/vagrant/kohaclone/C4/Budgets.pm line 565. --- C4/Budgets.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) --- a/C4/Budgets.pm +++ a/C4/Budgets.pm @@ -560,14 +560,14 @@ sub GetBudgetHierarchy { SUM( COALESCE(unitprice_tax_included, ecost_tax_included) * quantity ) AS budget_spent FROM aqorders JOIN aqbudgets USING (budget_id) WHERE quantityreceived > 0 AND datecancellationprinted IS NULL - GROUP BY budget_id + GROUP BY budget_id, budget_parent_id |, 'budget_id'); my $hr_budget_ordered = $dbh->selectall_hashref(q| SELECT aqorders.budget_id, aqbudgets.budget_parent_id, SUM(ecost_tax_included * quantity) AS budget_ordered FROM aqorders JOIN aqbudgets USING (budget_id) WHERE quantityreceived = 0 AND datecancellationprinted IS NULL - GROUP BY budget_id + GROUP BY budget_id, budget_parent_id |, 'budget_id'); my $hr_budget_spent_shipment = $dbh->selectall_hashref(q| SELECT shipmentcost_budgetid as budget_id, --