nanalilo2009-12-03TA获得超过272个赞关注朋友，你使用的金蝶K3系列**品吗？金蝶K3在总账初始**录入中，有时会出现综合本位的金额不随着原金额变动的情况（尤其是设置了核算项目的科目）--问题可能是程序中对期初余额中纪录的修改和删除操作，只更新了原的纪录，没有更新对应的本位纪录，造成本位与原不符。可以在查询分析器中，选定该账套对应的**库后，执行下述语句：--将所有本位记录中与原不等的记录更新updateasetfbeginbalancefor=b.fbeginbalancefor,fdebitfor=b.fdebitfor,fcreditfor=b.fcreditfor,fytddebitfor=b.fytddebitfor,fytdcreditfor=b.fytdcreditfor,fendbalancefor=b.fendbalancefor,fbeginbalance=b.fbeginbalance,fdebit=b.fdebit,fcredit=b.fcredit,fytddebit=b.fytddebit,fytdcredit=b.fytdcredit,fendbalance=b.fendbalancefromt_balanceb,t_balanceawherea.fyear=b.fyearanda.fperiod=b.fperiodanda.faccountid=b.faccountidanda.fdetailid=b.fdetailidanda.fcurrencyid='0'andb.fcurrencyid='1'and(a.fbeginbalancefor<>b.fbeginbalanceforora.fdebitfor<>b.fdebitforora.fcreditfor<>b.fcreditforora.fytddebitfor<>b.fytddebitforora.fytdcreditfor<>b.fytdcreditforora.fendbalancefor<>b.fendbalanceforora.fbeginbalance<>b.fbeginbalanceora.fdebit<>b.fdebitora.fcredit<>b.fcreditora.fytddebit<>b.fytddebitora.fytdcredit<>b.fytdcreditora.fendbalance<>b.fendbalance)--以原记录为基础，直接将所有查询到的本位缺少的分录插入到余额表中insertintot_balanceselectfyear,fperiod,faccountid,fdetailid,(casewhenfcurrencyid='1'then'0'else'1'end)asfcurrencyid,fbeginbalancefor,fdebitfor,fcreditfor,fytddebitfor,fytdcreditfor,fendbalancefor,fbeginbalance,fdebit,fcredit,fytddebit,fytdcredit,fendbalance,fframeworkidfromt_balancewherefaccountid+'_'+fdetailid+'_'+fperiodin(selectfaccountid+'_'+fdetailid+'_'+fperiodfrom(select*fromt_balancewherefcurrencyid=1)asawherefaccountid+'_'+fdetailid+'_'+fperiodnotin(selectfaccountid+'_'+fdetailid+'_'+fperiodfromt_balancewherefcurrencyid=0))--删除综合本位中多出的记录deletefromt_balancewherefcurrencyid=0andfaccountid+'_'+fdetailid+'_'+fperiodnotin(selectfaccountid+'_'+fdetailid+'_'+fperiodfromt_balancewherefcurrencyid=0)