Sesco KWB

Delete Sesco interface file
D:\Back\new app\Send


Check double contract number
select * from tsales where createdate = '2011-04-21' and prdcode = '1160836' order by creserved2

set downloaddate4 to Null so edp can rerun the export
update tsales set downloaddate4 = null where createdate = '2011-04-21' and prdcode = '1160836'

Change contract no / creserved

update tsales set creserved = '205147646101' where createdate = '2011-02-28' and prdcode = '1134907'
and creserved = '205147646100' and invnum = '10633702'

update tsales set creserved2 ='010411' where createdate= '2011-04-21' and prdcode='1160836' and invnum= '30066427'


Kindly inform that KWB report on 21.4.2011 have same problem
for outlet Tabuan jaya bill code , normally the bill code number
is start from 010xxx but to
invoice no.
7101392152 thier bill code number is 710139 and
7101473181 thier bill code number is 710147.

010411