如大家所說是accinformation表最新會計(jì)日期有誤
補(bǔ)充一下, 我進(jìn)入了數(shù)據(jù)庫找出accinformation這個表, 修改了最新會計(jì)日期(dWritableDate)的日期, 改為'2013-01-01'
月末結(jié)賬就出來了
原因分析：判斷是固定資產(chǎn)結(jié)帳標(biāo)志的問題發(fā)現(xiàn)在accinformation表中的記錄有問題dWritableDate的值和iLastPeriod的值不一致，正常應(yīng)該是2010－08－01和8問題解答：執(zhí)行以下語句可以解決：--Update accinformation set ilastperiod=8 where ccaption ='最新會計(jì)期間'Update accinformation set cValue=(select max(iperiod) from gl_mend where bflag_fa=1) where ccaption ='最新會計(jì)期間',cname=ilastperiod
select * from GL_mend where iYPeriod=202106
update GL_mend set bflag_FA=0 where iYPeriod=202106
select * from AccInformation where cSysID='FA' AND cCaption='最新會計(jì)日期'
select * from AccInformation where cSysID='FA' AND cname='ilastperiod'
update AccInformation set cvalue=6 where cSysID='FA' AND cname='ilastperiod'
update AccInformation set cValue='2021-06-01' where cSysID='FA' AND cCaption='最新會計(jì)日期'
delete from UFSystem..UA_Task
