| 问题现象： | 客户的固定资产是由安易311升级过来的，今年初升级过来时没有发现有错误，现在发现有如下固定资产卡片已计提折旧月份有错误：02338,02339,02340,02341,02342,02343,02344,02345,02017,02018,02019,02020,02021, 02022,02023,02024,02025,02026,02027,02028,02030,02030,02037,02043,02044,02045,应把已计提折旧月份改为11个月，02013,02014,02015,02016,02031,02032应把已计提折旧月份改为0个月，02033,02034,02046,02047,02048,02049,02050,02051,02052,02053,02054,02055,02056,02057, 02058,02059,02060,02061,02062,02063,02064,02065,02066,02067,02068,02069,02070,02071, 02072,02073,02074,02075,02076,02077,02078,02079,02080,02081,02082,02083,02084,02085, 02086,02087,02088,02089,02090,02091,02092,02093,02094,02095,02096,02097,02098,02100, 02101,02102,02103,02104,02148,02526, 应把已计提折旧月份改为6个月，02434,02435,02436,02437应把已计提折旧月份改为41个月，02026应把已计提折旧月份改为14个月 |
| 问题原因： | 可使用如下脚本解决折旧月份错误问题：DROP TABLE #YXKP CREATE TABLE #YXKP(sCardID varchar(20)) EXEC fa_Q_INSERT_YXKP '2004-11-01' update fa_DeprTransactions set fa_DeprTransactions.lDeprMonths10=(year('2004-11-01')- year(fa_Cards.dStartdate))*12 + (month('2004-11-01')- month(fa_Cards.dStartdate))-1 FROM (#YXKP INNER JOIN fa_Cards ON fa_Cards.sCardID = #YXKP.sCardID) INNER JOIN fa_DeprTransactions ON fa_Cards.sCardNum = fa_DeprTransactions.sCardNum WHERE (fa_Cards.dDisposeDate) Is Null AND fa_DeprTransactions.lDeprMonths1 < fa_Cards.lLife 请注意数据备份！ |
| 解决方案： | 可使用如下脚本解决折旧月份错误问题：DROP TABLE #YXKP CREATE TABLE #YXKP(sCardID varchar(20)) EXEC fa_Q_INSERT_YXKP '2004-11-01' update fa_DeprTransactions set fa_DeprTransactions.lDeprMonths10=(year('2004-11-01')- year(fa_Cards.dStartdate))*12 + (month('2004-11-01')- month(fa_Cards.dStartdate))-1 FROM (#YXKP INNER JOIN fa_Cards ON fa_Cards.sCardID = #YXKP.sCardID) INNER JOIN fa_DeprTransactions ON fa_Cards.sCardNum = fa_DeprTransactions.sCardNum WHERE (fa_Cards.dDisposeDate) Is Null AND fa_DeprTransactions.lDeprMonths1 < fa_Cards.lLife 请注意数据备份！ |
| 相关补丁： | |
| 版本： | 8.52 |
| 模块： | 固定资产 |
| 产品： | U852--财务会计--固定资产 |
| 问题名称： | 折旧月份错误 |
| 最后更新： | 2006-10-18 00:00:00 |