用友T6-企业管理软件V6.2折旧问题

固定资产2016年提完折旧查询折旧表时，累计折旧和本月折旧额是相同的值，有4张卡片在2016年已经提完折旧了，但是在2017年1月份又有折旧产生

请使用脚本，更正固定资产卡片累计折旧信息 

update dbo.fa_DeprTransactions set dblperioddeprtotal=43730.4 where scardnum='00013' update dbo.fa_DeprTransactions set dbldeprt0=43730.4 where scardnum='00013' update fa_cards set dbldecdeprt=43730.4 where scardnum='00013' update fa_cards_detail set dbldecdeprt=43730.4 where scardnum='00013' update dbo.fa_DeprTransactions set dbldeprT1=43730.4,dbldepr1=0 where scardnum='00013' update dbo.fa_DeprTransactions_detail set dbldeprT1=43730.4,dbldepr1=0 where scardnum='00013' update fa_cards set dbldecdeprt=40717 where scardnum='00014' update fa_cards_detail set dbldecdeprt=40717 where scardnum='00014' update dbo.fa_DeprTransactions set dbldeprT1=40717,dbldepr1=0 where scardnum='00014' update dbo.fa_DeprTransactions_detail set dbldeprT1=40717,dbldepr1=0 where scardnum='00014' update dbo.fa_DeprTransactions set dblperioddeprtotal=40717 where scardnum='00014' update dbo.fa_DeprTransactions set dbldeprt0=40717 where scardnum='00014' update fa_cards set dbldecdeprt=112040.15 where scardnum='00015' update fa_cards_detail set dbldecdeprt=112040.15 where scardnum='00015' update dbo.fa_DeprTransactions set dbldeprT1=112040.15,dbldepr1=0 where scardnum='00015' update dbo.fa_DeprTransactions_detail set dbldeprT1=112040.15,dbldepr1=0 where scardnum='00015' update dbo.fa_DeprTransactions set dblperioddeprtotal=112040.15 where scardnum='00015' update dbo.fa_DeprTransactions set dbldeprt0=112040.15 where scardnum='00015' update fa_cards set dbldecdeprt=1968609.95 where scardnum='00016' update fa_cards_detail set dbldecdeprt=1968609.95 where scardnum='00016' update dbo.fa_DeprTransactions set dbldeprT1=1968609.95,dbldepr1=0 where scardnum='00016' update dbo.fa_DeprTransactions_detail set dbldeprT1=1968609.95,dbldepr1=0 where scardnum='00016' update dbo.fa_DeprTransactions set dblperioddeprtotal=1968609.95 where scardnum='00016' update dbo.fa_DeprTransactions set dbldeprt0=1968609.95 where scardnum='00016'

经验证，2016年反结账到11月，然后11月计提折旧，然后结账到12月，计提折旧，正常。 与您沟通，您选择重新年结。