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 TMP3BE50938069811E68427F832E48 FROM (SELECT 105186 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, 4 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 LIKE '%1511%')) t ORDER BY FYEAR ASC, FPERIOD ASC, FDATE ASC, FDataType ASC, FENTRYSEQ ASC, FVCHGROUPID DESC, FVCHGROUPNO ASC
Server stack trace:
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
at Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1 paramList, Boolean needTranslate)
at Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL)
at Kingdee.K3.FIN.GL.App.Report.SubLedgerService.InsertDateToReportTempTable(String filter, String orderBy, DataRow dr, String tempTableName, String tableName)
at Kingdee.K3.FIN.GL.App.Report.SubLedgerService.GetMoveReportDate(IRptParams filter, DataRow dr, String tableName)
at Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.CreateTempTable(IRptParams filter, String tablename)
at Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetDataForVirtual(IRptParams filter)
at Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetListAndReportData(IRptParams filter)
at Kingdee.BOS.App.Core.PlugInProxy.SysReportServicePlugInProxy.GetListAndReportData(MoveReportServiceParameter parameter)
at Kingdee.BOS.App.Core.SysReportService.GetListAndReportData(MoveReportServiceParameter parameter)
明细分类账查询报错
K3cloud 6.0 打了4-8的补丁
麻烦老师们看看