<div dir="ltr"><div>Hi Sheryl,</div><div><br></div><div>I haven't actually created a report for waived fines, but wonder if you could use the "Payments" source as your starting point? This would allow you to get the payment date range and the amount. Depending upon how your library categorizes waived fines, you could use payment type as a filter (e.g. payment type = forgive_payment).</div><div><br></div><div>I think you can link through to the copy table as follows to get relevant item data (e.g. circ_modifier):</div><div><br></div><div>Payments -> Billable Transaction -> Circulation Billing link -> Circulating Item -> Circulation Modifier<br></div><div><br></div><div>Sorry I don't have a working report to share.</div><div>Beth</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, May 5, 2022 at 11:23 AM Angie Devers via Evergreen-reports <<a href="mailto:evergreen-reports@list.evergreen-ils.org">evergreen-reports@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">
<div id="gmail-m_8225551610848902114divtagdefaultwrapper" style="font-size:12pt;color:rgb(0,0,0);font-family:Verdana,Geneva,sans-serif" dir="ltr">
<div id="gmail-m_8225551610848902114divtagdefaultwrapper" dir="ltr" style="font-size:12pt;color:rgb(0,0,0);font-family:Verdana,Geneva,sans-serif,EmojiFont,"Apple Color Emoji","Segoe UI Emoji",NotoColorEmoji,"Segoe UI Symbol","Android Emoji",EmojiSymbols">
<p>Hi Sheryl,</p>
<p> when we went fine free last summer I used 3 templates "Paid Fines by location with notes" "Outstanding fines and bills with patron barcodes" and "list patrons with fines owed" - looking back none of these capture the fines that we waived during this time.
I'll keep fiddling to see if I can grab the "forgive function" as a payment type or transaction. We were more focused on the patrons than the items but did use the "Amnesty - Forgive Payment" with mixed results.</p>
<p><br>
</p>
<div id="gmail-m_8225551610848902114Signature">
<div id="gmail-m_8225551610848902114divtagdefaultwrapper" dir="ltr">
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="color:rgb(0,0,0);font-family:Tahoma;font-size:13px;margin-bottom:0.0001pt">
</p>
<div>
<p class="MsoNormal" style="margin-bottom:0.0001pt;font-family:Tahoma;font-size:13px">
<span style="color:rgb(0,111,201);font-family:"Century Gothic",sans-serif;font-size:16px">thanks as always, </span><br>
</p>
</div>
<div><span style="background-color:rgb(255,255,255);color:rgb(0,111,201)"></span>
<p class="MsoNormal" style="margin-bottom:0.0001pt;font-family:Verdana,Geneva,sans-serif;font-size:16px">
<span style="background-color:rgb(255,255,255);color:rgb(0,111,201)"></span><font color="#d05c12" face="Century Gothic, sans-serif"><span style="color:rgb(0,111,201);background-color:rgb(255,255,255)"> angie devers</span></font></p>
<span style="background-color:rgb(255,255,255);color:rgb(0,111,201)"></span>
<p class="MsoNormal" style="margin-bottom:0.0001pt;font-family:Verdana,Geneva,sans-serif;font-size:16px">
<span style="background-color:rgb(255,255,255);color:rgb(0,111,201)"></span><font color="#d05c12" face="Century Gothic, sans-serif"><span style="color:rgb(0,111,201);background-color:rgb(255,255,255)">Emmaus Public Library Services Manager</span></font></p>
<p class="MsoNormal" style="margin-bottom:0.0001pt;font-family:Verdana,Geneva,sans-serif;font-size:16px">
<font color="#d05c12" face="Century Gothic, sans-serif"><span style="color:rgb(114,50,173);background-color:rgb(0,0,255)"><span style="background-color:rgb(255,255,255);color:rgb(0,111,201)">always open online- <a href="http://www.emmauspl.org" id="gmail-m_8225551610848902114LPNoLP" target="_blank"><span style="color:rgb(75,165,36)">www.emmauspl.org</span></a></span><span style="background-color:rgb(255,255,255);color:rgb(0,111,201)"></span></span></font></p>
</div>
<p></p>
<p style="color:rgb(0,0,0);font-family:Tahoma;font-size:13px"></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<hr style="display:inline-block;width:98%">
<div id="gmail-m_8225551610848902114divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Evergreen-reports <<a href="mailto:evergreen-reports-bounces@list.evergreen-ils.org" target="_blank">evergreen-reports-bounces@list.evergreen-ils.org</a>> on behalf of Sheryl Davis via Evergreen-reports <<a href="mailto:evergreen-reports@list.evergreen-ils.org" target="_blank">evergreen-reports@list.evergreen-ils.org</a>><br>
<b>Sent:</b> Tuesday, May 3, 2022 5:58:44 PM<br>
<b>To:</b> <a href="mailto:evergreen-reports@list.evergreen-ils.org" target="_blank">evergreen-reports@list.evergreen-ils.org</a><br>
<b>Cc:</b> Sheryl Davis<br>
<b>Subject:</b> [Evergreen-reports] Waived fines</font>
<div> </div>
</div>
<div>
<div dir="ltr">Hello
<div><br>
</div>
<div>I'm trying to create a report for our waived fines that will tell us circ modifier, dates, and sum. Has anyone ever done this? Would you be willing to share it? I've tried to create a report from scratch but can never get all of the details I need. </div>
<div><br>
</div>
<div>Thank you,</div>
<div>Sheryl<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr">
<div dir="ltr">Sheryl Davis
<div>Library Technician</div>
<div>Thorold Public Library </div>
<div>14 Ormond St.</div>
<div>Thorold Ontario</div>
<div>L2V 1Y8</div>
<div>905-227-2581</div>
<div><span></span><span></span><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<br>
Evergreen-reports mailing list<br>
<a href="mailto:Evergreen-reports@list.evergreen-ils.org" target="_blank">Evergreen-reports@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr">Beth Willis
<br>Digital & Catalog Librarian
<br>NOBLE, Inc.
<br>42 Cherry Hill Drive
<br>Danvers, MA 01923 </div></div></div></div>