Deleting an order before a basket is closed sets aqorders.datecancellationprinted, but does *not* change aqorders.orderstatus, which stays at 'new'. When the basket is closed, aqorders.orderstatus is set to 'ordered' I can't tell if this is an oversight, or an attempt to distinguish between orders cancelled before the basket is sent to the vendor (i.e. orders abandoned by the library) and orders cancelled after the basket is closed (cancelled by the vendor) -- See Bug 10918. To replicate: Prerequisites: Existing vendor, Budget, Fund, set up an open basket. 1/ Place an order 2/ Cancel the order Run the following query: SELECT ordernumber, biblionumber, orderstatus, datecancellationprinted FROM aqorders WHERE orderstatus IN ('ordered', 'new') AND datecancellationprinted IS NOT NULL You will see orders with orderstatus set to 'new', and datecancellationprinted with today's date. 3/ Close the basket Run the query again, orderstatus for the new orders will now be 'ordered'.
Hm, it looks like a bug to me as we have a specific cancelled status.
I just retested this on current master and it worked alright: - create basket - create order line (status: new) - cancel order line (status: cancelled) Which version did you report this against?
(In reply to Katrin Fischer from comment #2) > I just retested this on current master and it worked alright: > > - create basket > - create order line (status: new) > - cancel order line (status: cancelled) > > Which version did you report this against? Huh. You are right, it's all good until you close the basket. Then the cancelled order is turned into 'ordered'
One of our customers has also reported this but added the following detail... If you reopen the basket then the ordered status changes to New... this is despite the order having been cancelled.
Hi Fiona, I think the last bit is covered by the new patch on bug 19120. *** This bug has been marked as a duplicate of bug 19120 ***