https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43534 Bug ID: 43534 Summary: Allow MarcFieldsToOrder to map a MARC field to supplier's reference number/qualifier Initiative type: --- Sponsorship --- status: Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Acquisitions Assignee: koha-bugs@lists.koha-community.org Reporter: martin.renvoize@openfifth.co.uk QA Contact: testopia@bugs.koha-community.org Target Milestone: --- This enhancement extends the MARC Orders workflow (Koha::MarcOrder, driven by the MarcFieldsToOrder / MarcItemFieldsToOrder system preferences) to allow mapping a field on the incoming MARC order record to the existing aqorders.suppliers_reference_number and aqorders.suppliers_reference_qualifier columns. Currently those two columns are only ever populated by the EDIFACT quote-to-order flow (Koha::EDI, when an order is created from a supplier's QUOTES message), using the reference value the supplier returned in RFF+QLI or RFF+SLI. Koha::MarcOrder.pm has no equivalent mapping target, so an order created by staging a MARC file from a vendor can never record that vendor's own unique identifier for the order line. Use case: Vendors such as GOBI/YBP can supply MARC order records for import via MarcFieldsToOrder, and separately send EDIFACT INVOIC (invoice) messages for those same orders, quoting their own unique order/line reference (e.g. a GOBI order ID) in RFF+SLI. If Koha could capture that same vendor reference at MARC-order time into suppliers_reference_number / suppliers_reference_qualifier, it would become possible to match invoice lines back to the correct aqorders row using the vendor's own ID, rather than relying solely on Koha's internal ordernumber (RFF+LI) being echoed back correctly by the vendor. This bug is a prerequisite for a related enhancement to add RFF+SLI matching support to EDI invoice processing (Koha::EDI). Suggested implementation: - Add a mapping option in the MarcFieldsToOrder (and/or MarcItemFieldsToOrder) YAML syntax for suppliers_reference_number and suppliers_reference_qualifier. - Have Koha::MarcOrder read this mapping when building the order hash passed to Koha::Acquisition::Order->new / ->insert, alongside the other mapped fields. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.