Bug 29991

Summary: Need to use invoice number as matchpoint when loading MARC file
Product: Koha Reporter: Jeremy Evans <jeremy.evans>
Component: MARC Bibliographic record staging/importAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low    
Version: unspecified   
Hardware: All   
OS: All   
GIT URL: Change sponsored?: ---
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Jeremy Evans 2022-02-01 08:56:48 UTC
Our print book suppliers provide shelf ready books.
When the items are shipped we receive an email containing the MARC records. These files relate to all of the copies shipped on a specific invoice.

The order was done via EDI and the invoice would already be imported via EDI into Koha before we receive this Marc file.
The records autocreated in Koha via EDI when the order was placed would not contain the copy barcode as the supplier will place this in the book during servicing before shipping the item.
By default the MARC load is expecting the item barcode to be already in Koha to use as a match to update the copy record. This isn't the case for our shelf ready books.  If we use the ISBN match to load the MARC file, we often find that a duplicate copy is created during the load. In some cases there are other existing copies held in our stock which should not be updated.

What we need is an option to Select the invoice number (& possibly the supplier first), and load the MARC file. it should then update only the copies that are linked to that invoice so the item barcode and call number for those copies can be updated during the load.