[OPEN-ILS-GENERAL] Fines conundrum

[Josh Stompro]

John, do you mean that the summary balance under the bills tab shows nothing?



[cid:image001.png at 01D24C8F.F0680970]



I’ve seen this happen when I’ve changed values in the money.payments table instead of the table the corresponds with the payment type.  There are materialized views (a summary table that is kept in sync with triggers instead of pulling live data) that can get out of sync with reality.  It could be that the triggers that keep the summary tables up to date have been broken.  I think you need someone to take a look at the money.* tables and triggers to make sure they match up with your releases setting.



The summary tables can be re-created from the systems current state to get the values back in line.



You can check on this by choosing a patron that shows the symptoms, and looking at a few tables for that patron.  You need sql access for this.

·         money.usr_summary should show that users balance totals.

·         Money.billable_xact_summary should show a summary for each bill for that customer.  If they should have a fine, but it shows a zero balance for that bill, then the money.billable_xact_summary is out of sync.

·         Money.billings for the same bill should show the fine.





Josh Stompro - LARL IT Director





-----Original Message-----
From: Open-ils-general [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of John Clark
Sent: Friday, December 02, 2016 9:03 AM
To: Evergreen Discussion Group
Subject: [OPEN-ILS-GENERAL] Fines conundrum



Hi folks,





At least two of our member libraries in the Maine Balsam Consortium are perplexed and vexed. I've copied their problem below in hopes someone in the Evergreen world might have experienced (and solved) a similar issue.

I thank all in advance for any shared wisdom.



Regards,

John R. Clark-treasurer, Maine Balsam Library consortium





Evergreen no longer adds fines to a patron’s account.  When an item is returned and checked in it shows that a fine has accrued, but when we go to that patron’s account there is nothing under bills……But click on bills and  overdues are there!  It started at first just on movies and now its books as well. How can we get accrued fines to show?



--

Retired librarian, author, freelance editor, book reviewer

https://www.facebook.com/wizardofhartland

http://cmldbookreviews.com/


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20161202/9d356293/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 6933 bytes
Desc: image001.png
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20161202/9d356293/attachment-0001.png>