View | Details | Raw Unified | Return to bug 33756
Collapse All | Expand All

(-)a/C4/Budgets.pm (-2 / +1 lines)
Lines 735-741 sub GetBudgetHierarchy { Link Here
735
            SELECT aqorders.budget_id, aqbudgets.budget_parent_id,
735
            SELECT aqorders.budget_id, aqbudgets.budget_parent_id,
736
                SUM( |
736
                SUM( |
737
                . C4::Acquisition::get_rounding_sql(qq|COALESCE($unitprice_field, $ecost_field)|)
737
                . C4::Acquisition::get_rounding_sql(qq|COALESCE($unitprice_field, $ecost_field)|)
738
                . q| * quantity ) AS budget_spent
738
                . q| * quantityreceived ) AS budget_spent
739
            FROM aqorders JOIN aqbudgets USING (budget_id)
739
            FROM aqorders JOIN aqbudgets USING (budget_id)
740
            WHERE quantityreceived > 0 AND datecancellationprinted IS NULL
740
            WHERE quantityreceived > 0 AND datecancellationprinted IS NULL
741
            GROUP BY budget_id, budget_parent_id
741
            GROUP BY budget_id, budget_parent_id
742
- 

Return to bug 33756