SPBilling

From SPGC Document Wiki
Revision as of 14:03, 15 March 2016 by Admin (Talk | contribs)

Jump to: navigation, search

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'

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'

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'
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=SPBilling&oldid=130"