update vs4tapinvoice set tiapadjusttotal=0 where tiapadjusttotal is null
GO
update vs4tapinvoice set tiapgrandtotal=tiaptaxbase-tiapadjusttotal, tiaparrears=tiaptaxbase-tiapadjusttotal where tiaprefno like 'POP%'
GO
