Does either of your reports break down line by line what the fees paid were for? IE - Patron paid 19.60 and that consisted of 3.20 X 5, 2 X 1.80, 1 80 cent fee (or however that adds up) I can get the sum $19.60 but can't get it broken down.
From: [email protected] [mailto:[email protected]] On Behalf Of Lynn Floyd Sent: Monday, April 29, 2013 10:21 AM To: 'Evergreen Discussion Group' Subject: Re: [OPEN-ILS-GENERAL] Report question: Need detailed cash report by workstation or org unit I have a similar report that runs for us, I had the same problems trying to get the Source Payments:All to give me what I wanted. I finally switched to using Payments:Desk which allowed me to limit by workstation. I then limited it by Cash Drawer: Owing Library: Org Unit Then is Display fields, I have Cash Drawer: Owing Library: Short (Policy) Name. The only limitation I found is it does not include Forgive, work, voids, and goods payments. As I was looking for the transactions that came across our Circulation desk this limitation did not matter. Lynn Floyd [email protected]<mailto:[email protected]> Anderson County Library 864-260-4500 x181 http://www.andersonlibrary.org<http://www.andersonlibrary.org/> From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Deborah Luchenbill Sent: Friday, April 26, 2013 1:53 PM To: [email protected]<mailto:[email protected]> Subject: [OPEN-ILS-GENERAL] Report question: Need detailed cash report by workstation or org unit I'm hoping some of you report experts out there can help me with this request... One of our library systems needs a detailed cash report to send to their accountant, which contains all the transactions and what they were for by workstation or library (there are 3 branches). They noticed, in the report template we created, that the amount didn't match the summary report they got from Admin--Local Admin--Cash Reports. We discovered that it was because one of the base filters was Home Library--but it was the patron's home library, so was including the amount when they paid it at one of the other branches. What the library really needs is a filter and displayed field on either Workstation or Org Unit, so they can arrange on those, but I can't, for the life of me, figure out how to do that. Currently, the report uses Source as Payments: All. It displays Payment Date/Time, Name, Cash Amount, Check Amount, Credit Card Amount, Forgive Amount, and Barcode (patron). Base filters currently are Payment Date/Time and Home Library I tried using Billable Transactions-->User::workstation ID or workstation org unit and tried using Accepting Staff Member::workstation ID or workstation org unit, but those didn't work, either. There was no data entry field or list on the template when I tried those (probably because they're "link"?). Any help or advice would be much appreciated! Thanks, Debbie Debbie Luchenbill Missouri Evergreen Coordinator MOBIUS 111 E. Broadway, Ste. 220 Columbia, MO 65203 [email protected]<mailto:[email protected]> 573-234-4914/877-366-2487 http://libraries.missourievergreen.org http://mobiusconsortium.org
