Comment 4 for bug 1772955

The proposed patch only works as expected if the list of billings that the user owes money on fits in one grid page. If the user has more billings than that, paging through the rows will cause the total billed, owed, and paid values to fluctuate based on the billings that are currently displayed.

I think the underlying problem is that the database view that the summary amounts is taken from, money.open_usr_summary, says the following: "give me the totals for all transactions that are still open that ever had billings on it". Instead, for this interface the desired view would be more like "give me the totals for all transactions that are still open and do not have a balanced owed of zero".

Consequently, I propose as a more durable fix either changing the definition of money.open_usr_summary (but might that break any reports that depend on the current definition of the view) or create a new view called something like money.open_having_balances_usr_summary.