<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi Elizabeth, because of the layout of the various tables related to billing (complex) and the design goals of simple reporter (simple) there wasn't a good way to pull some things without potentially duplicating rows. I don't have the precise details handy anymore but since you can potentially make partial payments at multiple locations on the same transaction some fields were intentionally left out to prevent potentially misleading data (situations like billing amounts * # of payments and payment amounts * number of billings, etc.)<div class="">Simple reporter tries to gather all payment and billing data for a single transaction into a single row to minimize confusion around dollar amounts. It may be possible to add a field that aggregates all payment locations similar to the bib subjects field in other reports, but if the goal is something like "how much was paid at library X vs library Y?" that's not something simple reporter is capable of. (Nor, really, is the complicated reporter; depending on your requirements.)<div class=""><div class="">
<meta charset="UTF-8" class=""><div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div><br class=""></div><div>Jason</div><div><br class="">-- <br class="">Jason Boyer<br class="">Senior System Administrator<br class="">Equinox Open Library Initiative<br class=""><a href="mailto:JBoyer@equinoxOLI.org" class="">JBoyer@equinoxOLI.org</a><br class="">+1 (877) Open-ILS (673-6457)<br class="">https://equinoxOLI.org/</div></div></div></div>
</div>
<div><br class=""><blockquote type="cite" class=""><div class="">On Oct 25, 2022, at 9:58 AM, Elizabeth Davis via Evergreen-reports <<a href="mailto:evergreen-reports@list.evergreen-ils.org" class="">evergreen-reports@list.evergreen-ils.org</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><meta charset="UTF-8" class=""><div class="WordSection1" style="page: WordSection1; caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;" class="">Hello<o:p class=""></o:p></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;" class="">I’m trying to build a Simple Report using the Billings and Payments Transaction Summary. Is there no Payment Location field? I’m seeing the Billing Library as field, but nothing for payment.<o:p class=""></o:p></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif; vertical-align: baseline;" class=""><span id="cid:image002.png@01D8E858.5B9C0FB0"><image002.png></span><b class=""><span style="color: rgb(22, 105, 122);" class="">Elizabeth Davis</span></b><b class=""><span class="Apple-converted-space"> </span></b>(she/her),<span class="Apple-converted-space"> </span><b class=""><i class=""><span style="color: rgb(22, 105, 122);" class="">Support & Project Management Specialist</span></i></b><span style="font-size: 12pt; color: rgb(22, 105, 122);" class=""> </span><span style="font-size: 9pt; font-family: "Segoe UI", sans-serif;" class=""><o:p class=""></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif; vertical-align: baseline;" class=""><b class=""><span style="font-size: 12pt; color: rgb(51, 102, 204);" class="">Pennsylvania Integrated Library System<span class="Apple-converted-space"> </span></span></b><b class=""><span style="color: rgb(68, 114, 196);" class="">(PaILS) | SPARK</span></b><span style="font-size: 12pt; color: rgb(51, 102, 204);" class=""> </span><span style="font-size: 9pt; font-family: "Segoe UI", sans-serif;" class=""><o:p class=""></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif; vertical-align: baseline;" class=""><span style="color: rgb(51, 102, 204);" class="">(717) 256-1627</span><span class="Apple-converted-space"> </span>|<span class="Apple-converted-space"> </span><a href="mailto:katherine.dannehl@sparkpa.org" target="_blank" style="color: rgb(5, 99, 193); text-decoration: underline;" class=""><span style="color: rgb(5, 99, 193);" class="">elizabeth.davis@sparkpa.org</span></a> <br class=""><a href="https://support.sparkpa.org/" target="_blank" style="color: rgb(5, 99, 193); text-decoration: underline;" class=""><span style="color: rgb(5, 99, 193);" class="">support.sparkpa.org</span></a><span style="color: rgb(51, 102, 204);" class=""><span class="Apple-converted-space"> </span>|<span class="Apple-converted-space"> </span></span><a href="mailto:support@sparkpa.org" target="_blank" style="color: rgb(5, 99, 193); text-decoration: underline;" class=""><span style="color: rgb(5, 99, 193);" class="">support@sparkpa.org</span></a><span style="color: rgb(51, 102, 204);" class=""> </span><span style="font-size: 9pt; font-family: "Segoe UI", sans-serif;" class=""><o:p class=""></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div></div><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">_______________________________________________</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">Evergreen-reports mailing list</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><a href="mailto:Evergreen-reports@list.evergreen-ils.org" style="color: rgb(5, 99, 193); text-decoration: underline; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">Evergreen-reports@list.evergreen-ils.org</a><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports" style="color: rgb(5, 99, 193); text-decoration: underline; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports</a></div></blockquote></div><br class=""></div></div></body></html>