Negative Balanced Bills with Finish Date Missing from Bills Tab

[Robert J Jackson]

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));