Payment Editor

I snapped. Heh.

It was about time I grew tired of all the editing I have to do with all the mistakes in posting payments. Every time Agnes calls me to adjust batches of O.R. numbers, I have had to:

1. Load up the SQL front end.
2. Open my database of commands.
3. Open the commands table.
4. Select the second-to-last record for the template.
5. Copy the template's starting O.R.# to the clipboard.
6. Ask Agnes what the starting O.R.# to edit is.
7. Search and replace.
8. Copy the template's ending O.R.# to the clipboard.
9. Ask Agnes what the ending O.R.# to edit is.
10. Search and replace.
11. Copy the template's date of payment to the clipboard.
12. Ask Agnes what the posting date to edit is.
13. Search and replace.
14. Ask Agnes what to edit (teller_id, payment_date, O.R.#'s)
15. If O.R.#'s, switch to the command prompt or load one up.
16. Calculate the difference between correct and wrong starting O.R.#'s.
17. Search and replace.
18. Execute appropriate commands.

Now, with editpay.bat, I have compressed these steps into:

1. Editpay , , ,
2. Execute appropriate commands.

Kewl!!!

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!

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.