科目期初余額錄入一級(jí)科目不等于二級(jí)科目之和

【解決方案】

AA_ParentAccount數(shù)據(jù)不全,末級(jí)科目在AA_ParentAccount表中不存在上下級(jí)關(guān)系

備份好賬套數(shù)據(jù)，執(zhí)行腳本：

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