Saturday, May 30, 2015

QUERY TO REMOVE FAKE OUT OF ACCOUNT IN DAILY ACCOUNT

Run below query in query analyser to remove out of account in daily account

use treasury
delete from dbo.VpArticlescash
where CounterSerial='0'
go
delete from dbo.CounterCashTemporary
where CTTSerial='0'
go
delete from dbo.CounterCashTemporary2
where CTTSerial='0'
go
delete from dbo.BranchAdjustment