https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42225 --- Comment #7 from Paul Derscheid <paul.derscheid@lmscloud.de> --- Created attachment 201859 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=201859&action=edit Bug 42225: (QA follow-up) Use configured unitprice field in outer SELECT The outer SELECT hardcoded unitprice_tax_included while the inner subquery selects the field returned by FieldsForCalculatingFundValues. With CalculateFundValuesIncludingTax disabled the derived table only exposes unitprice_tax_excluded, so spent.pl dies with: Unknown column 'unitprice_tax_included' in 'field list' To test: 1. Set CalculateFundValuesIncludingTax to 'Exclude' 2. View spent.pl for a fund with received orders 3. Observe error 500 4. Apply patch, restart_all 5. Reload, page renders correctly 6. Set CalculateFundValuesIncludingTax back to 'Include' 7. Reload, page still renders correctly Signed-off-by: Paul Derscheid <paul.derscheid@lmscloud.de> -- You are receiving this mail because: You are watching all bug changes.