备份好账套数据之后,执行以下脚本之后再进行年结。年结的时候也不能选择2015年了。
delete from storagelist where storage_id not in (
select s_id from storage)
ALTER TABLE product DISABLE TRIGGER all
delete product where s_syb=-1
ALTER TABLE product enable TRIGGER all
ALTER TABLE units DISABLE TRIGGER all
delete units where s_syb=-1
ALTER TABLE units enable TRIGGER all
ALTER TABLE Area DISABLE TRIGGER all
delete Area where s_syb=-1
ALTER TABLE Area enable TRIGGER all
ALTER TABLE StorHouse DISABLE TRIGGER all
delete StorHouse where s_syb=-1
ALTER TABLE StorHouse enable TRIGGER all