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.

Payment Type Correction

For Agnes:

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

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!

Name correction

for Joylan:

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