Payment Corrections

Did a few payment corrections yesterday for Soc. I also corrected readings made by Tolio because he input May instead of April in his handheld's Date setting. I also corrected 5 areas because his niece, Mariliz, also input May as the reading month when she created the download .dat files.

Today, had to delete a payment because PSP accidentally posted it when someone queried for their outstanding bills.

Received an invitation to attend a "seminar" on Business Intelligence alignment with I.T. strategies. My eyes bulged out when I saw the price tag ($987 !!!). Whoah!! I guess I won't be going, then.

Wi-Fi

Woohoo!!! I've just setup my first Hotspot!

I installed a Linksys WAP54G (firmware in the 3.x series) and I managed to connect 2 N93's and RCD's IBM Thinkpad R50E, which I used to test how far the connection can go. I placed the AP near the corner of the Gigabit switch, to which I connected it, and I could get a connection from my cubicle [3 concrete walls!], although a tad intermittent, to JTL's doorway. Hmmm.... I guess I need at least 1 repeater for Admin, 1 for Billing and 1 for the other Building.

Payment Corrections

For Agnes:
(Joel's fault)
update payment p set ornumber=concat('0',ornumber+713450,'T') where ornumber between '0079271T' and '0079278T' and payment_date='2007-04-23'
update artran p set docno=concat('0',docno+713450,'T') where docno between '0079271T' and '0079278T' and docdate='2007-04-23'
update payment p set ornumber=concat('0',ornumber-7134500,'T') where ornumber between '7927229T' and '7927342T' and payment_date='2007-04-23'
update artran p set docno=concat('0',docno-7134500,'T') where docno between '7927229T' and '7927342T' and docdate='2007-04-23'

Soc's fault?
change from Wtax to FinalVAT: 64.84 pd_id=1369248, o.r.# 0006202B

MCAJr's PC

Took over from Rico after he reformatted drive C: and reinstalled Windows and Office.

Installed Autopatcher until Feb 2007 patches. Turned on automatic updates, babysat it for a while as I installed more apps and tried out Comclark's internet connection.

Payment corrections

For Agnes, added 0 at the start of 1 O.R.#.

For Soc, transferred 1 O.R. to PCI Dolores.

Payment Type Correction

For Agnes:

Changed payment type from Final VAT to Withholding Tax: O.R.# 0006277B, account #47978.

Duplicate account

Aching Glo asked me to delete the new account she created because there's already an existing account (she didn't know someone else had created it already):

delete from consumer_master where establishment_businessname='E.L. VALERIO REALTY'
and account_no_id=77854

Peachtree problem

MCAJr's Peachtree on his workstation suddenly stopped working (IE script errors). Links found via google all said UNINSTALL-REINSTALL is the fix.

I'm thinking I should just reinstall the O.S. and apps altogether just to get rid of the "Access Denied" issue on several folders (even when using an Admin account!).

Payment Correction

For Agnes:

Posted correction to a misposting by Obet to Acct # 557 (Shd. be #50557).

For Soc:

Edited 0053513B to add Php367.22.

Corrections

April 18, 2007:

13:12 for DPP:
update consumer_connection set current_status=0 where consumer_connection_id=44564;
update consumer_connection set current_status=1 where consumer_connection_id=45853;
update consumer_connection set account_no_id=44532,meter_information_id=44564 where consumer_connection_id=100034403;

13:29 for RAJE:
update meter_lup set demand_multiplier=multiplier where demand_multiplier=0

for Soc:
0051402B deleted for Soc.

0004625B ??? (can't remember if I did something to this O.R., it just got pasted here. I'm retaining it for future reference)

0052583B change to 0052883B

April 19, 2007:


changed o.r. #611011443T to #0786455T
input 0786348T just to cancel

along with corresponding updates to payment_details_vat:
update payment_vat_summary set generation=-84.08 where payment_detail_id=1375817
update payment_vat_summary set distribution=-21.97,generation=-37.21,system_loss_gen=-4.96,transmission=-16.04,system_loss_trans=-2.44 where payment_detail_id=1375817

corrected several consecutive O.R.#'s for Soc. Whew! This one took much time!

Payment and Job Order corrections

For Soc:

transfer bank from 94 (Plantersbank Mt Carmel) to 91 (AUB) 0052924B

subtract Php 0.19 from 0049242B


For DPP:

bring back previous connection record as current status (someone misposted a disconnection to account # 45167)

Annual Stockholders' Report

Whew! I've just finished 40 copies. While I was printing the 40 cover pages on the glossy photo paper I bought at SM Dept. Store last night, I had someone buy the plastic binders and I punched the holes on the pages.

As usual, I had to cut the papers containing the body of the report on the right side because they're in letter size while the cover pages are A4. Then I had to cut the cover pages on the bottom side because they're more than 11 inches long.

All in all, I did an almost perfect job in the binding process. I didn't ruin any pages today! Hurray!!! The only mistake I made was on 3 sets of Financial statements and I remedied it by cutting the mispunched side instead of the right side. :-)

Monthly reports

Finally, I've finished my monthly reports after getting submissions from CFC and Amy A.

I kinda forgot to send Yvonne A. her copies, though, because I was juggling the annual stockholders' report, my monthly reports, Garbes/Globe's request for a list of residential customers, Virtualization research (I'm itching to try it!).

(Yawn) All this work is tiring me, I think I'll catch 40 winks...

Oh, no! I just realized, JTL still hasn't given me the pictures I'll be using for the cover! :-(

Annual Stockholders' Report

Whew!

Seems that JTL sent Mr. President his own FINAL version before Irwin consolidated all the corrections and changes by CFC and AGD! I had a hard time reviewing two (2) final versions again.

I hope I didn't mess it up...

Payment Correction

for Agnes: (Anna Romina Yalung's receipts)

update payment p set ornumber=CONCAT('0',ORNUMBER+30000,'T') where ornumber between '0738433T' and '0738609T' and payment_date='2007-04-03';
update artran p set docno=CONCAT('0',docno+30000,'T') where docno between '0738433T' and '0738609T' and docdate='2007-04-03';

Name correction

for Joylan:

UPDATE `consumer_master` SET `firstname`='MAYNARDO MALCOM' WHERE `account_no_id`=77772;

Payment Correction

for Soc:

Subtracted Php 0.42 from O.R. # 0032438B.

New Meters

Employed my meter_lup robot adder workbook again for Jorge. imported 101 meters from SFE # 83158 to 83258.

Gateway PSU problem

Upon arrival at the office, Gina told me we had to internet access.

I immediately realized that the gateway PC's PSU has died. So I quickly replaced it, and within 15 minutes, it was up and doing its job once more.

O.R.# correction etc

Soc told me Mang Efren repeated a batch of O.R.#'s which he'd already issued on 04/11:

update payment set ornumber=concat('00',ornumber+13,'B') where ornumber between '0052871B' and '0052882B' and payment_date='2007-04-12'

update artran set docno=concat('00',docno+13,'B') where docno between '0052871B' and '0052882B' and docdate='2007-04-12'

Subtracted Php10,000 from O.R.# 0053178B.


For Agnes:
Inserted details for a cancelled O.R.:

insert into payment_details values (null,1334289,1732418,20,9.78,0,0,0,0,NULL,NULL,NULL,20070402171034,"",NULL,2047610,'2007-02-19',NULL,NULL,0,0,864405,3)

Changed O.R.# from 9743626T to 0743626T.

VAT Discrepancy

Corrected a 1-centavo discrepancy for O.R.# 0778993T. Subtracted it from the EVAT-Generation.

This is for acct # 4136.

Payment Correction

Modified 3 payments for Soc:

1. O.R.# 0050393B: transfer from Field Collector (id # 43) to EWTax (# 45) and change O.R.# to 0006202B
2. O.R.# 0052565B: subtracted Php6.00
3. O.R.# 0052896B: subtracted Php1.00

Annual Stockholders Report

Finished the first Final Draft. AGD missed several grammatical errors by Irwin. Had to manually add additional spaces after sentences. The graphs look nice! Hehe...

Payment Date Correction

Changed payment date of O.R.# 0006198B from 4/12/2007 to 4/13/2007, for Agnes.

Payment Correction

Modified 4 payments (4 O.R.'s) for Soc, corrected 2 amounts, transferred 2 from Maybank to RCBC SF Main.

SM Payment Collection

Ms. Vona asked me to resend to her our account numbering convention. I also gave her 20 actual account numbers for their test run.

I also finally got around to scanning an actual billing statement and sent it to her.

bcms update

DPP wanted to cancel 2 bills for Account # 3134, but the bills she was cancelling were billtype 'A' (they were adjustments to bills), but BCMS only looks for billtype 'B'.

So: I changed criteria to "billtype in ('A','B') and adjusted<>'T'" instead of Lester's "billtype='B'" only.

rate computation

Finally, the April 2007 rates are done. Rocky and I spent a few hours checking and counter-checking because I wasn't consistent in my changes to the "Unbundled Power/Florida Bill" workbooks. Darn MSP Common Charge!

annual stockholders report

Despite having my printout of Load and Power Factor, Irwin still asked me which figures are which. Duh... :-(

payment correction

Modified a couple of payment records for Agnes. Can't remember the O.R.#'s right now, because that was a few hours ago.

annual stockholders report

Irwin asked me for a copy of "Load and Power Factor" report for 2006, so I gave him one fresh printout.

Yesterday he asked me for the summary and I also gave him a copy. That was the copy I asked Rocky to give to him, but apparently he didn't get it. :-O

rate computation

Whew! Finally, I'm done with the April rate computation. Had to augment my formulas for the EVAT and UC sheets on the individual franchise workbooks... forgot to include the late bills' UC and VAT values...

meter reading date correction

Corrected dates for Power Bills days 6,7,8.

Problem is, Mike uploaded the uncorrected data before I corrected the upload data files!

So I had to:

update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611011265';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611010955';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511010556';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611010747';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511010557';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010540';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010872';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511011295';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611011495';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511010325';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511010470';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511010456';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511011446';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0101020517';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0211010582';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611011210';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611011211';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511010560';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010643';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411014285';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611010386';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611010011';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0111010666';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511010000';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0111011451';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010522';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0111010139';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0111010140';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0111014270';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0111014271';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511010072';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511013914';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0100076916';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0111010122';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611011366';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611010064';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010576';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411011616';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611010123';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611010280';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010101';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010647';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010605';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0111010251';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611014253';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010032';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0111014159';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0811010734';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010049';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511010050';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010053';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010054';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0500076565';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611010570';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611010222';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010505';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511010574';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0111014116';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0811010732';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0111011532';

meter reading date correction

Corrected dates for several records in area 0231 (000231u.dat)

payment correction

Corrections made for Soc:

update payment set payment_date='2007-04-03' where ornumber between '0047904B' and '0047916B' and payment_date='2007-04-02'
update artran set docdate='2007-04-03' where docno between '0047904B' and '0047916B' and docdate='2007-04-02'
update payment set payment_date='2007-04-03' where ornumber between '0050956B' and '0050984B' and payment_date='2007-04-02'
update artran set docdate='2007-04-03' where docno between '0050956B' and '0050984B' and docdate='2007-04-02'
update payment set payment_date='2007-04-03' where ornumber between '0048598B' and '0048605B' and payment_date='2007-04-02'
update artran set docdate='2007-04-03' where docno between '0048598B' and '0048605B' and docdate='2007-04-02'
update payment set payment_date='2007-04-03' where ornumber between '0046289B' and '0046302B' and payment_date='2007-04-02'
update artran set docdate='2007-04-03' where docno between '0046289B' and '0046302B' and docdate='2007-04-02'
update artran set docdate='2007-04-04', user_id=27 where docno IN ('0038833B','0038855B','0038856B','0051651B','0051652B','0051653B','0051654B','0051655B','0051657B')
and user_id=23
update payment set payment_date='2007-04-04', teller_id=27,created_by=27 where ornumber IN ('0038833B','0038855B','0038856B','0051651B','0051652B','0051653B','0051654B','0051655B','0051657B')
and teller_id=23

0050992B less 0.50
0050216B add 279.24
0052499B add 0.56

BCMS issue

Hmmm... the PAYMENT vs. VAT+UCME+UCEC issue has resurfaced!

I just asked A. Glo to exit the teller module and re-enter.

Hmmm.... I wonder...

Payment Correction

Modified 2 O.R.'s for Agnes (switched FINAL VAT and W/HOLDING TAX entries).

JTL O2007

JTL asked me to install O2007 on his new laptop. Spent about an hour on it.

And this is right in the middle of editing 000205u.dat for RAJE. I spent more than 2 hours on that and still MOVBLANK won't move unread records!!! Sheesh!!!

Well, at least I was reminded that I have QEdit's macros on my arsenal when it comes to such problems....

Meter Reading Date Correction

4/10/2007 9:47 43,522 000107u.dat
4/10/2007 9:47 31,772 000110u.dat
4/10/2007 9:48 18,988 000125u.dat
4/10/2007 9:48 8,836 000126u.dat
4/10/2007 9:48 27,354 000120u.dat

Justine Gabionza likes Linux?

While searching for a name associated with someone who has kept texting and sometimes miss-calling me since Feb 23, 2007, I came across Justine Gabionza's name (she's a Filipina Beauty Queen) so I wondered what she looked like.

I found this picture of hers. I wonder if she uses Linux? :-)

Payment correction

Modified a payment record for Agnes/Soc: Made them cancel the misposting and made Soc post it on another date so I can just modify the date.

Windows Vista validation

Hmmm... so it was another firewall (iptables) issue that prevented the Neo notebook PC from connecting outside our LAN. Sheesh!

Was finallly able to VALIDATE Vista after I put the SQUID entry for it BEFORE all the other SQUID entries in iptables.

I guess I'll have to research on iptables limits...

Windows Vista activation and validation

Yesterday, JTL asked for my help in activating Vista Home Premium on his newly purchased Neo QNote Core 2 Duo.

I didn't want to connect it to the office network, just as a precautionary measure. So I opted for the toll-free telephone activation.

I got an "invalid Installation ID" from the robot. Duh?!?! Then I noticed that there's some text on the bottom-right corner of the screen saying "... This copy of Windows is not genuine." OOPS!!!

I thought it was a pirated copy, until this morning when I got to research on it. Seems like there've been plenty of FALSE ALARMS regarding this activation/validation thing.

I told JTL that I'll try activating over the net (by connecting it to our office LAN), but I decided to avoid any detection of a potential pirated copy coming from our network, so I tried the telephone activation again. Voila! This time, it worked! Sweet, Microsoft, just sweet. Duh!!!

Wait a minute!!! Why is the "this copy is not genuine" text still on the corner of the screen?!?! Oh, so I still need to validate it, huh? Sheesh!

Will get there later... "Network Access: Local only" is now my problem. :-(

Payment misposting

Posted adjustment due to misposting by Nette to #14118 (should be #14115), amounting to Php 1,384.59.

Canon lIDE scanner

MCAJr asked me to install the scanner mentioned and its accompanying software on his john2 workstation.

First I booted into safe-mode to get rid of the VBSilly-B virus(es).

I then spent about 2 hours trying to force the installation of the scanner software, to no avail. (I had to set up security for "c:\Program Files" and give FULL access to Administrators, but I couldn't access "c:\Program Files\installshield installation information" !!!

I eventually gave up.