Thanks so much, Lynn! This template looks like it has almost exactly what they want. One question/problem, though...I set up the template exactly as yours, then I took out a couple things the library didn't want, like staff login and bill #, and tried changing Library to Workstation (Payments: Desk->Cash Drawer->Workstation Name). No matter what I did, for the same sample period the Amounts always added up to the same number (good, right?!)--which was 71.90 less than what shows up in the Local Admin-Cash Reports for the same sample period.
Do yours always match? Is it possible the Local Admin-Cash Reports is incorrect? From where in the database does that draw? Thanks! Debbie Debbie Luchenbill Missouri Evergreen Coordinator MOBIUS 111 E. Broadway, Ste. 220 Columbia, MO 65203 [email protected] 573-234-4914/877-366-2487 http://libraries.missourievergreen.org http://mobiusconsortium.org On Tue, Apr 30, 2013 at 4:08 PM, Lynn Floyd <[email protected]>wrote: > I left of where I got the Bill number from its: > Payments: Desk->Billable Transaction->Transaction ID**** > > ** ** > > I have it set to limit by **** > > Payments: Desk->Payment Date/Time – Set as between**** > > Payments: Desk-> Cash Drawer->Owing Library->Org Unit Id – set as in List* > *** > > ** ** > > ** ** > > Lynn Floyd > [email protected] > Anderson County Library > 864-260-4500 x181 > http://www.andersonlibrary.org > **** > > ** ** > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Schooff, > Rose (LVA) > *Sent:* Tuesday, April 30, 2013 3:34 PM > > *To:* Evergreen Discussion Group > *Cc:* Jennifer Bielewski ([email protected]) > *Subject:* Re: [OPEN-ILS-GENERAL] Report question: Need detailed cash > report by workstation or org unit**** > > ** ** > > I’ll give this a try and it looks like exactly what I need. Thanks so > much.**** > > ** ** > > *From:* [email protected] [ > mailto:[email protected]<[email protected]>] > *On Behalf Of *Lynn Floyd > *Sent:* Tuesday, April 30, 2013 2:01 PM > *To:* 'Evergreen Discussion Group' > *Subject:* Re: [OPEN-ILS-GENERAL] Report question: Need detailed cash > report by workstation or org unit**** > > ** ** > > This is what I have the report give me:**** > > Payments: Desk-> Cash Drawer->Owing Library-> Short (Policy) Name – This > gives me the library**** > > Payments: Desk->Accepting User->Current Library Card->Barcode – This gives > me the staff login**** > > Payments: Desk->Payment Date/Time – the date and time of the bill**** > > Payments: Desk->Billable Transaction->Billing Line items->Type – the > Billing Type**** > > Payments: Desk->Billable Transaction->User->Current Library card->barcode > – Patron Account**** > > Payments: Desk->Payment Type – Type of Payment**** > > Payments: Desk->Amount – Amount of the bill that was paid**** > > ** ** > > Here is an example of the output**** > > Library Staff Payment Date/Time > Patron Barcode Payment Type Billing > Type Bill # Amount* > *** > > ACL-BEL belcirc 2013-04-22 15:12:05.215201-04 > 1383735065441 cash_payment Overdue > materials 14654071 0.50**** > > ACL-BEL belcirc 2013-04-22 15:12:05.215201-04 > 1383735065441 cash_payment Overdue > materials 14813572 2.60**** > > ACL-BEL belcirc 2013-04-22 15:55:41.966112-04 > 1385898335634 cash_payment Overdue > materials 8513976 0.60**** > > ACL-BEL belcirc 2013-04-22 15:55:41.966112-04 > 1385898335634 cash_payment Overdue > materials 8785075 0.50**** > > ACL-BEL belcirc 2013-04-22 15:55:41.966112-04 > 1385898335634 cash_payment Overdue > materials 8785090 0.60**** > > ACL-BEL belcirc 2013-04-22 15:55:41.966112-04 > 1385898335634 cash_payment Overdue > materials 8785094 0.50**** > > ACL-BEL belcirc 2013-04-22 15:55:41.966112-04 > 1385898335634 cash_payment Overdue > materials 8785098 0.50**** > > ** ** > > Here is what shows up in the patron 1385898335634’s payment history:**** > > Amount Payment ID Payment Date/Time Payment > Type Billable Transaction Last Billing Type Title > **** > > .50 2114831 04-22-2013 3:55 cash_payment > 8785094 Overdue materials Twisted > journeys #4 The treasure of Mount Fate**** > > .50 2114830 04-22-2013 3:55 cash_payment > 8785098 Overdue materials The > Goblin King**** > > .50 2114829 04-22-2013 3:55 cash_payment > 8785075 Overdue materials The > complete Tom Sawyer**** > > .60 2114835 04-22-2013 3:55 cash_payment > 8785090 Overdue materials Annie's > promise**** > > .60 2114827 04-22-2013 3:55 cash_payment > 8513976 Overdue materials Hoot**** > > ** ** > > So in this example patron 1385898335634 paid $2.70 on 4/22/13 at 3:55 pm** > ** > > ** ** > > Hope this helps**** > > ** ** > > ** ** > > Lynn Floyd > [email protected] > Anderson County Library > 864-260-4500 x181 > http://www.andersonlibrary.org > **** > > ** ** > > *From:* [email protected] [ > mailto:[email protected]<[email protected]>] > *On Behalf Of *Schooff, Rose (LVA) > *Sent:* Monday, April 29, 2013 4:20 PM > *To:* Evergreen Discussion Group > *Cc:* Jennifer Bielewski ([email protected]) > *Subject:* Re: [OPEN-ILS-GENERAL] Report question: Need detailed cash > report by workstation or org unit**** > > ** ** > > But could you break down the overdue fines ie. If the $5.00 represented 2 > X 2.50**** > > ** ** > > What throws me off is that if you go to the patrons billing history you > can see each item listed exactly like I want – so something creates that > screen so the data is there – just not “gettable attable” in a report?**** > > ** ** > > *From:* [email protected] [ > mailto:[email protected]<[email protected]>] > *On Behalf Of *Mike Rylander > *Sent:* Monday, April 29, 2013 3:21 PM > *To:* Evergreen Discussion Group > *Cc:* Jennifer Bielewski ([email protected]) > *Subject:* Re: [OPEN-ILS-GENERAL] Report question: Need detailed cash > report by workstation or org unit**** > > ** ** > > Rose, all,**** > > ** ** > > Evergreen records a single entry for each payment. So imagine there are > $5.00 in overdue fines and $3.00 in processing fees on one circulation. If > the user pays $8.00 all at once, there's one payment covering all billing > line items, and there's no breakdown showing that three of the dollars went > to processing fees.**** > > ** ** > > I did some work (which has surely suffered from bit rot) back in the 1.2 > days to provide such a breakdown in a reporting source, but that did not > make it into the core code back then. The upshot of that is that it's > possible to do, but would take some effort to teach modern Evergreen that > trick.**** > > ** ** > > I'll put up a launchpad bug and attach the code I have. Given time or > sponsorship, hopefully that could make it into a future release.**** > > ** ** > > -- > Mike Rylander > | Director of Research and Development > | Equinox Software, Inc. / Your Library's Guide to Open Source > | phone: 1-877-OPEN-ILS (673-6457) > | email: [email protected] > | web: http://www.esilibrary.com**** > > On Mon, Apr 29, 2013 at 2:05 PM, Schooff, Rose (LVA) < > [email protected]> wrote:**** > > 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] > Anderson County Library > 864-260-4500 x181 > http://www.andersonlibrary.org > **** > > **** > > *From:* [email protected] [ > mailto:[email protected]<[email protected]>] > *On Behalf Of *Deborah Luchenbill > *Sent:* Friday, April 26, 2013 1:53 PM > *To:* [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]**** > > 573-234-4914/877-366-2487**** > > http://libraries.missourievergreen.org**** > > http://mobiusconsortium.org**** > > > > **** > > ** ** >
