SPBilling

Remove Maintenance previous balance

1. Open SQL Yog connect to 89 server
2. Run this query
3. Remember changes the date do you want to remove the balanced.
4. SELECT * FROM spbilling.tblmbilling WHERE dtencoded >= '2016-03-10'
5. UPDATE spbilling.tblmbilling SET prevbal = "0.00", prevpenalty = "0.00" , prevpmt = '0.00' WHERE dtencoded >= '2016-03-10'

Remove Water previous balance

1. Open SQL Yog connect to 89 server
2. Run this query
3. Remember changes the date do you want to remove the balanced.
4. SELECT * FROM spbilling.tblwbilling WHERE dtencoded >= '2016-03-10'
5. UPDATE spbilling.tblwbilling SET prevbal = "0.00", prevpenalty = "0.00" , prevpmt = '0.00' WHERE dtencoded >= '2016-03-10'