T+余额表中查询条件辅助项只有存货其他的不显示

问题现象：

科目余额表查询方案显示不正常。

问题分析：

查看科目档案和基础档案设置没有问题

解决方案：

账套预置数据有问题了，执行附件的脚本来修复，个人方案中的系统方案，要删除重建

DELETE FROM EAP_SearchPlanItem_Ext WHERE PlanId =919 AND SearchItemId IN(20978,20979,20980,20981);

INSERT INTO eap_searchplanitem_ext([OrderNum],[BeginValue],[EndValue],[BeginText],[EndText],[IsControlPermission],[IsControlFieldPermission],[Selected],[CompareSign],[ExpressionName],[CreatedTime],[SearchItemId],[planid],[ItemType],[MatchMode],[IsSimpleSearchItem])

SELECT 8,'','','','',0,0,0, null, null,GETDATE(),20978,919, null, null, NULL

INSERT INTO eap_searchplanitem_ext([OrderNum],[BeginValue],[EndValue],[BeginText],[EndText],[IsControlPermission],[IsControlFieldPermission],[Selected],[CompareSign],[ExpressionName],[CreatedTime],[SearchItemId],[planid],[ItemType],[MatchMode],[IsSimpleSearchItem])

SELECT 7,'','','','',0,0,0, null, null,GETDATE(),20979,919, null, null, NULL

INSERT INTO eap_searchplanitem_ext([OrderNum],[BeginValue],[EndValue],[BeginText],[EndText],[IsControlPermission],[IsControlFieldPermission],[Selected],[CompareSign],[ExpressionName],[CreatedTime],[SearchItemId],[planid],[ItemType],[MatchMode],[IsSimpleSearchItem])

SELECT 6,'','','','',0,0,0, null, null,GETDATE(),20980,919, null, null, NULL

INSERT INTO eap_searchplanitem_ext([OrderNum],[BeginValue],[EndValue],[BeginText],[EndText],[IsControlPermission],[IsControlFieldPermission],[Selected],[CompareSign],[ExpressionName],[CreatedTime],[SearchItemId],[planid],[ItemType],[MatchMode],[IsSimpleSearchItem])

SELECT 10,'','','','',0,0,0, null, null,GETDATE(),20981,919, null, null, null