<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Gotham Medium";
panose-1:2 0 6 4 3 0 0 2 0 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Tahoma",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif">Oh wow, Tiffany, I would love to know the criteria for all of your reports and the SQL script that you run to get the massive year-end fund debit info! I will be glad to share the report criteria
for our existing reports and any that I am able to build in the near future after a scrum session with Blake and the NC Cardinal team this afternoon.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif">I spent some time yesterday reviewing acq bugs and saw the issues surrounding cancelled items. One of our libraries is having a problem with some items cancelled in the last FY and reordered
with a new PO showing up as backordered, even after she receives them. Not sure yet whether it has to do with the EDI message from the vendor or not, so these reports might help.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif">The pending PO and deleted bibs issue is something we’ve run into in the past and I like your report for older Pos that haven’t been activated yet!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif">Do you think this info is something that would be of enough interest to others that it would be worth posting on the wiki somewhere? Report templates can be a bit of a pain to setup and test
at the best of times (I feel your v14 pain!) and sharing this info might save some grief for someone down the road. Some things may be setup to work a bit differently for each separate consortia or system, but most report templates should work for most people.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif">Regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif">April<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:"Tahoma",sans-serif">April Durrence<span style="color:black"><o:p></o:p></span></span></b></p>
<p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif">NC Cardinal Training Specialist<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif">State Library of North Carolina<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif">919.814.6794 |
<a href="mailto:april.durrence@ncdcr.gov">april.durrence@ncdcr.gov</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black">NC Dept. of Natural and Cultural Resources<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black">109 East Jones Street | 4640 Mail Service Center
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black">Raleigh, North Carolina 27699-4600<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-top:6.0pt"><a href="https://www.facebook.com/StateLibraryNC/"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Facebook</span></a><span style="font-size:10.0pt;font-family:"Arial",sans-serif">
</span><a href="https://twitter.com/StateLibraryNC"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Twitter</span></a><span style="font-size:10.0pt;font-family:"Arial",sans-serif"> </span><a href="http://www.instagram.com/ncculture"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Instagram</span></a><span style="font-size:10.0pt;font-family:"Arial",sans-serif">
</span><a href="https://www.youtube.com/user/statelibrarync/"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">YouTube</span></a><span style="font-size:10.0pt;font-family:"Arial",sans-serif"> </span><a href="https://statelibrary.ncdcr.gov/"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Website</span></a><span style="font-size:10.0pt;font-family:"Arial",sans-serif">
<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-top:6.0pt"><a href="https://statelibrary.ncdcr.gov/"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:windowtext;text-decoration:none"><img border="0" width="327" height="102" style="width:3.4083in;height:1.0583in" id="Picture_x0020_2" src="cid:image001.jpg@01D6708D.2DC23410" alt="A close up of a logo
Description automatically generated"></span></a><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt;color:#7F7F7F">Email correspondence to and from this address is subject to the North Carolina Public Records Law and may be disclosed to third parties.</span></i><i><span style="font-size:10.0pt;color:#7F7F7F"><o:p></o:p></span></i></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.0pt;font-family:"Gotham Medium";color:black">#StayStrongNC<br>
Learn more @ nc.gov/covid19 </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Gotham Medium";color:black">And don’t forget your Ws! Wear. Wait. Wash.</span><o:p></o:p></p>
<p class="MsoNormal"><u><span style="font-size:10.0pt;font-family:"Gotham Medium";color:black">WEAR</span></u><span style="font-size:10.0pt;font-family:"Gotham Medium";color:black"> a face covering.</span><o:p></o:p></p>
<p class="MsoNormal"><u><span style="font-size:10.0pt;font-family:"Gotham Medium";color:black">WAIT</span></u><span style="font-size:10.0pt;font-family:"Gotham Medium";color:black"> 6 feet apart from other people. </span><o:p></o:p></p>
<p class="MsoNormal"><u><span style="font-size:10.0pt;font-family:"Gotham Medium";color:black">WASH</span></u><span style="font-size:10.0pt;font-family:"Gotham Medium";color:black"> your hands often.</span><o:p></o:p></p>
</div>
<p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Evergreen-acq <evergreen-acq-bounces@list.evergreen-ils.org>
<b>On Behalf Of </b>Tiffany Little<br>
<b>Sent:</b> Tuesday, August 11, 2020 7:48 PM<br>
<b>To:</b> Discussion of acquisitions in Evergreen <evergreen-acq@list.evergreen-ils.org><br>
<b>Subject:</b> [External] Re: [Evergreen-acq] Acquisitions reports<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:solid #0099CC 1.0pt;padding:2.0pt 2.0pt 2.0pt 2.0pt">
<p class="MsoNormal" style="line-height:12.0pt;background:#00CCFF"><b><span style="font-size:10.0pt;color:yellow">CAUTION:</span></b><span style="font-size:10.0pt;color:black"> External email. Do not click links or open attachments unless you verify. Send all
suspicious email as an attachment to <a href="mailto:report.spam@nc.gov"><span style="color:red">report.spam@nc.gov</span></a><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif">Hi April,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif">Here's the list of reports that we recommend to run at FYE here in PINES: <a href="https://urldefense.com/v3/__https:/pines.georgialibraries.org/dokuwiki/doku.php?id=acq:yearend*reports__;Iw!!HYmSToo!MqwMue0Kq1Vfp0uCEZ5YWCgSNwPw6jRCgd9JpwWAF-ik1p7kuYz2kKjvEm9ayHkUDbT0uQ$">https://pines.georgialibraries.org/dokuwiki/doku.php?id=acq:yearend#reports</a><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif">I'm happy to share if any of those are of interest to anyone.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif">I like your reports for encumbrances. I don't think that's really reflected in mine, now that I'm looking at it. I've focused on finding copies (line item details) that are still
encumbered, essentially, but there could be direct charge encumbrances too. A lot of times I end up doing a massive query for libraries that shows the details for all fund debits (like their associated invoices / POs / line item details / etc), but we haven't
been able to put that into a report source yet so I have to do it manually. I may snag some of your encumbrances reports as a solution in the meantime!<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif">Other templates that we have that I use a lot:<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif"> -- Items cancelled in a fiscal year using a specific cancel reason -- I created a Cancelled: FYE cancel reason, so libraries who cancel things at year end can use this report
to find them all again and reorder in the next FY<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif">-- Copies remaining after true cancels -- I've found that sometimes when you cancel using a cancel reason keep_debits=f, the copy isn't deleted. I haven't dug into when / why,
so I just did a shortcut and created a report to find them. :)<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif">-- Checking Bib Matches on Line Items -- This displays the title on the line item to the title on the bib that it linked to so you can compare them. It's definitely *not* an
exact science, but when I was evaluating the efficacy of our matchset I was able to get a rough idea if it was making bad matches and / or how often it was matching to an existing record vs. creating an Acquisitions record.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif">-- Abandoned ACQ copies -- This finds copies where they've been received, but they were never converted to a "real" barcode. (We use autogenerated Acq barcodes that are supposed
to be replaced with real ones.) So if it's been received but was never cataloged, something is up.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif">-- Pending purchase order older than X days -- Since the fix for deleting bibs underneath line items is now in 3.4+ (<a href="https://urldefense.com/v3/__https:/bugs.launchpad.net/evergreen/*bug/1634244__;Kw!!HYmSToo!MqwMue0Kq1Vfp0uCEZ5YWCgSNwPw6jRCgd9JpwWAF-ik1p7kuYz2kKjvEm9ayHncf9ceaQ$">https://bugs.launchpad.net/evergreen/+bug/1634244</a>),
if you have pending purchase orders linked to bib records, but you're just letting the PO sit there without ordering, you're sort of letting those bibs hang around in the catalog when they might normally get deleted. (Assuming that you're using that library
setting.) So I have this report autorun to find any PO's older than 45 days--if you haven't ordered it by then, I'm guessing you might not want it. I usually reach out to the library and they usually don't want the PO's so they delete the line items and that
frees up the bibs. I don't know if that explanation made any sense, but I definitely use this one regularly.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif">And looking through my folders has reminded me once again I really should clean those out. Lots of report templates that include the word "Test v.14" in there. :D<o:p></o:p></span></p>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse">
<tbody>
<tr style="height:123.0pt">
<td valign="top" style="padding:5.0pt 5.0pt 5.0pt 5.0pt;height:123.0pt">
<p style="margin:0in;margin-bottom:.0001pt"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:black;border:solid windowtext 1.0pt;padding:0in"><img border="0" width="76" height="76" style="width:.7916in;height:.7916in" id="Picture_x0020_1" src="cid:~WRD0000.jpg" alt="Image removed by sender."></span><o:p></o:p></p>
</td>
<td valign="top" style="padding:5.0pt 5.0pt 5.0pt 5.0pt;height:123.0pt">
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:9.0pt;margin-bottom:.0001pt">
<b><span style="font-family:"Tahoma",sans-serif;color:#1E439B">Tiffany Little, PINES Services Specialist: Acquisitions</span></b><o:p></o:p></p>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="100%" align="center">
</div>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:9.0pt;margin-bottom:.0001pt">
<b><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:#1E439B">Georgia Public Library Service | University System of Georgia</span></b><o:p></o:p></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:9.0pt;margin-bottom:.0001pt">
<span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:#1E439B">2872 Woodcock Blvd, Suite 250 l Atlanta, GA 30341</span><o:p></o:p></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:9.0pt;margin-bottom:.0001pt">
<span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:#1E439B">(470) 512-1454 |
<a href="mailto:tlittle@georgialibraries.org" target="_blank">tlittle@georgialibraries.org</a> |
<a href="mailto:help@help.georgialibraries.org" target="_blank">help@help.georgialibraries.org</a></span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:9.0pt;margin-bottom:.0001pt">
<a href="https://urldefense.com/v3/__https:/www.facebook.com/georgialibraries__;!!HYmSToo!MqwMue0Kq1Vfp0uCEZ5YWCgSNwPw6jRCgd9JpwWAF-ik1p7kuYz2kKjvEm9ayHn1Mvj5vA$" target="_blank"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:#1155CC;border:solid windowtext 1.0pt;padding:0in;text-decoration:none"><img border="0" width="36" height="36" style="width:.375in;height:.375in" id="Picture_x0020_3" src="cid:~WRD0000.jpg" alt="Image removed by sender."></span></a><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:black"> </span><a href="https://urldefense.com/v3/__https:/www.twitter.com/georgialibs__;!!HYmSToo!MqwMue0Kq1Vfp0uCEZ5YWCgSNwPw6jRCgd9JpwWAF-ik1p7kuYz2kKjvEm9ayHlMtq4fmA$" target="_blank"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:#1155CC;border:solid windowtext 1.0pt;padding:0in;text-decoration:none"><img border="0" width="35" height="35" style="width:.3666in;height:.3666in" id="Picture_x0020_4" src="cid:~WRD0000.jpg" alt="Image removed by sender."></span></a><o:p></o:p></p>
</td>
</tr>
<tr style="height:21.0pt">
<td colspan="2" valign="top" style="padding:5.0pt 5.0pt 5.0pt 5.0pt;height:21.0pt">
<p align="center" style="margin:0in;margin-bottom:.0001pt;text-align:center"><span style="font-size:7.5pt"><a href="https://urldefense.com/v3/__http:/georgialibraries.org__;!!HYmSToo!MqwMue0Kq1Vfp0uCEZ5YWCgSNwPw6jRCgd9JpwWAF-ik1p7kuYz2kKjvEm9ayHl1hM0Ygg$" target="_blank"><i><span style="font-family:"Verdana",sans-serif;color:#1155CC">Join
our email list</span></i></a></span><i><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:black">
</span></i><i><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:#434343">for stories of Georgia libraries making an impact in our communities.</span></i><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Tue, Aug 11, 2020 at 4:31 PM Durrence, April <<a href="mailto:april.durrence@ncdcr.gov">april.durrence@ncdcr.gov</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif">Hi everyone,</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif">As we often have an uptick in help tickets around year-end closeout, I want to make our list of pre-built report templates for acq
more robust. </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif">I am particularly interested in these Sitka reports:
</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif">Line items received but not invoiced</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif">Line items invoice but not received</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif">Line Items with the Status of On-order</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif">Fund Report by Year (may be similar to our Funds List template, but may have additional info we should include)</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif">Claim Ready Items</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif">And the report to identify deleted bibs in PO that causes activation to fail that Tiffany Little created and mentioned in this bug:
</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif"><a href="https://urldefense.com/v3/__https:/bugs.launchpad.net/evergreen/*bug/1814793__;Kw!!HYmSToo!MqwMue0Kq1Vfp0uCEZ5YWCgSNwPw6jRCgd9JpwWAF-ik1p7kuYz2kKjvEm9ayHmglE23dQ$" target="_blank">https://bugs.launchpad.net/evergreen/+bug/1814793</a></span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif">If you have other templates that you find useful and wouldn’t mind sharing, I would appreciate it!
</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif">If you can provide screenshots or some other means of letting me know your Source, Display fields (with Source Path, Column Label,
Data Type, Field Transform) and Filter Fields (with Source Path, Name, Column, Data Type, Operator, Field Transform, and Filter value, if any) I should be able to replicate the report.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif">We currently have these report templates:</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif"> </span><o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="912" style="width:683.7pt;border-collapse:collapse">
<thead>
<tr>
<td style="border:solid gray 1.0pt;background:#F0F0F0;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<b><span style="font-size:9.0pt;color:black">name</span></b><o:p></o:p></p>
</td>
<td width="705" style="width:528.65pt;border:solid gray 1.0pt;border-left:none;background:#F0F0F0;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<b><span style="font-size:9.0pt;color:black">description</span></b><o:p></o:p></p>
</td>
</tr>
</thead>
<tbody>
<tr id="gmail-m_-3432803492874440176fm_table_11">
<td style="border:solid #E0E0E0 1.0pt;border-top:none;padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<span style="font-size:9.0pt">Amount Encumbered and Amount spent for any selected active fund</span><o:p></o:p></p>
</td>
<td width="705" style="width:528.65pt;border-top:none;border-left:none;border-bottom:solid #E0E0E0 1.0pt;border-right:solid #E0E0E0 1.0pt;padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<span style="font-size:9.0pt">Display PO Name, Provider Name, PO Creation Date, Amount Encumbered, and Amount Spent. Filters on Ordering Agency, Name of fund, and fund is active(=true)</span><o:p></o:p></p>
</td>
</tr>
<tr id="gmail-m_-3432803492874440176fm_table_12">
<td style="border:solid #E0E0E0 1.0pt;border-top:none;padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<span style="font-size:9.0pt">Fund Summary FYxx</span><o:p></o:p></p>
</td>
<td width="705" style="width:528.65pt;border-top:none;border-left:none;border-bottom:solid #E0E0E0 1.0pt;border-right:solid #E0E0E0 1.0pt;padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<span style="font-size:9.0pt">Provides monetary details of expenditures for acquisitions. Includes encumbrances, balance, allocations, fund tag, account name. Must include year of fund summary and OU code of libraries needing report.</span><o:p></o:p></p>
</td>
</tr>
<tr id="gmail-m_-3432803492874440176fm_table_13">
<td style="border:solid #E0E0E0 1.0pt;border-top:none;padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<span style="font-size:9.0pt">Funds list</span><o:p></o:p></p>
</td>
<td width="705" style="width:528.65pt;border-top:none;border-left:none;border-bottom:solid #E0E0E0 1.0pt;border-right:solid #E0E0E0 1.0pt;padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<span style="font-size:9.0pt">Lists all fund names and codes for selected year</span><o:p></o:p></p>
</td>
</tr>
<tr id="gmail-m_-3432803492874440176fm_table_14">
<td style="border:solid #E0E0E0 1.0pt;border-top:none;padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<span style="font-size:9.0pt">List POs created between selected dates</span><o:p></o:p></p>
</td>
<td width="705" style="width:528.65pt;border-top:none;border-left:none;border-bottom:solid #E0E0E0 1.0pt;border-right:solid #E0E0E0 1.0pt;padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<span style="font-size:9.0pt">Displays PO id, ordering agency create time, PO creator, edit time, PO editor, order date, PO state, cancel cause, and cancel description. Filters on ordering library and selected create date range.</span><o:p></o:p></p>
</td>
</tr>
<tr id="gmail-m_-3432803492874440176fm_table_15">
<td style="border:solid #E0E0E0 1.0pt;border-top:none;padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<span style="font-size:9.0pt">Outstanding encumbrances</span><o:p></o:p></p>
</td>
<td width="705" style="width:528.65pt;border-top:none;border-left:none;border-bottom:solid #E0E0E0 1.0pt;border-right:solid #E0E0E0 1.0pt;padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<span style="font-size:9.0pt">Lists all encumbrances (not direct charges), Includes Provider, PO number, Title ordered</span><o:p></o:p></p>
</td>
</tr>
<tr id="gmail-m_-3432803492874440176fm_table_16">
<td style="border:solid #E0E0E0 1.0pt;border-top:none;padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<span style="font-size:9.0pt">Outstanding encumbrances filter by Fund Code</span><o:p></o:p></p>
</td>
<td width="705" style="width:528.65pt;border-top:none;border-left:none;border-bottom:solid #E0E0E0 1.0pt;border-right:solid #E0E0E0 1.0pt;padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<span style="font-size:9.0pt">Lists outstanding encumbrances (not direct charges), Includes Provider, PO #, Title ordered. Allows you to filter for a specific Fund code name.</span><o:p></o:p></p>
</td>
</tr>
<tr id="gmail-m_-3432803492874440176fm_table_17">
<td style="border:solid #E0E0E0 1.0pt;border-top:none;padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<span style="font-size:9.0pt">POs that have been cancelled and reasoning</span><o:p></o:p></p>
</td>
<td width="705" style="width:528.65pt;border-top:none;border-left:none;border-bottom:solid #E0E0E0 1.0pt;border-right:solid #E0E0E0 1.0pt;padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<span style="font-size:9.0pt">History of cancelled POs.</span><o:p></o:p></p>
</td>
</tr>
<tr id="gmail-m_-3432803492874440176fm_table_18">
<td style="border:solid #E0E0E0 1.0pt;border-top:none;padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<span style="font-size:9.0pt">Purchase Order History</span><o:p></o:p></p>
</td>
<td width="705" style="width:528.65pt;border-top:none;border-left:none;border-bottom:solid #E0E0E0 1.0pt;border-right:solid #E0E0E0 1.0pt;padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<span style="font-size:9.0pt">History of PO for library system.</span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif">If anyone would like the setup info for our templates, I would be glad to share.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif">Thanks!</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif">April</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-family:"Tahoma",sans-serif">April Durrence</span></b><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif">NC Cardinal Training Specialist</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif">State Library of North Carolina</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif">919.814.6794 |
<a href="mailto:april.durrence@ncdcr.gov" target="_blank">april.durrence@ncdcr.gov</a></span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black">NC Dept. of Natural and Cultural Resources</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black">109 East Jones Street | 4640 Mail Service Center
</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black">Raleigh, North Carolina 27699-4600</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-top:6.0pt;mso-margin-bottom-alt:auto"><a href="https://urldefense.com/v3/__https:/www.facebook.com/StateLibraryNC/__;!!HYmSToo!MqwMue0Kq1Vfp0uCEZ5YWCgSNwPw6jRCgd9JpwWAF-ik1p7kuYz2kKjvEm9ayHmfqNheaQ$" target="_blank"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Facebook</span></a><span style="font-size:10.0pt;font-family:"Arial",sans-serif">
</span><a href="https://urldefense.com/v3/__https:/twitter.com/StateLibraryNC__;!!HYmSToo!MqwMue0Kq1Vfp0uCEZ5YWCgSNwPw6jRCgd9JpwWAF-ik1p7kuYz2kKjvEm9ayHlQWCbv3Q$" target="_blank"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Twitter</span></a><span style="font-size:10.0pt;font-family:"Arial",sans-serif">
</span><a href="https://urldefense.com/v3/__http:/www.instagram.com/ncculture__;!!HYmSToo!MqwMue0Kq1Vfp0uCEZ5YWCgSNwPw6jRCgd9JpwWAF-ik1p7kuYz2kKjvEm9ayHk_W3h-uQ$" target="_blank"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Instagram</span></a><span style="font-size:10.0pt;font-family:"Arial",sans-serif">
</span><a href="https://urldefense.com/v3/__https:/www.youtube.com/user/statelibrarync/__;!!HYmSToo!MqwMue0Kq1Vfp0uCEZ5YWCgSNwPw6jRCgd9JpwWAF-ik1p7kuYz2kKjvEm9ayHlW1cPsHA$" target="_blank"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">YouTube</span></a><span style="font-size:10.0pt;font-family:"Arial",sans-serif">
</span><a href="https://statelibrary.ncdcr.gov/" target="_blank"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Website</span></a><span style="font-size:10.0pt;font-family:"Arial",sans-serif">
</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-top:6.0pt;mso-margin-bottom-alt:auto"><a href="https://statelibrary.ncdcr.gov/" target="_blank"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:windowtext;text-decoration:none"><img border="0" width="327" height="102" style="width:3.4083in;height:1.0583in" id="gmail-m_-3432803492874440176Picture_x0020_1" src="cid:image001.jpg@01D6708D.2DC23410" alt="A close up of a logo
Description automatically generated"></span></a><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><i><span style="font-size:10.0pt;color:#7F7F7F">Email correspondence to and from this address is subject to the North Carolina Public Records Law and may be disclosed to third parties.</span></i><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"><span style="font-size:10.0pt;font-family:"Gotham Medium";color:black">#StayStrongNC<br>
Learn more @ <a href="http://nc.gov/covid19" target="_blank">nc.gov/covid19</a> </span>
<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;font-family:"Gotham Medium";color:black">And don’t forget your Ws! Wear. Wait. Wash.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><u><span style="font-size:10.0pt;font-family:"Gotham Medium";color:black">WEAR</span></u><span style="font-size:10.0pt;font-family:"Gotham Medium";color:black"> a face covering.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><u><span style="font-size:10.0pt;font-family:"Gotham Medium";color:black">WAIT</span></u><span style="font-size:10.0pt;font-family:"Gotham Medium";color:black"> 6 feet apart from
other people. </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><u><span style="font-size:10.0pt;font-family:"Gotham Medium";color:black">WASH</span></u><span style="font-size:10.0pt;font-family:"Gotham Medium";color:black"> your hands often.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
Evergreen-acq mailing list<br>
<a href="mailto:Evergreen-acq@list.evergreen-ils.org" target="_blank">Evergreen-acq@list.evergreen-ils.org</a><br>
<a href="https://urldefense.com/v3/__http:/list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-acq__;!!HYmSToo!MqwMue0Kq1Vfp0uCEZ5YWCgSNwPw6jRCgd9JpwWAF-ik1p7kuYz2kKjvEm9ayHnNnDiOcw$" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-acq</a><o:p></o:p></p>
</blockquote>
</div>
</div>
</div>
</body>
</html>