| 解决方案： |
1.反记结账到2005.01月初
2.use ufdata_002_2005
go
--先输出2005年度账备份
--更新凭证表
update gl_accvouch set iflagbank=null,bdelete=0 where ccode in
(select ccode from code where bbank=1 and bend=1)
--更新银行对帐单
select * from RP_bankrecp
delete from RP_bankrecp where ibegin=2
--把银行科目的启用日期统一调整为2005-01-01
select ccode,dbegin from code where bbank=1 and bend=1
update code set dbegin='2005-01-01' where bbank=1 and bend=1
--由于日期都调为一月一日，删除iperiod＝21的2005待核销银行账
delete from gl_accvouch where iperiod=21 and year(dbill_date)=2005
|