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

[Mike Rylander]

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


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
> http://www.andersonlibrary.org
>   ****
>
> ** **
>
> *From:* open-ils-general-bounces at list.georgialibraries.org [
> mailto:open-ils-general-bounces at list.georgialibraries.org<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/203ee8a7/attachment-0001.htm>