[Evergreen-reports] Simple Reports: Billings and Payments Transaction Summary

[Jason Boyer]

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.)
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.)

Jason

-- 
Jason Boyer
Senior System Administrator
Equinox Open Library Initiative
JBoyer at equinoxOLI.org
+1 (877) Open-ILS (673-6457)
https://equinoxOLI.org/

> On Oct 25, 2022, at 9:58 AM, Elizabeth Davis via Evergreen-reports <evergreen-reports at list.evergreen-ils.org> wrote:
> 
> Hello
>  
> 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.
>  
> <image002.png>Elizabeth Davis (she/her), Support & Project Management Specialist 
> Pennsylvania Integrated Library System (PaILS) | SPARK 
> (717) 256-1627 | elizabeth.davis at sparkpa.org <mailto:katherine.dannehl at sparkpa.org> 
> support.sparkpa.org <https://support.sparkpa.org/> | support at sparkpa.org <mailto:support at sparkpa.org> 
>  
> _______________________________________________
> Evergreen-reports mailing list
> Evergreen-reports at list.evergreen-ils.org <mailto:Evergreen-reports at list.evergreen-ils.org>
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports <http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20221025/8d059538/attachment.htm>