2022-10-20 09:45:09
【解决方案】
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