BCMS: Overpayment application

Whew! Finally!!! The Overpayment module now takes into account the amount of VAT and UC to apply from bill to bill! Woohoo!!!

In the process, I eliminated some more primitive coding by streamlining again; specifically, using the iif(), min(), and max() functions. The latter 2 I had to build functions for. No big deal.

BCMS: Historical data on consumers

Finally got to finish the Connection History and Meter History tabs in the Consumer Ledger! :-)

BCMS: Additional Feature

Finished the enhancement for the Teller collection report module.

Will now deploy the new .exe for Agnes to witness the last remaining uncorrected VAT discrepancy.

BCMS improvements

Recent changes to BCMS:

1. Added another report (and corresponding button) - Daily Check Payment Report - to the Teller Collection report module.

2. Modified Bill Posting to include 3 options: Late bills only, Current bills only, All Bills.

3. Independent module: Discovered that sometimes, payment_vat_summary doesn't tally with payment_details_vat. I don't know how previous instances (I'm sure they exist) escaped Agnes, so I included pvs in the checking of the vatdisc program. I'm planning on integrating this, including the corrections in the report generating module, into BCMS. Well, at least the pvs data can be automatically corrected if that's the only problem. I can't automate correction of the pdv data if they don't tally with the pd data.

4. Discovered that the VAT_ME_EC variable was not being reset when a teller presses the NEW button in the Teller module. Fixed.

5. Allowed full application of over payments (now includes VAT and UC) but I haven't perfected this yet. Will update on this later, when I finish it.

Soc Proofing

Added some Soc-Proofing (TM) to BCMS. I made that she'll be forced to select a Bank whenever she changes the O.R.# manually. In turn, the date and O.R.#'s are blanked whenever she changes Bank.

I met a lot of resistance from her. In due time, I hope she somes to realize that it's doing all of us a favor.

Glo's PC

Last month, GPM's PC blew its PSU. Rather than replacing it with a working one and risking another blow-out, I lent her Rose's replacement PC. The next day, that too, blew out its PSU. Mike suggested that I replace the monitor because it might be the culprit. Fortunately, the replacement PSU's arrived that day and the problem is solved. I claimed back the lent PC and she's now using her original PC.