Webclient - Creation of Bill followed by Attempt to Pay Fails

[Robert J Jackson]

Evergreen web client 3.1.2 as well as older install

When billing a patron and then immediately trying to pay that bill an error of:

Event: 1532:MONEY_BILLABLE_TRANSACTION_SUMMARY_NOT_FOUND -> The requested money_billable_transaction_summary was not found

This has been reported by staff as far back as November 2017 as well. On both of those occasions the following log entry was detected:

osrfsys.19.log:2018-06-13 19:08:02 app10-prod open-ils.circ: [WARN:11111:CStoreEditor.pm:139:152888893327057897] editor[1|4290719] retrieve money.billable_transaction_summary called with no ID...

The following two entries from same thread seem to indicate that when the bill was created there wasn't anything owed? Seems odd...

2018-06-13 19:06:53 app10-prod open-ils.circ: [INFO:11111:Application.pm:159:152888893327057886] CALL: open-ils.circ open-ils.circ.money.grocery.create xxxxxxxxxxxxxxxxx, Fieldmapper::money::grocery=ARRAY(0x617e0e8)

2018-06-13 19:06:54 app10-prod open-ils.circ: [INFO:11111:AppUtils.pm:2313:152888893327057886] closing transaction 77800839 because balance_owed == 0

Attaching example error screen on attempted payment from latest instance.

[Deborah Luchenbill (deborah)]

One of our libraries is reporting this exact problem, as well. They upgraded to 3.0.9 from 3.0.2 last week and it happened both before and after the upgrade.

[Christopher Burton (cburton)]

I have found a temporary fix to this issue.

If you select 'BILL #' as a column (the bill ID), the function will work again.
Without this column visible, the ID is not passed to the function which is why all rows select and de-select on one row click.

After adding 'BILL #' as a column, rows are individually clickable and payments process fine

This column is basically toggling functionality for Bills right now....

[Erica Rohlfs (erohlfs)]

Confirmed on 3.0.9 Web Client. Also confirming Christopher's workaround.

[Cesar V (cesardv)]

Hello, here's a patch that takes care of the issue:

http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/cesardv/lp1776917-patron_bills_grid_require_billID

Kudos to Christopher for pointing us towards a temp. workaround, and hinting us onto the source of the issue.

[John Amundson (jamundson)]

Linking to similar bug, because I think it may be fixed with the patch based on Christopher's comment #4
https://bugs.launchpad.net/evergreen/+bug/1780283

[John Amundson (jamundson)]

I have tested this code and consent to signing off on it with my name, John Amundson and my email address, <email address hidden>.

Thank you, everyone.

I'll confirm that Bill # is no longer needed to...
-Pay a bill after adding it
-Singularly select a row.

On the Bills, Current screen, which is the focus of this bug.

This does not change the behavior on Bills, History (Bill #) or Payment, History (Payment ID). I'll update bug #1780283 with these details.

[Jason Stephenson (jstephenson)]

Pushed to master, rel_3_1, and rel_3_0.

Thanks, everyone!