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

iufida

问题现象：科目余额表查询方案显示不正常。

                               
登录/注册后可看大图

                               
登录/注册后可看大图

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

                               
登录/注册后可看大图

                               
登录/注册后可看大图

解决方案：账套预置数据有问题了，执行附件的脚本来修复，个人方案中的系统方案，要删除重建
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