打开即时库存报错,没有二开过
金蝶云社区-土豆
土豆
0人赞赏了该文章 745次浏览 未经作者许可,禁止转载编辑于2017年01月20日 11:06:24


[{"operation":"STK_InvSumQuery_List.LoadData"}]
发生时间: 2017-01-20 11:02:41
错误编号: BOS_ExecuteNonQuery
错误信息: 列名 'FStockName' 无效。
Sql语句: SELECT st04.FNUMBER fmaterialid_fnumber, st04_L.FNAME fmaterialname, st01_L.FNAME fstockname, t0.FSTOCKLOCID fstocklocid, st035.FNUMBER flot_fnumber, st032_L.FNAME fstockunitid_fname, t0.FQTY fqty, t0.FSTOCKORGID fstockorgid, t0.FSTOCKUNITID fstockunitid, t0.FBASEUNITID fbaseunitid, t0.FBASEQTY fbaseqty, t0.FSECQTY fsecqty, t0.FSECUNITID fsecunitid, t0.FLOCKQTY flockqty, t0.FBASELOCKQTY fbaselockqty, t0.FSECLOCKQTY fseclockqty, t0.FAVBQTY favbqty, t0.FBASEAVBQTY fbaseavbqty, t0.FSECAVBQTY fsecavbqty, t0.FMATERIALID fmaterialid, t0.FSTOCKID fstockid, t0.FLOT flot, st010.FNAME fstocklocid_2, st09.FNUMBER fstocklocid_3, st012.FNAME fstocklocid_5, st011.FNUMBER fstocklocid_6, st014.FNAME fstocklocid_8, st013.FNUMBER fstocklocid_9, st016.FNAME fstocklocid_11, st015.FNUMBER fstocklocid_12, st018.FNAME fstocklocid_14, st017.FNUMBER fstocklocid_15, st020.FNAME fstocklocid_17, st019.FNUMBER fstocklocid_18, st022.FNAME fstocklocid_20, st021.FNUMBER fstocklocid_21, st07.FOPCODE fstocklocid_22, st024.FNAME fstocklocid_24, st023.FNUMBER fstocklocid_25, st026.FNAME fstocklocid_27, st025.FNUMBER fstocklocid_28, st028.FNAME fstocklocid_30, st027.FNUMBER fstocklocid_31, st032.FPRECISION fstockunitid_fprecision, t0.FOBJECTTYPEID fobjecttypeid, t0.FID fid, ROW_NUMBER() OVER( ORDER BY t0.FID ASC) fidentityid INTO TMPE1E3642DDEBC11E68FF3E839352 FROM T_STK_INVENTORY t0 LEFT OUTER JOIN T_BD_MATERIAL_L st04_L ON (t0.FMATERIALID = st04_L.FMATERIALID AND st04_L.FLocaleId = 2052) LEFT OUTER JOIN T_BD_MATERIAL st04 ON t0.FMATERIALID = st04.FMATERIALID LEFT OUTER JOIN t_BD_Stock_L st01_L ON (t0.FSTOCKID = st01_L.FStockId AND st01_L.FLocaleId = 2052) LEFT OUTER JOIN T_BAS_FLEXVALUESDETAIL st07 ON t0.FSTOCKLOCID = st07.FID LEFT OUTER JOIN T_BAS_FLEXVALUESENTRY_L st010 ON (st07.FF100007 = st010.FEntryID AND st010.FLocaleId = 2052) LEFT OUTER JOIN T_BAS_FLEXVALUESENTRY st09 ON st07.FF100007 = st09.FEntryID LEFT OUTER JOIN T_BAS_FLEXVALUESENTRY_L st012 ON (st07.FF100006 = st012.FEntryID AND st012.FLocaleId = 2052) LEFT OUTER JOIN T_BAS_FLEXVALUESENTRY st011 ON st07.FF100006 = st011.FEntryID LEFT OUTER JOIN T_BAS_FLEXVALUESENTRY_L st014 ON (st07.FF100008 = st014.FEntryID AND st014.FLocaleId = 2052) LEFT OUTER JOIN T_BAS_FLEXVALUESENTRY st013 ON st07.FF100008 = st013.FEntryID LEFT OUTER JOIN T_BAS_FLEXVALUESENTRY_L st016 ON (st07.FF100010 = st016.FEntryID AND st016.FLocaleId = 2052) LEFT OUTER JOIN T_BAS_FLEXVALUESENTRY st015 ON st07.FF100010 = st015.FEntryID LEFT OUTER JOIN T_BAS_FLEXVALUESENTRY_L st018 ON (st07.FF100009 = st018.FEntryID AND st018.FLocaleId = 2052) LEFT OUTER JOIN T_BAS_FLEXVALUESENTRY st017 ON st07.FF100009 = st017.FEntryID LEFT OUTER JOIN T_BAS_FLEXVALUESENTRY_L st020 ON (st07.FF100005 = st020.FEntryID AND st020.FLocaleId = 2052) LEFT OUTER JOIN T_BAS_FLEXVALUESENTRY st019 ON st07.FF100005 = st019.FEntryID LEFT OUTER JOIN T_BAS_FLEXVALUESENTRY_L st022 ON (st07.FF100001 = st022.FEntryID AND st022.FLocaleId = 2052) LEFT OUTER JOIN T_BAS_FLEXVALUESENTRY st021 ON st07.FF100001 = st021.FEntryID LEFT OUTER JOIN T_BAS_FLEXVALUESENTRY_L st024 ON (st07.FF100002 = st024.FEntryID AND st024.FLocaleId = 2052) LEFT OUTER JOIN T_BAS_FLEXVALUESENTRY st023 ON st07.FF100002 = st023.FEntryID LEFT OUTER JOIN T_BAS_FLEXVALUESENTRY_L st026 ON (st07.FF100004 = st026.FEntryID AND st026.FLocaleId = 2052) LEFT OUTER JOIN T_BAS_FLEXVALUESENTRY st025 ON st07.FF100004 = st025.FEntryID LEFT OUTER JOIN T_BAS_FLEXVALUESENTRY_L st028 ON (st07.FF100003 = st028.FEntryID AND st028.FLocaleId = 2052) LEFT OUTER JOIN T_BAS_FLEXVALUESENTRY st027 ON st07.FF100003 = st027.FEntryID LEFT OUTER JOIN T_BD_UNIT_L st032_L ON (t0.FSTOCKUNITID = st032_L.FUNITID AND st032_L.FLocaleId = 2052) LEFT OUTER JOIN T_BD_UNIT st032 ON t0.FSTOCKUNITID = st032.FUNITID LEFT OUTER JOIN T_BD_LOTMASTER st035 ON t0.FLOT = st035.FLOTID WHERE ((((t0.FBASEQTY <> 0) OR (t0.FSECQTY <> 0)) AND (FSTOCKORGID = 0 OR (FSTOCKORGID IN (SELECT TOGS.FID FROM @FSelOrgID_udt1 TOGS) AND (FStockOrgId IN (1) AND (FStockName LIKE '%国内配料库%'))))) AND t0.FOBJECTTYPEID = 'STK_Inventory')
===================================================
调用堆栈:
在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
在 Kingdee.BOS.App.Data.DBUtils.ExecuteBatch(Context ctx, List`1 lstSqlObj)
在 Kingdee.K3.SCM.App.Core.StockInvService.FillInvSumQueryData(Context ctx, Dictionary`2 para)
在 Kingdee.K3.SCM.ServiceHelper.StockServiceHelper.FillInvSumQueryData(Context ctx, Dictionary`2 para)
在 Kingdee.K3.SCM.Stock.Business.PlugIn.InvSumQueryList.BuildSumVewData(String queryFilter, String orgFilter, Int32 maxRowCount)
在 Kingdee.K3.SCM.Stock.Business.PlugIn.InvSumQueryList.PrepareFilterParameter(FilterArgs e)
在 Kingdee.BOS.Core.List.PlugIn.ListModelPlugInProxy.FirePrepareFilterParameter(FilterArgs e)
在 Kingdee.BOS.Model.List.ListModel.CreateSqlBuilderParameter()
在 Kingdee.BOS.Model.List.ListModel.CreateSqlBuilder()
在 Kingdee.BOS.Web.List.ListView.ShowListFilter()
在 Kingdee.BOS.Web.List.ListView.LoadData()
在 Kingdee.BOS.Web.DynamicForm.DynamicWebFormController.LoadData()