<div dir="ltr"><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">Hi Josh,</div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">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.</div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">Tiffany</div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><span><br><div dir="ltr" style="margin-left:0pt" align="left"><table style="border:none;border-collapse:collapse"><colgroup><col width="89"><col width="414"></colgroup><tbody><tr style="height:123pt"><td style="vertical-align:top;padding:5pt 5pt 5pt 5pt;overflow:hidden"><p dir="ltr" style="line-height:1.44;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;overflow:hidden;width:75px;height:75px"><img src="https://lh6.googleusercontent.com/8c2XlzLbIIC6nDoa4yqQ8MzA0npF4WXpUnhhoK_uTqralZtjqVXRwPgmRep3jGYP6q41Sb0ULXqxX-QppYTC8cQyIfBAdqzLBgqvcQwVczkqqiunlj0KIbvy-R3bp-E0mlhF0A4v" width="75" height="75" style="margin-left:0px;margin-top:0px"></span></span></p></td><td style="vertical-align:top;padding:5pt 5pt 5pt 5pt;overflow:hidden"><p dir="ltr" style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span style="color:rgb(30,67,155);background-color:transparent;font-weight:700;vertical-align:baseline;white-space:pre-wrap"><font face="tahoma, sans-serif">Tiffany Little, PINES Services Specialist: Acquisitions</font></span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"></p><hr><p></p><p dir="ltr" style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span style="font-size:9pt;color:rgb(30,67,155);background-color:transparent;font-weight:700;vertical-align:baseline;white-space:pre-wrap"><font face="tahoma, sans-serif">Georgia Public Library Service | University System of Georgia</font></span></p><p dir="ltr" style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span style="font-size:9pt;color:rgb(30,67,155);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><font face="tahoma, sans-serif">2872 Woodcock Blvd, Suite 250 l Atlanta, GA 30341</font></span></p><p dir="ltr" style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span style="font-size:9pt;color:rgb(30,67,155);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><font face="tahoma, sans-serif">(404) 235-7161 | <a href="mailto:tlittle@georgialibraries.org" target="_blank">tlittle@georgialibraries.org</a></font></span></p><br><p dir="ltr" style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;overflow:hidden;width:36px;height:36px"><img src="https://lh6.googleusercontent.com/ql1so1R8csbb2W7DW5vjWe3mTAcApuM7a5CMXbsYnhmF1bDmG62LM_C1BOOyWdkb2PZGKGlaYRIceHjsSvsWPXNw6HPCKqtFLMKCJiPVU0RXu2dAey13WZ02Q6E6FmzNDJ_d9iBf" width="36" height="36" style="margin-left:0px;margin-top:0px"></span></span><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;overflow:hidden;width:35px;height:35px"><img src="https://lh3.googleusercontent.com/2qSr0-AREIyPSTC1gMsjyXLaBT-yQ7kS6iKvd1L9XrCXxhJDWCRo5eXBHCi7f35AZASOOyiH2Si-wtuXNR8YaA2j-17GWBmmo1mpGxXa7m-JwF4AzUD_5tZZE9n1NVilAJcnGtQs" width="35" height="35" style="margin-left:0px;margin-top:0px"></span></span><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;overflow:hidden;width:35px;height:35px"><img src="https://lh6.googleusercontent.com/-jM_GEWd7EZGo5MFiR1koKEkiupb_lmwNEMpNiQE3U6k1C2FkyuiNjtGKlWWGfX8zbZ1135yhOHnJSINmMTXgEQuu2RlHIg5hDKxaJ9cmh3Nr6el_vN4ZHlXcAmoCPPWduwXi26m" width="35" height="35" style="margin-left:0px;margin-top:0px"></span></span></p></td></tr><tr style="height:21pt"><td colspan="2" style="vertical-align:top;padding:5pt 5pt 5pt 5pt;overflow:hidden"><p dir="ltr" style="line-height:1.44;text-align:center;margin-top:0pt;margin-bottom:0pt"><a href="http://georgialibraries.org/" target="_blank"><span style="font-size:8pt;font-family:Verdana;color:rgb(17,85,204);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap">Join our email list</span></a><span style="font-size:8pt;font-family:Verdana;color:rgb(0,0,0);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap"> </span><span style="font-size:8pt;font-family:Verdana;color:rgb(67,67,67);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap">for stories of Georgia libraries making an impact in our communities.</span></p></td></tr></tbody></table></div></span></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Feb 8, 2023 at 12:32 PM Josh Stompro via Evergreen-general <<a href="mailto:evergreen-general@list.evergreen-ils.org">evergreen-general@list.evergreen-ils.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><span style="color:rgb(0,0,0)">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.</span><div style="color:rgb(0,0,0)"><br></div><div style="color:rgb(0,0,0)">So the item still shows up as backordered even though we have it and it was included in the invoice message.</div><div style="color:rgb(0,0,0)"><br></div><div style="color:rgb(0,0,0)">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.</div><div style="color:rgb(0,0,0)"><br></div><font face="monospace" style="color:rgb(0,0,0)">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"</font><div style="color:rgb(0,0,0)"><font face="monospace"><br></font></div><div style="color:rgb(0,0,0)"><font face="arial, sans-serif">Does anyone have notes on how to deal with this? </font></div><div style="color:rgb(0,0,0)"><font face="arial, sans-serif"><br></font></div><div style="color:rgb(0,0,0)"><font face="arial, sans-serif">Thank you</font></div><div style="color:rgb(0,0,0)"><font face="arial, sans-serif">Josh</font></div><br><div><div dir="ltr"><div dir="ltr"><table style="padding:0px;margin:10px 0px;border:none"><tbody><tr><td style="vertical-align:middle;padding:0px 7px 0px 0px"><img alt="Company logo" height="107" src="https://storage.googleapis.com/signaturesatori/customer-C039u5c5y/images/7DIM6.png" width="125"></td><td style="border-left:3px solid rgb(232,232,232);padding:7px 0px 0px 10px">
<div style="font-family:arial,helvetica,sans-serif;font-size:14px;line-height:17px;font-weight:bold;color:rgb(238,142,22)"><span style="color:rgb(0,0,0)"><strong>Josh Stompro</strong></span></div>
<div style="font-family:arial,helvetica,sans-serif;font-size:12px;line-height:14px;font-weight:normal;color:rgb(0,0,0);margin-bottom:10px">IT Director<br>
<a href="mailto:stomproj@gsuite.larl.org" target="_blank"><span style="color:rgb(27,70,152)">stomproj@gsuite.larl.org</span></a><span style="color:rgb(27,70,152)"> </span>| 218-233-3757 ext. 139<span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:small;color:rgb(32,33,36)"> </span>| 218-790-2110</div>
<div style="font-family:arial,helvetica,sans-serif;font-size:12px;line-height:14px;color:rgb(0,0,0)"><strong>Lake Agassiz Regional Library </strong></div>
<div style="font-family:arial,helvetica,sans-serif;font-size:12px;line-height:14px;font-weight:normal;color:rgb(0,0,0);margin-bottom:10px">118 5th ST S<br>Moorhead MN 56560<br>
<a href="http://www.larl.org" target="_blank"><span style="color:rgb(27,70,152)">www.larl.org</span></a><br>
<em>Our mission is to enrich lives and strengthen communities.</em></div>
</td></tr></tbody></table>
</div></div></div></div>
_______________________________________________<br>
Evergreen-general mailing list<br>
<a href="mailto:Evergreen-general@list.evergreen-ils.org" target="_blank">Evergreen-general@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a><br>
</blockquote></div>