BCMS User-Friendliness Updates

After the last time I made changes and improvements to BCMS, I've done the following:

1. Fixed the "not unpressed buttons" issue on the Consumer Ledger and Consumption buttons in the Ledger module.

2. Gave access to Disconnection clerk to the overpayment application module because she needs to see which (and how many) months the receivables were for. Initially, she only wanted me to force the Ledger tab in the Ledger module to display the last entry, but I was not able to find a way, at first.

3. In relation to #2, found the way to force the listviews on the Ledger module to ensure that the last item is visible [listview.listitems(listview.listiems.count-1).ensurevisible or some such hocus-pocus].

4. Switched the listviews in the Ledger module not to HIDE the SELECTION highlight when out of focus.

5. Added Syntax-error Prevention code on Bill Posting module when searching for areas.

6. Pressing ENTER on Area field will now erase the contents, if it already has been looked up prior.

7. Added TOTALs to the financial columns in Overpayment module.

8. Switched reports on Rose's new PC to the Epson FX-1170 driver.

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.