https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20150 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Acquisitions wizard always |Acquisitions wizard falsely |uses listprice |uses list price for | |calculating amounts spent -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20150 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|normal |major --- Comment #2 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Hi Maura, I'd love to see this fixed, but probably won't have the time tow ork on it myself. I reported this, as one of our libraries brought it to my attention - but it didn't get any attention so far. I am updating the severity a bit. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20150 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20150 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@bugs.koha-c | |ommunity.org --- Comment #5 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Hi Maura, this report script looks quite obsolete as it has not been updated for years. I tried to fix the different amount to match the ones we have on the acquisiton home page. Can you give it a try please? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20150 --- Comment #6 from Maura Stephens <maura.stephens@gmit.ie> --- Hi Jonathan, Firstly on Koha Acq none of the price fields in an order record field are called 'list price' there are 'vendor price' and 'retail price' so I had to open a call with Interleaf to work out which one this is. This make it confusing for End of Year Stats I've run the Wizard reports in question again but as I had to do some investigations when I was trying to figure out what was happening here I guess it will be end 2021 when I get true figures. I've said this before to Interleaf that Annual Acq stats should be solely based on encumbrances and expenditure per annum. The reopening of baskets skewing stats is not a good feature when you have to make annual reports to Finance departments. Thanks for looking at it. -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20150 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Failed QA --- Comment #8 from Katrin Fischer <katrin.fischer@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.