即时库存快捷过滤按照二开字段搜索报错
金蝶云社区-永不回头
永不回头
0人赞赏了该文章 851次浏览 未经作者许可,禁止转载编辑于2016年10月25日 16:17:45

在即时库存报表中增加了二开字段,目前可正常实现,但是在快捷过滤界面根据二开字段搜索时系统报错,图片及详细错误信息如下:


[{"operation":"STK_InvSumQuery_List.ToolBarItemClick"}]
发生时间: 2016-10-25 04:15:47
错误编号: ExecuteBatch
错误信息: 列名 'F_PAEZ_U001BM' 无效。
列名 'F_PAEZ_U001BM' 无效。
Sql语句: SELECT t0.FQTY As FQTY,t0.FSTOCKUNITID As FSTOCKUNITID,t0.FBASEUNITID As FBASEUNITID,t0.FBASEQTY As FBASEQTY,t0.FSECQTY As FSECQTY,t0.FSECUNITID As FSECUNITID,t0.FLOCKQTY As FLOCKQTY,t0.FBASELOCKQTY As FBASELOCKQTY,t0.FSECLOCKQTY As FSECLOCKQTY,t0.FAVBQTY As FAVBQTY,t0.FBASEAVBQTY As FBASEAVBQTY,t0.FSECAVBQTY As FSECAVBQTY,t0.FMATERIALID As FMATERIALID,t0.FSTOCKID As FSTOCKID,t0.FLOT As FLOT,t0.FSTOCKORGID As FSTOCKORGID,st014.FPRECISION As FStockUnitId_FPrecision,t0.FOBJECTTYPEID As FOBJECTTYPEID,t0.FID As FID,ROW_NUMBER() OVER(ORDER BY t0.FID ) fidentityid INTO TMP35799CC69A8B11E6A1940050569

FROM T_STK_INVENTORY t0 LEFT JOIN
T_BD_UNIT st014 ON (t0.FSTOCKUNITID=st014.FUNITID)
WHERE (((((t0.FSTOCKORGID = 0 OR (t0.FSTOCKORGID IN (1) AND t0.FSTOCKORGID = 1)) AND (F_PAEZ_U001BM LIKE '%cpa1403%')) AND ((t0.FBASEQTY <> 0) OR (t0.FSECQTY <> 0))) AND (F_PAEZ_U001BM LIKE '%cpa1403%')))
AND
t0.FOBJECTTYPEID = 'STK_Inventory'
CREATE INDEX IDX_TMP35799CC69A ON TMP35799CC69A8B11E6A1940050569(fidentityid)
CREATE INDEX IDX_TMP35799CC69A_Pk ON TMP35799CC69A8B11E6A1940050569(FID)
DELETE FROM TMP35799CC69A8B11E6A1940050569 WHERE EXISTS(SELECT 1 FROM T_BD_LOTMASTER T1 INNER JOIN T_STK_INVENTORY T2 ON T1.FLOTID = T2.FLOT WHERE T1.FCANCELSTATUS = 'B' AND TMP35799CC69A8B11E6A1940050569.FID = T2.FID )

===================================================
调用堆栈:
at Kingdee.BOS.App.Data.Sql.SqlDatabase.ExecuteBatch(List`1 sqlArray, Int32 batchSize, Int32 commandTimeout)
at Kingdee.BOS.App.Data.DBUtils.ExecuteBatch(Context ctx, List`1 sqlArray, Int32 batchSize)
at Kingdee.K3.SCM.App.Core.StockInvService.FillInvSumQueryData(Context ctx, Dictionary`2 para)
at Kingdee.K3.SCM.ServiceHelper.StockServiceHelper.FillInvSumQueryData(Context ctx, Dictionary`2 para)
at Kingdee.K3.SCM.Stock.Business.PlugIn.InvSumQueryList.BuildSumVewData(String queryFilter, Int32 maxRowCount)
at Kingdee.K3.SCM.Stock.Business.PlugIn.InvSumQueryList.PrepareFilterParameter(FilterArgs e)
at Kingdee.BOS.Core.List.PlugIn.ListModelPlugInProxy.FirePrepareFilterParameter(FilterArgs e)
at Kingdee.BOS.Model.List.ListModel.CreateSqlBuilderParameter()
at Kingdee.BOS.Model.List.ListModel.CreateSqlBuilder()
at Kingdee.BOS.Web.List.ListView.OnRefreshByFilter()
at Kingdee.BOS.Web.DynamicForm.AbstractDynamicWebFormView.RefreshByFilter()
at Kingdee.BOS.Web.List.ListView.RefreshByFilterScheme()
at Kingdee.BOS.Web.List.ListView.Search()
at Kingdee.BOS.Web.DynamicForm.DynamicWebFormController.ToolBarItemClick(String barName, String itemKey, JSONArray postDatas)