[Koha-bugs] [Bug 20150] Acquisitions wizard falsely uses list price for calculating amounts spent

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20150

Katrin Fischer <katrin.fischer at bsz-bw.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Needs Signoff               |Failed QA

--- Comment #8 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
Hi Jonathan,

the calculation for "Amount" is not right:

+    } elsif ( $process == 3 ) { # Amount
+        $strcalc .= q|SUM(| .
C4::Acquisition::get_rounding_sql(q|ecost_tax_included|) . q| * quantity ) +
SUM(| . C4::Acquisition::get_rounding_sql(q|COALESCE(unitprice_tax_included,
ecost_tax_included)|) . q| * quantity ) AS budget_total |;


I see about double of the value I should be seening. I think this is because in
case of a received order, we do add up ecost + unit_price here for the same
order line.

-- 
You are receiving this mail because:
You are watching all bug changes.