固定資產(chǎn)2016年提完折舊查詢折舊表時，累計折舊和本月折舊額是相同的值，有4張卡片在2016年已經(jīng)提完折舊了，但是在2017年1月份又有折舊產(chǎn)生

請使用腳本，更正固定資產(chǎn)卡片累計折舊信息 

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'

經(jīng)驗證，2016年反結(jié)賬到11月，然后11月計提折舊，然后結(jié)賬到12月，計提折舊，正常。 與您溝通，您選擇重新年結(jié)。