Difference between revisions of "SPBilling"
From SPGC Document Wiki
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
== Remove Maintenance previous balance == | == Remove Maintenance previous balance == | ||
Revision as of 14:03, 15 March 2016
Remove Maintenance previous balance
- Open SQL Yog connect to 89 server
- Run this query
- Remember changes the date do you want to remove the balanced.
- SELECT * FROM spbilling.tblmbilling WHERE dtencoded >= '2016-03-10'
- UPDATE spbilling.tblmbilling SET prevbal = "0.00", prevpenalty = "0.00" , prevpmt = '0.00' WHERE dtencoded >= '2016-03-10'
Remove Water previous balance
- Open SQL Yog connect to 89 server
- Run this query
- Remember changes the date do you want to remove the balanced.
- SELECT * FROM spbilling.tblwbilling WHERE dtencoded >= '2016-03-10'
- UPDATE spbilling.tblwbilling SET prevbal = "0.00", prevpenalty = "0.00" , prevpmt = '0.00' WHERE dtencoded >= '2016-03-10'
