如大家所说是accinformation表最新会计日期有误
补充一下, 我进入了数据库找出accinformation这个表, 修改了最新会计日期(dWritableDate)的日期, 改为'2013-01-01'
月末结账就出来了
原因分析:判断是固定资产结帐标志的问题发现在accinformation表中的记录有问题dWritableDate的值和iLastPeriod的值不一致,正常应该是2010-08-01和8问题解答:执行以下语句可以解决:--Update accinformation set ilastperiod=8 where ccaption ='最新会计期间'Update accinformation set cValue=(select max(iperiod) from gl_mend where bflag_fa=1) where ccaption ='最新会计期间',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='最新会计日期'
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='最新会计日期'
delete from UFSystem..UA_Task