[Evergreen-general] EDI - Vendor changed the ISBN/Identifier - how to deal with

[Tiffany Little]

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 | tlittle at 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 at 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
> stomproj at 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 at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-general/attachments/20230208/19194381/attachment.htm>