Ability to find bib records with attached PO lines but no inventory
Problem:
It is not possible to easily find IZ bibliographic records that have associated PO lines but no inventory. The All Titles Advanced Search has an option to search for “Has inventory | equals | no”, but those results include bibliographic records that have related holdings records (bound withs), as well as bibliographic records that have holdings records but no item records. We want the ability to easily find bibliographic records that have only a PO line associated with them.
Use Case:
The ability to find bibs with only PO lines attached is necessary in order to keep the database tidy. Examples include:
bibliographic records that migrated with PO lines or order records attached but no inventory.
bibliographic records where inventory was relinked but the PO line left behind.
Potential solutions:
The NZ has a job (Identify records that are not used in the Network) that provides operators with several options for defining which records are considered “unused”, including those with no inventory and not part of a boundwith relation. One potential solution to the problem is to have a similar job in the IZ that would allow us to find bib records with PO lines but also exclude holdings records with no items.
Another potential solution to this problem is to have a new search index (and corresponding indexed field) in Alma that would allow an advanced search for bibliographic records with attached order records but no holdings/inventory records.
Dear community,
Thank you for raising this idea.
I would like to better understand the use case here:
1 How often such check is done? if this is a "cleanup" that is done once in a few month, for example, perhaps an analytics report would be sufficient?
2 In the description you wrote about the "has inventory" index. Can you give more details, why it is not useful for the described use case?
Thanks,
Tamar Fuches
Alma product team