明细账查询报“查询出现异常。列名 'FEXPLANATION' 不明确。”
金蝶云社区-求春
求春
0人赞赏了该文章 1,316次浏览 未经作者许可,禁止转载编辑于2016年04月22日 09:54:16

版本5.0打了4月14日补丁,最近财务查询明细分类账的时候,过滤条件里面加了一条 摘要不包含本日汇总,如下图


就会出现如下错误:


详细错误如下:
SELECT FCURRENTACCTID, FDataType, FVoucherID, FENTRYID, FACCTID, FYEAR, FPERIOD, FDATE, FCREATEDATE, FVCHGROUPID, FVCHGROUPNO, FEXPLANATION, FSETTLETYPEID, FSETTLENO, FSIDEACCTID, FSIDEBALANCEID, FSIDEBALANCENAME, FSIDEDETAILID, FSIDEDETAILNUMBER, FSIDEDETAILNAME, FINTERNALIND, FCURRENCY, FEXCHANGERATE, FAMOUNTFOR, FDEBIT, FDEBITFOR, FCREDIT, FCREDITFOR, FDC, FBALANCES, FBALANCESFOR, FAMOUNTDIGITS, FACCTBOOKFAMOUNTDIGITS, FRATETYPEAMOUNTDIGITS, FDATE fbakdate, FDetailID, 0 ffromvoucher, 'GL_VOUCHER' formid, ROW_NUMBER() OVER( ORDER BY FYEAR ASC, FPERIOD ASC, FDATE ASC, FDataType ASC, FENTRYSEQ ASC, FVCHGROUPID DESC, FVCHGROUPNO ASC) fidentityid INTO TMPF776097C082B11E684B66CAE8B7 FROM (SELECT 633125 fcurrentacctid, t.FDataType, t.FVoucherID, t.FENTRYID, t.FACCTID, t.FYEAR, t.FPERIOD, t.FDATE, t.FCREATEDATE, t.FDetailID, t.FVCHGROUPID, t.FVCHGROUPNO, t.FEXPLANATION, t.FSETTLETYPEID, t.FSETTLENO, t.FSIDEACCTID, t.FSIDEBALANCEID, t.FSIDEBALANCENAME, t.FSIDEDETAILID, t.FSIDEDETAILNUMBER, t.FSIDEDETAILNAME, t.FINTERNALIND, t.FCURRENCY, t.FEXCHANGERATE, t.FAMOUNTFOR, t.FDEBIT, t.FDEBITFOR, t.FCREDIT, t.FCREDITFOR, t.FDC, t.FBALANCES, t.FBALANCESFOR, t.FAMOUNTDIGITS, 2 facctbookfamountdigits, 10 fratetypeamountdigits, e.FENTRYSEQ FROM #TM_GL_VoucherDetailData t LEFT OUTER JOIN T_GL_VOUCHERENTRY e ON (t.FVOUCHERID = e.FVOUCHERID AND t.FENTRYID = e.FENTRYID) WHERE (FEXPLANATION NOT LIKE '%本日合计%')) t ORDER BY FYEAR ASC, FPERIOD ASC, FDATE ASC, FDataType ASC, FENTRYSEQ ASC, FVCHGROUPID DESC, FVCHGROUPNO ASC

Server stack trace:
在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
在 Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1 paramList, Boolean needTranslate)
在 Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL)
在 Kingdee.K3.FIN.GL.App.Report.SubLedgerService.InsertDateToReportTempTable(String filter, String orderBy, DataRow dr, String tempTableName, String tableName)
在 Kingdee.K3.FIN.GL.App.Report.SubLedgerService.GetMoveReportDate(IRptParams filter, DataRow dr, String tableName)
在 Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.CreateTempTable(IRptParams filter, String tablename)
在 Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetDataForVirtual(IRptParams filter)
在 Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetListAndReportData(IRptParams filter)
在 Kingdee.BOS.App.Core.PlugInProxy.SysReportServicePlugInProxy.GetListAndReportData(MoveReportServiceParameter parameter)
在 Kingdee.BOS.App.Core.SysReportService.GetListAndReportData(MoveReportServiceParameter parameter)

Exception rethrown at [0]:
在 System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
在 System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
在 Kingdee.BOS.Contracts.ISysReportService.GetListAndReportData(MoveReportServiceParameter parameter)
在 Kingdee.BOS.ServiceHelper.SysReportServiceHelper.GetListAndReportData(MoveReportServiceParameter parameter)
在 Kingdee.BOS.Model.Report.MoveReportModel.GetData(Int32 start, Int32 rows)
在 Kingdee.BOS.Web.Report.SysReportView.GetListData()
在 Kingdee.BOS.Web.Report.SysReportView.<>c__DisplayClass3d.b__39()