解决方案: |
1、在当前帐套2005年度库中参照执行如下脚本补录年初辅助帐中2121科目缺少的9994供应商的年初余额: INSERT INTO GL_accvouch (ibook,iperiod,csign,isignseq,ino_id,dbill_date,idoc,ctext1,ctext2,cbill,cbook,ccheck,ccashier,iflag,coutaccset,ioutyear,coutsysname,ioutperiod,coutsign,coutno_id,dReceive,doutbilldate,bvouchedit,bvouchaddordele,bvouchmoneyhold,inid, cdigest,ccode,cexch_name,md_f,mc_f,md,mc,nd_s,nc_s,coutsysver,nfrat,csettle,cn_id,dt_date,cdept_id,ccus_id,csup_id,citem_id,citem_class,cperson_id,cname,ccode_equal,iflagbank,iflagperson,doutdate,coutbillsign,coutid,bvalueedit,bcodeedit,ccodecontrol,bPCSedit,bDeptedit,bItemedit,bCusSupInput,cDefine1,cDefine2,cDefine3,cDefine4,cDefine5,cDefine6,cDefine7,cDefine8,cDefine9,cDefine10,cDefine11,cDefine12,cDefine13,cDefine14,cDefine15,cDefine16) VALUES (1,0,'记',1,252,'2004.12.25',1,Null,Null,'demo','demo','demo',Null,Null,Null,Null,Null,Null,'',NULL,null,'2004.12.25',1,0,0,1,'付12月运费','2121',Null,0,0,0,56019,0,0,Null,0,Null,Null,'2004-12-25',Null,Null,'99943',Null,Null,Null,Null,NULL,NULL,NULL,Null,Null,Null,1,1,Null,1,1,1,0,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null) --select * from gl_accvouch where iperiod=0 and csup_id='99943' union select top 3 * from gl_accvouch where iperiod=0 and csup_id like '99%' 2、在当前帐套2005年度库中参照执行如下脚本修复辅助帐中2121科目的9994供应商余额: --select * from gl_accass where csup_id='99943'and ccode like '2121%' update gl_accass set cbegind_c='贷',MB=56019.0000,cendd_c='平',ME=0.0000 where csup_id='99943'and ccode like '2121%' and iperiod=1 update gl_accass set cbegind_c='平',MB=0.0000,cendd_c='平',ME=0.0000 where csup_id='99943'and ccode like '2121%' and iperiod<>1 3、在当前帐套2005年度库中参照执行如下脚本修复科目总帐中2121科目余额: --select * from gl_accsum where ccode like '2121%' update gl_accsum set me=me+56019.0000 where ccode = '2121' update gl_accsum set mb=mb+56019.0000 where ccode = '2121' and iperiod<>1 4、正常的对帐记帐即可。 另外,以后在做年结工作前,建议将U8HOTFIX及总帐的补丁先打上去,以尽量避免由于程序问题导致接转后数据错误。 注意做好数据备份! |