Hi Deanna, We use Source: Forgive Payment
Display fields: Forgive Payment: Payment_ts (raw data) Forgive Payment: Amount_collected (sum) Forgive Payment: Note (raw data) Forgive Payment:: accepting_usr: OPAC/Staff Client User Name (raw data) Forgive Payment::payment: Payment Type (raw data) Forgive Payment -> Payments:All -> Billable Transaction:: User: First Name (raw data) Forgive Payment -> Payments:All -> Billable Transaction:: User: Middle Name (raw data) Forgive Payment -> Payments:All -> Billable Transaction:: User: Last Name (raw data) Forgive Payment -> Payments:All -> Billable Transaction -> ILS User:: Current Library Card: Barcode (raw data) Base filters: Forgive Payment: Payment_ts (field transform: date, Operator: between) Forgive Payment:: accepting_usr: Home Library (field transform: raw data, Operator: in list) This includes patron info, which you may or may not need. You could also theoretically add the workstation, although you have to drill down through accepting_usr > User/Working Location Map > Working Location to get to it. Regards, April [cid:image001.png@01D5115E.5B5AE820]April Durrence NC Cardinal Training Specialist NC Dept. of Natural and Cultural Resources 919.814.6794 phone 919.733.8748 fax april.durre...@ncdcr.gov 109 East Jones Street | 4640 Mail Service Center | Raleigh, North Carolina 27699-4640 Facebook<http://www.facebook.com/NorthCarolinaCulture> Twitter<http://www.twitter.com/ncculture> Instagram<http://www.instagram.com/ncculture> YouTube<http://www.youtube.com/ncculture> Website<https://statelibrary.ncdcr.gov/> Email correspondence to and from this address is subject to the North Carolina Public Records Law and may be disclosed to third parties. ---------------------------------------------------------- From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Terran McCanna Sent: Thursday, May 23, 2019 11:38 AM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org> Subject: [External] Re: [OPEN-ILS-GENERAL] Reported needed for waived fines and fees CAUTION: External email. Do not click links or open attachments unless you verify. Send all suspicious email as an attachment to report.s...@nc.gov<mailto:report.s...@nc.gov> We use this one for bills that have been forgiven (also includes 'work' payments): List of bills that were forgiven by library staff, or "paid" via work in exchange for fine forgival. -------------------------------------------------------------------------------------------- Uses Payments: Non-drawer Staff source. Nullability selection enabled. Displayed Fields: Payments: Non-drawer Staff -> Amount as "Amount Forgiven" Payments: Non-drawer Staff -> (Default) Billable Transaction -> (Default) Billing Line Items -> Legacy Billing Type (Last) Payments: Non-drawer Staff -> Payment Type Payments: Non-drawer Staff -> Payment Date/Time as "Forgival Date/Time" Payments: Non-drawer Staff -> (None) Forgive Payment Detail -> (Default) accepting_usr -> (Default) Current Library Card -> Barcode as "Staff Barcode" Payments: Non-drawer Staff -> (Default) Billable Transaction -> (Default) User -> (Default) Current Library Card -> Barcode as "Patron Barcode" Base Filters: Payments: Non-drawer Staff -> (None) Forgive Payement Detail -> (Default) accepting_usr -> (Default) Home Library -> Organizational Unit ID (In list) Payments: Non-drawer Staff -> Payment Date/Time (Date) (Between) NOTE: this report necessarily uses the home library of the staff user accepting the forgive payment. This may *not* be the same as the working location of the user. [https://lh3.googleusercontent.com/1dQZFKZrN_h1nAVv7EB9VmFYBGsfiOmL3Yec9IzIlL7YztuUoci9JMwC2Fb6h1vqlBSlyslKe_N7vSMNF1FaiUIrY6tVC41zt8iLssfRtJbhdGOpDPFgvjyFXgCzNOmQaD9gEgOW] Terran McCanna, PINES Program Manager ________________________________ Georgia Public Library Service | University System of Georgia 1800 Century Place NE Suite 580 l Atlanta, GA 30345 (404) 235-7138 | tmcca...@georgialibraries.org<mailto:tmcca...@georgialibraries.org> http://help.georgialibraries.org | h...@help.georgialibraries.org<mailto:h...@help.georgialibraries.org> [https://lh6.googleusercontent.com/t7rbwMx5NBGCEplmiJgNe2sRZGRgzqVS8d9k3yg-mR-UhThtZVNUiZe419YuwVyLjZ6QZKFAeQGFYcEgO6MtVjPlCrQ5CPYc4h56OEKnldS32D8FYMvQRAmQYZH9pCsHZjVDSQpU]<https://www.facebook.com/georgialibraries> [https://lh5.googleusercontent.com/3BiTrvd-MM4iD8ytwlQc0_q928anCSry4UO21hcYQV_FPcmhq0Ov9toQ9gv4mmxQLUS2iV4cXDEPUEweGu75_jIH_WX1xDe119BcHfFCzinWfbKuK6NeTXYdO5PU2HRfXAS-Vq1R] <https://www.twitter.com/georgialibs> Join<http://georgialibraries.org> our email list<http://georgialibraries.org> for stories of Georgia libraries making an impact in our communities. On Thu, May 23, 2019 at 11:36 AM Deanna Frazee <dfra...@killeentexas.gov<mailto:dfra...@killeentexas.gov>> wrote: I need to create a report so that we can keep track of overdue fines and processing fees that have been waived by our circ staff. I have not had much luck figuring this one out on my own. Had anyone created a report so they can see which staff members are waiving patrons’ fines and fees and, preferably, the dollar amount being waived? Thanks, Deanna Frazee Killeen Public Library City of Killeen, Texas 254-501-8995 (office) 254-501-7704 (fax) dfra...@killeentexas.gov<mailto:http://dfra...@killeentexas.gov> www.killeentexas.gov<http://www.killeentexas.gov/> Dedicated Service – Every Day, for Everyone!