【问题描述】

旗舰版打开折旧明细表，提示：名称或代码在系统中已被使用。

【原因分析】

原因：升级过程中固定资产模块备份的表没有删除

【解决方案】

可参考以下脚本执行处理：

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID('t_faalterBackUp') AND type in ('U'))

DROP TABLE t_faalterBackUp

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID('t_fabalanceBackUp') AND type in ('U'))

DROP TABLE t_fabalanceBackUp

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID('t_FACardBackUp') AND type in ('U'))

DROP TABLE t_FACardBackUp

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID('t_fabalcardBackUp') AND type in ('U'))

DROP TABLE t_fabalcardBackUp

【注意事项】

正式账套执行脚本前请先做好备份，建议待在测试账套中核实无误后再在正式账套中执行。