Payment adjustments

Been doing the usual corrections to payments for Soc and Agnes day by day, by day... (Hahaha... reminds me of "Meet The Parents")

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

Payment corrections

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

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

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.

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)

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';

Payment Correction

for Soc:

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

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

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.

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.

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

Payment Correction

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

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.

Payment misposting

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

Payments correction

Transferred 5 receipts from March 30, 2007 to March 29, 2007 (wrong date) - for Soc.

Transferred 2 receipts to EPCI-SINDALAN, corrected 1 of them (ornumber) - for Soc.