At present, in aqorders table, Koha stores the biblionumber of the record.
If the record is suppressed (or merged I suppose) for some reason, the title, author, publisher, date of the ordered document could no more be retrieved.
At the end of the year if you make a report for listing all the documents ordered that year, bibliographic information will be missing for some documents.
So, would it be possible to store critical bibliographic information (title, author, publisher, date ?) in aqorders table?
Rennes 2 university
I agree with this. I think the biblionumber should still be there for clicking and seeing the full record, but the basics should be in the orders table or linked to acq in some other way.
Hm, I am not sure how this would work. If you delete a record, you can still query the biblionumber in the deleted* tables for your reports, so it's not lost.
But if you merge 2 records - which information should be stored? I think some libraires might say that it's right that the old information is discarded at least for some use cases.
The problem I see is that the basket says 'deleted title' or something like that - so it's not querying the deleted tables to show the basket info. We need a way to keep the basket showing the info that was on the order even if it has been deleted.
I think the answer is to query the table then :)
Yes, using deleted tables could be a good idea, for avoiding the "deleted record" line.
But... it would not be perfect, in case the record used by the order is modified by the library after the reception of the item.
Ex : You mispell a title, or you put a wrong isbn or title, and you correct it after reception.
If you print again the basketgroup, the information will not be exactly the same as before your changes.
It is a detail, but I think Koha should have a way to print an EXACT copy of an order made 6 month ago. This could be useful for improving our relations with our vendors, and with accounting services.
Currently we have to store copies of pdf basketgroups in a directory, outside Koha.
But what if you want to print a corrected copy? If you have made mistakes and want to resend a corrected order to your vendor? - I am just saying this is a bit complicated and storing the created order or logging the data might be the better approach.
Complicated in that it's not easy to tell what the expected behaviour is for everyone in every situation... hope I make sense.
If the prices of the order were wrong, and does not match the invoiced price, I think the accounting department will ask us for the invoice, not a corrected version of the order.
If an "basket group" in Koha is to be understood as a "Purchase order" (http://en.wikipedia.org/wiki/Purchase_order), it is not supposed to be changed after it is send to the bookseller. Or maybe it could be changed only in very special occasion, and voluntarily.
Mathieu, I never said I don't see a need to store the information, but I still doubt that the aqorders table is the right place to do it. Changing the bibliographic data is only one part of it. You will also be able to move order lines in the future and you can undo every step in the ordering workflow and potentially modify data. So I think if we want to 'freeze' information we should think about a different technical solution.
My point of view : We should focus on taking into account the deleted tables could be easily done, and backported to 3.12/10/8.
For the "freezing" of the basketgroups, it would be a more important enhancement, maybe only for new versions, and it deserves more thinking to find the right solution.
Do you agree wuith that ? If so, we could keep this bug for the "freezing", and create a new bug for taking into account the deleted tables ?
Sounds good to me. Maybe change the bug title to reflect the general goal?
I won't have time to create a new bug today for implementing the use of 'deleted*' tables (I'm struggling with inventory...).
Do you have time to do that?
*** Bug 3016 has been marked as a duplicate of this bug. ***