[OPEN-ILS-GENERAL] Report question: Need detailed cash report by workstation or org unit
Lynn Floyd
lfloyd at andersonlibrary.org
Mon May 6 11:53:12 EDT 2013
Mine do not always match. Sometimes they are way off. I know that the Cash
Reports uses Payments Desk as where it draws the information from, but how
it calculates it, I have yet been able to follow.
Lynn Floyd
lfloyd at andersonlibrary.org
Anderson County Library
864-260-4500 x181
http://www.andersonlibrary.org <http://www.andersonlibrary.org/>
From: open-ils-general-bounces at list.georgialibraries.org
[mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of
Deborah Luchenbill
Sent: Thursday, May 02, 2013 3:38 PM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Report question: Need detailed cash report
by workstation or org unit
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
deborah at mobiusconsortium.org
573-234-4914/877-366-2487
http://libraries.missourievergreen.org
http://mobiusconsortium.org
On Tue, Apr 30, 2013 at 4:08 PM, Lynn Floyd <lfloyd at andersonlibrary.org>
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
lfloyd at andersonlibrary.org
Anderson County Library
864-260-4500 x181 <tel:864-260-4500%20x181>
http://www.andersonlibrary.org <http://www.andersonlibrary.org/>
From: open-ils-general-bounces at list.georgialibraries.org
[mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of
Schooff, Rose (LVA)
Sent: Tuesday, April 30, 2013 3:34 PM
To: Evergreen Discussion Group
Cc: Jennifer Bielewski (jennifer.bielewski at lyrasis.org)
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: open-ils-general-bounces at list.georgialibraries.org
[mailto:open-ils-general-bounces at list.georgialibraries.org] 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
lfloyd at andersonlibrary.org
Anderson County Library
864-260-4500 x181 <tel:864-260-4500%20x181>
http://www.andersonlibrary.org <http://www.andersonlibrary.org/>
From: open-ils-general-bounces at list.georgialibraries.org
[mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of
Schooff, Rose (LVA)
Sent: Monday, April 29, 2013 4:20 PM
To: Evergreen Discussion Group
Cc: Jennifer Bielewski (jennifer.bielewski at lyrasis.org)
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: open-ils-general-bounces at list.georgialibraries.org
[mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of
Mike Rylander
Sent: Monday, April 29, 2013 3:21 PM
To: Evergreen Discussion Group
Cc: Jennifer Bielewski (jennifer.bielewski at lyrasis.org)
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: miker at esilibrary.com
| web: http://www.esilibrary.com <http://www.esilibrary.com/>
On Mon, Apr 29, 2013 at 2:05 PM, Schooff, Rose (LVA)
<Rose.Schooff at lva.virginia.gov> 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: open-ils-general-bounces at list.georgialibraries.org
[mailto:open-ils-general-bounces at list.georgialibraries.org] 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
lfloyd at andersonlibrary.org
Anderson County Library
864-260-4500 x181 <tel:864-260-4500%20x181>
http://www.andersonlibrary.org <http://www.andersonlibrary.org/>
From: open-ils-general-bounces at list.georgialibraries.org
[mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of
Deborah Luchenbill
Sent: Friday, April 26, 2013 1:53 PM
To: open-ils-general at list.georgialibraries.org
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
deborah at mobiusconsortium.org
573-234-4914/877-366-2487
http://libraries.missourievergreen.org
http://mobiusconsortium.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20130506/0e1fe008/attachment-0001.htm>
More information about the Open-ils-general
mailing list