折旧月份错误-用友U8

对应版本:用友U8.52对应产品线：财务系统对应模块：固定资产模块问题现象:客户的固定资产是由安易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个月问题原因：可使用如下脚本解决折旧月份错误问题：DROPTABLE#YXKPCREATETABLE#YXKP(sCardIDvarchar(20))EXECfa_Q_INSERT_YXKP’2004-11-01’updatefa_DeprTransactionssetfa_DeprTransactions.lDeprMonths10=(year(’2004-11-01’)-year(fa_Cards.dStartdate))*12+(month(’2004-11-01’)-month(fa_Cards.dStartdate))-1FROM(#YXKPINNERJOINfa_CardsONfa_Cards.sCardID=#YXKP.sCardID)INNERJOINfa_DeprTransactionsONfa_Cards.sCardNum=fa_DeprTransactions.sCardNumWHERE(fa_Cards.dDisposeDate)IsNullANDfa_DeprTransactions.lDeprMonths1解决方案：可使用如下脚本解决折旧月份错误问题：DROPTABLE#YXKPCREATETABLE#YXKP(sCardIDvarchar(20))EXECfa_Q_INSERT_YXKP’2004-11-01’updatefa_DeprTransactionssetfa_DeprTransactions.lDeprMonths10=(year(’2004-11-01’)-year(fa_Cards.dStartdate))*12+(month(’2004-11-01’)-month(fa_Cards.dStartdate))-1FROM(#YXKPINNERJOINfa_CardsONfa_Cards.sCardID=#YXKP.sCardID)INNERJOINfa_DeprTransactionsONfa_Cards.sCardNum=fa_DeprTransactions.sCardNumWHERE(fa_Cards.dDisposeDate)IsNullANDfa_DeprTransactions.lDeprMonths1

本文链接：https://www.bbsufida.com/u8/45993.html