[OPEN-ILS-GENERAL] Report question: Need detailed cash report by workstation or org unit

[Lynn Floyd]

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 
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/20130429/9d0c5e49/attachment.htm>