2018-05-30 12:37:38 |
Robert J Jackson |
description |
Web Client 3.x
While performing cleanup for exceptions (negative balanced bills on closed transactions) I attempted to add the book keeping correction to two bills found using the web client. The bills do not show in the web client if a finish date is associated with the circulation. Under the legacy staff client they are present. I am showing the two screen shots of same billing from the web and legacy for review. Also below is the sql used to find the errant bills:
select ac.barcode, mmbxs.* FROM money.materialized_billable_xact_summary mmbxs JOIN actor.usr au ON (au.id = mmbxs.usr) JOIN actor.card ac ON (au.id = ac.usr and ac.active = 't') WHERE xact_finish IS NOT NULL AND balance_owed <> 0 AND au.home_ou IN (SELECT id FROM actor.org_unit_descendants(1)); |
Web Client 3.0.7
While performing cleanup for exceptions (negative balanced bills on closed transactions) I attempted to add the book keeping correction to two bills found using the web client. The bills do not show in the web client if a finish date is associated with the circulation. Under the legacy staff client they are present. I am showing the two screen shots of same billing from the web and legacy for review. Also below is the sql used to find the errant bills:
select ac.barcode, mmbxs.* FROM money.materialized_billable_xact_summary mmbxs JOIN actor.usr au ON (au.id = mmbxs.usr) JOIN actor.card ac ON (au.id = ac.usr and ac.active = 't') WHERE xact_finish IS NOT NULL AND balance_owed <> 0 AND au.home_ou IN (SELECT id FROM actor.org_unit_descendants(1)); |
|