| 解决方案： |
取消库存1月份结账,然后在查询分析器中执行如下脚本
select distinct * into c_total from st_totalaccount
delete from st_totalaccount
insert into st_totalaccount select * from c_total
delete from st_totalaccount where cwhcode=‘001‘ and ibeginnum=0.0
delete from st_totalaccount where cwhcode=‘002‘ and ibeginnum=0.0
delete from st_totalaccount where cwhcode=‘003‘ and ibeginnum=0.0
delete from st_totalaccount where cwhcode=‘004‘ and ibeginnum=0.0
delete from st_totalaccount where cwhcode=‘005‘ and ibeginnum=0.0
drop table c_total |