科目期初余额录入一级科目不等于二级科目之和

【解决方案】

   AA_ParentAccount数据不全,末级科目在AA_ParentAccount表中不存在上下级关系

备份好账套数据，执行脚本：

truncate table AA_ParentAccount

insert into AA_ParentAccount (idParent,idSon,Depth,isEndNode)

select p.id as idParent,s.id as idSon,p.depth-1 as Depth,p.IsEndNode as isEndNode from AA_Account p

left join AA_Account s

on s.code like p.code+'%' and s.isEndNode =1 and s.accountingyear=p.accountingyear

GO