USE T202526


----- SINGLE CHEQUE SINGLE ADJUSTMENT
--UPDATE RECEIVED_PAYMENT_DETAIL SET RecAmt = T1.F1 FROM (SELECT SUM(PaidAmt) AS F1, RecSrNo AS F2 FROM RECEIVED_ADDLESS_DETAIL GROUP BY RecSrNo) AS T1 WHERE T1.F2 = RecsRnO AND RECCHEQUENO NOT LIKE '%,%' AND RECSRNO NOT IN (SELECT RECSRNO FROM RECEIVED_PAYMENT_DETAIL  GROUP BY RECSRNO HAVING MAX(RECISRNO)>1)

------ ALL
UPDATE RECEIVED_PAYMENT_DETAIL SET RecAmt = T1.F1 FROM (SELECT SUM(PaidAmt) AS F1, RecSrNo AS F2 FROM RECEIVED_ADDLESS_DETAIL GROUP BY RecSrNo) AS T1 WHERE T1.F2 = RecsRnO AND RECSRNO NOT IN (SELECT RECSRNO FROM RECEIVED_PAYMENT_DETAIL  GROUP BY RECSRNO HAVING MAX(RECISRNO)>1)


UPDATE RECEIVED_DETAIL SET RecAmt = T1.F1 FROM (SELECT SUM(PaidAmt) AS F1, RecSrNo AS F2 FROM RECEIVED_ADDLESS_DETAIL GROUP BY RecSrNo) AS T1 WHERE T1.F2 = RecsRnO