3、金蝶K3固定资产结账时提示溢出详细描述固定资产结账时提示算术溢出错误,如何处理。
东莞金蝶提供解决方案发生的原因:由于固定资产余额内码过大导致结账出错。
解决方法:请备份好账套后在数据库中对账套实体使用以下语句调整余额内码。--更新之前,禁用约束ALTER TABLE t_fabalcarditem NOCHECK CONSTRAINT FK_t_FABalCardItem_t_FABalance ALTER TABLE t_fabalcard NOCHECK CONSTRAINT FK_t_FABalCard_t_FABalance ALTER TABLE t_fabaldevice NOCHECK CONSTRAINT FK_t_FABaldevice_t_FABalance ALTER TABLE t_fabalorgfor NOCHECK CONSTRAINT FK_t_FABalorgfor_t_FABalance ALTER TABLE t_fabaldept NOCHECK CONSTRAINT FK_t_FABaldept_t_FABalance ALTER TABLE t_fabalexpense NOCHECK CONSTRAINT FK_t_FABalexpense_t_FABalance --生成新旧内码对照表select distinct(fbalid) AS Foldid,IDENTITY(int,1,1) as fnewid into #tmpa from t_fabalance --用新内码更新就内码update t_fabalcarditem set fbalid=#tmpa.fnewid from t_fabalcarditem carditem,
#tmpa where #tmpa.foldid=carditem.fbalid update t_fabalcard set fbalid=#tmpa.fnewid from t_fabalcard carditem,
#tmpa where #tmpa.foldid=carditem.fbalid update t_fabaldevice set fbalid=#tmpa.fnewid from t_fabaldevice carditem,
#tmpa where #tmpa.foldid=carditem.fbalid update t_fabalorgfor set fbalid=#tmpa.fnewid from t_fabalorgfor carditem,
#tmpa where #tmpa.foldid=carditem.fbalid update t_fabaldept set fbalid=#tmpa.fnewid from t_fabaldept carditem,
#tmpa where #tmpa.foldid=carditem.fbalid update t_fabalexpense set fbalid=#tmpa.fnewid from t_fabalexpense carditem,
#tmpa where #tmpa.foldid=carditem.fbalid update t_fabalance set fbalid=#tmpa.fnewid from t_fabalance carditem,
#tmpa where #tmpa.foldid=carditem.fbalid update t_identity set fnext=(select max(fnewid)+1 from #tmpa) where fname='t_fabalance' drop table #tmpa --更新完毕,启用约束ALTER TABLE t_fabalcarditem CHECK CONSTRAINT FK_t_FABalCardItem_t_FABalance ALTER TABLE t_fabalcard CHECK CONSTRAINT FK_t_FABalCard_t_FABalance ALTER TABLE t_fabaldevice CHECK CONSTRAINT FK_t_FABaldevice_t_FABalance ALTER TABLE t_fabalorgfor CHECK CONSTRAINT FK_t_FABalorgfor_t_FABalance ALTER TABLE t_fabaldept CHECK CONSTRAINT FK_t_FABaldept_t_FABalance ALTER TABLE t_fabalexpense CHECK CONSTRAINT FK_t_FABalexpense_t_FABalance --完毕调整后即可正常结账。