Hi Josh, As far as not being able to reimport the same invoice, I usually get around that by (1) making sure the invoice is open, (2) detaching all the line items, (3) changing the vendor invoice ID to something else, even if that's [PREVIOUS INVOICE #]-ERROR. Then you can save and close that invoice so that it's out of the way. Then the next time the fetcher runs, it won't consider that a dupe and it should import the new invoice again.
Tiffany Tiffany Little, PINES Services Specialist: Acquisitions ------------------------------ Georgia Public Library Service | University System of Georgia 2872 Woodcock Blvd, Suite 250 l Atlanta, GA 30341 (404) 235-7161 | tlit...@georgialibraries.org Join our email list <http://georgialibraries.org/> for stories of Georgia libraries making an impact in our communities. On Wed, Feb 8, 2023 at 12:32 PM Josh Stompro via Evergreen-general < evergreen-general@list.evergreen-ils.org> wrote: > Hello, we have an EDI order where the ISBN that we sent in the initial > order was changed by B&T to something different in the Invoice response. > > So the item still shows up as backordered even though we have it and it > was included in the invoice message. > > We have tried adding the new ISBN to the bib, and had B&T resend the > Invoice EDI message... but we are hitting the fact that you cannot > re-import the same invoice again. > > open-ils.cstore ERROR inserting acq::invoice object using query [INSERT > INTO acq.invoice > (id,receiver,provider,shipper,recv_date,recv_method,inv_type,inv_ident,payment_auth,payment_method,note,close_date,closed_by) > VALUES > (DEFAULT,101,12,12,'2023-01-11','EDI',DEFAULT,'2037242310',DEFAULT,DEFAULT,'Generated > from acq.edi_message #24636.',DEFAULT,DEFAULT);]: 3505685 3505685: ERROR: > duplicate key value violates unique constraint > "inv_ident_once_per_provider" > > Does anyone have notes on how to deal with this? > > Thank you > Josh > > [image: Company logo] > *Josh Stompro* > IT Director > stomp...@gsuite.larl.org | 218-233-3757 ext. 139 | 218-790-2110 > *Lake Agassiz Regional Library * > 118 5th ST S > Moorhead MN 56560 > www.larl.org > *Our mission is to enrich lives and strengthen communities.* > _______________________________________________ > Evergreen-general mailing list > Evergreen-general@list.evergreen-ils.org > http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general >
_______________________________________________ Evergreen-general mailing list Evergreen-general@list.evergreen-ils.org http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general
