https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33756 --- Comment #6 from Emmi Takkinen <emmi.takkinen@koha-suomi.fi> --- (In reply to Mathieu Saby from comment #5)
I am trying to test, but your report
SELECT budget_id, budget_code FROM aqbudgets WHERE budget_id IN( SELECT budget_id FROM aqorders WHERE quantity != quantityreceived AND quantityreceived > 0)
never seems to give any result. It seem logical, since when a partial reception is made for a book ordered in multiple copies, Koha create a new order line.
In which situation is the condition (quantity != quantityreceived AND quantityreceived > 0) supposed to return true ?
I did not test further for the moment.
It should return orders where quantity a.k.a. how many items has been ordered within a single order doesn't yet match the quantity of received items. Condition quantityreceived > 0 then leaves out those orders where none of the ordered items hasn't yet been received. -- You are receiving this mail because: You are watching all bug changes.