[Koha-bugs] [Bug 24266] Noisy error in reconcile_balances.pl

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24266

--- Comment #7 from Aleisha Amohia <aleisha at catalyst.net.nz> ---
Created attachment 100832
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=100832&action=edit
Bug 24266: (alternate patch) Only use defined borrowernumbers in
reconcile_balances.pl cron

I believe the error is triggered when borrowernumbers are left empty in
the accountlines table. Not sure why this would happen, but it appears
to be what causes the problem.

Do not apply the first patch if testing this patch.

To test:
1) sudo koha-mysql INSTANCENAME
2) if you don't have any accountlines where the borrowernumber is null,
    update one of your accountlines where the amountoutstanding is more
than zero, and make the borrowernumber NULL
3) ensure the AccountAutoReconcile syspref is disabled
4) Go to [borrowernumber]'s accounting tab
5) Create a manual credit or debit. Confirm this shows in the 'Make a
payment' tab as an amount that COULD be applied, but isn't automatically
applied
6) in your terminal, run the reconcile_balances.pl script
7) Confirm the error does not show in the logs and the balance for
[borrowernumber] is correctly reconciled.

Sponsored-by: Horowhenua District Council

-- 
You are receiving this mail because:
You are watching all bug changes.