X-Git-Url: http://koha-dev.rot13.org:8081/gitweb/?a=blobdiff_plain;ds=sidebyside;f=C4%2FBudgets.pm;h=7c867e0aabdea5a5a3170845bfd3b4635e1c71d2;hb=f84671dce925ef0f5127073520d35b480613e3c1;hp=888b4fde5418601fb234df0a7623a5aed971b856;hpb=1a03a8a38eb07b9bf55e3e2afeb4f2cb4e954f66;p=koha_gimpoz

diff --git a/C4/Budgets.pm b/C4/Budgets.pm
index 888b4fde54..7c867e0aab 100644
--- a/C4/Budgets.pm
+++ b/C4/Budgets.pm
@@ -304,7 +304,7 @@ sub GetBudgetSpent {
 	my ($budget_id) = @_;
 	my $dbh = C4::Context->dbh;
 	my $sth = $dbh->prepare(qq|
-        SELECT SUM(ecost *  quantity) AS sum FROM aqorders
+        SELECT SUM( COALESCE(unitprice, ecost) * quantity ) AS sum FROM aqorders
             WHERE budget_id = ? AND
             quantityreceived > 0 AND
             datecancellationprinted IS NULL