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

[Josh Stompro]

Tiffany, thank you for this tip.  I spent time last week figuring this out
and your suggestion worked great to get an additional import done.

It turns out that the problem we were running into wasn't about B&T
changing the ISBN for the order.  B&T sent the wrong line item number in
the EDI invoice, they re-used one that they had already invoiced us for.
So that was why it wasn't matching.  The evergreen EDI invoice processing
code doesn't care what ISBN gets sent, it just matches on the line item
number.

To fix it, I edited the EDI message and processed it locally again, after
clearing out the old invoice by detaching the items and renaming it.

Thanks
Josh


On Wed, Feb 8, 2023 at 11:40 AM Tiffany Little <tlittle at georgialibraries.org>
wrote:

> 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/20230410/4926e81c/attachment.htm>