T+专属云15.0 总账科目余额表联查明细账为空

问题回复：

1、备份账套；

2、用下面脚本修复 DECLARE @ID INT DECLARE @YEAR INT SET @YEAR=2020 DECLARE CUR CURSOR FOR SELECT id FROM AA_Account WHERE accountingyear=@YEAR OPEN CUR FETCH NEXT FROM CUR INTO @ID WHILE @@FETCH_STATUS=0 BEGIN IF NOT EXISTS(SELECT* FROM dbo.AA_AccountAssociation WHERE currentaccountingyear=@YEAR AND idpreaccountDTO=@ID) INSERT INTO AA_AccountAssociation(currentaccountingyear,preaccountingyear,idcurrentaccountDTO,idpreaccountDTO) SELECT @YEAR,@YEAR,@ID,@ID FETCH NEXT FROM CUR INTO @ID END CLOSE CUR DEALLOCATE CUR