[Koha-devel] stocknumber and invertory books in Koha

[Dobrica Pavlinusic]

I need help from people who use stocknumbers in their Koha's installs.

I assume this is mostly Europe-specific since we are required by low to
keep invetory books with each item in our library but I hope that
other people might have similar legal requirements.

For a start, why is index defined on items.stocknumber non-unique?
I would assume that it has to be unique like barcode is (at least that's
our legal requirement).

Other than that, we need to have some representation of "inventory book"
which I plan to implement using additional local table in which I will
record stocknumber, biblionumber and various other fields required for
invertory book reporting. This duplicates data (which is bad if you ever
heard for normal forms in RDBMS), but it's required to cover case of
erasing items. If we don't have a copy of item, erased it would also
erase entry from invetory book which is very, very bad.

During implementation of this feature, I stumbled upon bug 7451[1] which
breaks AJAX value_builder in which I plan to implement assigment of next
invetory number and copying of data into separate invetory audit table.

Would this value_builder be useful to other Koha users, or is it too specific
for our use-case?

1: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7451

-- 
Dobrica Pavlinusic               2share!2flame            dpavlin at rot13.org
Unix addict. Internet consultant.             http://www.rot13.org/~dpavlin