采购订单点击分组报错,提示字段名无效。
金蝶云社区-FBJ
FBJ
0人赞赏了该文章 1062次浏览 未经作者许可,禁止转载编辑于2016年10月09日 16:02:41

采购订单上付款条件勾上了支持分组,采购订单列表的订单分组是付款条件,在列表上点击分组的时候报错,提示无法绑定由多个部分组成的标识符 "t1.FPAYCONDITIONID"。
请问是什么原因?
6.1
9月29号补丁
谢谢


[{"operation":"PUR_PurchaseOrder_List.GetEntryData"}]
发生时间: 2016-10-09 03:58:36
错误编号: BOS_ExecuteReader
错误信息: 无法绑定由多个部分组成的标识符 "t1.FPAYCONDITIONID"。
Sql语句: SELECT * FROM (SELECT t0.FBILLNO fbillno, t0.FDATE fdate, t0.FSUPPLIERID fsupplierid_id, t0.FDOCUMENTSTATUS fdocumentstatus, t0.FPURCHASEORGID fpurchaseorgid_id, t0.FCLOSESTATUS fclosestatus, t3.FMATERIALID fmaterialid_id, t3.FUNITID funitid_id, t3.FQTY fqty, t3_D.FDELIVERYDATE fdeliverydate, t3_R.FSTOCKINQTY fstockinqty, t3.FGIVEAWAY fgiveaway, t3_R.FREMAINSTOCKINQTY fremainstockinqty, t3.FMRPCLOSESTATUS fmrpclosestatus, t0.FBILLTYPEID fbilltypeid, t0.FPURCHASEORGID fpurchaseorgid, t0.FOBJECTTYPEID fobjecttypeid, t0.FID fid, t3.FENTRYID t3_fentryid, t3.FSeq t3_fseq, ROW_NUMBER() OVER( ORDER BY t0.FCREATEDATE DESC, t0.FBILLNO DESC, t3.FSeq ASC) fidentityid FROM t_PUR_POOrder t0 LEFT OUTER JOIN t_PUR_POOrderEntry t3 ON t0.FID = t3.FID LEFT OUTER JOIN t_PUR_POOrderEntry_D t3_D ON t3.FENTRYID = t3_D.FENTRYID LEFT OUTER JOIN t_PUR_POOrderEntry_R t3_R ON t3.FENTRYID = t3_R.FENTRYID WHERE (t0.FPURCHASEORGID IN (1, 100088, 100089, 100090, 100091, 208911, 208912, 208913, 208914, 208915, 208916, 1739474) AND ((t0.FPURCHASEORGID IN (100091, 0) AND t0.FOBJECTTYPEID = 'PUR_PurchaseOrder') AND t1.FPAYCONDITIONID = '20002'))) tlist WHERE ((fidentityid >= 1) AND (fidentityid <= 200)) OPTION ( MAXDOP 0)
===================================================
调用堆栈:

Server stack trace:
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteReader(DbCommand command, IEnumerable`1 paramList, CommandBehavior cmdBehavior, Boolean bNewCn)
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteReader(DbCommand command, IEnumerable`1 paramList, CommandBehavior cmdBehavior)
at Kingdee.BOS.App.Data.DBUtils.ExecuteReader(Context ctx, String strSQL, IEnumerable`1 paramList, CommandType cmdtype, CommandBehavior cmdBehavior, Boolean bNewCn)
at Kingdee.BOS.App.Data.DBUtils.ExecuteReader(Context ctx, String strSQL, IEnumerable`1 paramList, CommandType cmdtype, CommandBehavior cmdBehavior)
at Kingdee.BOS.App.Data.DBUtils.ExecuteObject[T](Context ctx, String strSQL, IDataEntityType dt, IDictionary`2 propertyTypeMaps, CommandType cmdType, SqlParam[] paramList)
at Kingdee.BOS.App.Data.DBUtils.ExecuteDynamicObject(Context ctx, String strSQL, IDataEntityType dt, IDictionary`2 propertyTypeMaps, CommandType cmdType, SqlParam[] paramList)
at Kingdee.BOS.App.Core.ListDataService.GetData(Context ctx, String sql, DynamicObjectType dt, List`1 sqlParams)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Kingdee.BOS.Contracts.IListDataServices.GetData(Context ctx, String sql, DynamicObjectType dt, List`1 sqlParams)
at Kingdee.BOS.ServiceHelper.ListDataServiceHelper.GetData(Context ctx, String sql, DynamicObjectType dt, List`1 sqlParams)
at Kingdee.BOS.Model.List.DataAccessPolicy.DirectSQLDataAccessTreeList.GetTreeListData(Int32 start, Int32 rows, FormGroup group, String groupAliasName, Boolean displayChildData)
at Kingdee.BOS.Model.List.TreeListModel.GetDataByDirectSQL(Int32 start, Int32 rows)
at Kingdee.BOS.Model.List.ListModel.GetData(Int32 start, Int32 rows, Boolean needRefreshTree)
at Kingdee.BOS.Web.List.ListView.PrepareDatas(Int32 startRow, Int32& limit, FormOperationEnum operatioEnum, String groupRows, String permissionItemId, JSONObject data)
at Kingdee.BOS.Web.List.ListView.GetDataByPermission(Int32 startRow, Int32 limit, FormOperationEnum operatioEnum, String groupRows, String permissionItemId, DynamicObjectCollection pageDatas)
at Kingdee.BOS.Web.List.ListView.GetData(Int32 startRow, Int32 limit, String groupRows)
at Kingdee.BOS.Web.List.ListView.GetEntryData(String key, Int32 start, Int32 limit, String groupRows)
at Kingdee.BOS.Web.DynamicForm.DynamicWebFormController.GetEntryData(String key, Int32 start, Int32 limit, String groupRows)