预算报表打开报错
JLing
734次浏览
编辑于2017年05月22日 09:06:43
版本：cloud 6.2 最新补丁
打开预算分析报表报错：
INSERT INTO #TM_BM_BUDGETBILLUSED (FFORMID, FBILLID, FBILLNO, FDOCUMENTSTATUS, FORGID, FDEPTID, FBILLDATE, FCTRLTIME, FDATATYPEID, FUSEDVALUE, FBACKVALUE) SELECT 'ER_ExpReimbursement' fformid, t0.FID, t0.FBILLNO, t0.FDOCUMENTSTATUS, t0.FEXPENSEORGID, t1.FEXPENSEDEPTENTRYID, t0.FDATE, 2 fctrltime, 12 fdatatypeid, t1.FEXPSUBMITAMOUNT, 0 fbackvalue FROM t_ER_ExpenseReimb t0 LEFT OUTER JOIN t_ER_ExpenseReimbEntry t1 ON t0.FID = t1.FID WHERE ((((((t0.FEXPENSEORGID = 1 AND (t0.FDATE >= '2017-01-01 00:00:00')) AND (t0.FDATE <= '2017-01-31 00:00:00')) AND t0.FDOCUMENTSTATUS IN ('B', 'C')) AND t0.FLOCCURRENCYID = 1) AND (t1.FEXPID IN (20137, 20138, 20139, 20140, 20141, 20142) AND (t0.FEXPENSEDEPTID IN (100067, 100068, 100069, 100070) AND FIsBorrow = '1'))) AND t0.FFORMID = 'ER_ExpReimbursement')
Server stack trace:
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
at Kingdee.BOS.App.Data.DBUtils.ExecuteBatch(Context ctx, List`1 lstSqlObj)
at Kingdee.K3.FIN.BM.App.Report.BudgetExecutionReport.GetBudgetUsedTable()
at Kingdee.K3.FIN.BM.App.Report.BudgetExecutionReport.GetReportTempData(IRptParams filter, 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.GetData(IRptParams filter)
at Kingdee.BOS.App.Core.PlugInProxy.SysReportServicePlugInProxy.GetReportData(ReportServiceParameter parameter)
at Kingdee.BOS.App.Core.SysReportService.GetReportData(ReportServiceParameter parameter)
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.ISysReportService.GetReportData(ReportServiceParameter parameter)
at Kingdee.BOS.ServiceHelper.SysReportServiceHelper.GetReportData(ReportServiceParameter parameter)
at Kingdee.BOS.Model.Report.SysReportModel.GetData(Int32 start, Int32 rows)
at Kingdee.BOS.Web.Report.SysReportView.GetListData()
打开预算分析报表报错：
INSERT INTO #TM_BM_BUDGETBILLUSED (FFORMID, FBILLID, FBILLNO, FDOCUMENTSTATUS, FORGID, FDEPTID, FBILLDATE, FCTRLTIME, FDATATYPEID, FUSEDVALUE, FBACKVALUE) SELECT 'ER_ExpReimbursement' fformid, t0.FID, t0.FBILLNO, t0.FDOCUMENTSTATUS, t0.FEXPENSEORGID, t1.FEXPENSEDEPTENTRYID, t0.FDATE, 2 fctrltime, 12 fdatatypeid, t1.FEXPSUBMITAMOUNT, 0 fbackvalue FROM t_ER_ExpenseReimb t0 LEFT OUTER JOIN t_ER_ExpenseReimbEntry t1 ON t0.FID = t1.FID WHERE ((((((t0.FEXPENSEORGID = 1 AND (t0.FDATE >= '2017-01-01 00:00:00')) AND (t0.FDATE <= '2017-01-31 00:00:00')) AND t0.FDOCUMENTSTATUS IN ('B', 'C')) AND t0.FLOCCURRENCYID = 1) AND (t1.FEXPID IN (20137, 20138, 20139, 20140, 20141, 20142) AND (t0.FEXPENSEDEPTID IN (100067, 100068, 100069, 100070) AND FIsBorrow = '1'))) AND t0.FFORMID = 'ER_ExpReimbursement')
Server stack trace:
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
at Kingdee.BOS.App.Data.DBUtils.ExecuteBatch(Context ctx, List`1 lstSqlObj)
at Kingdee.K3.FIN.BM.App.Report.BudgetExecutionReport.GetBudgetUsedTable()
at Kingdee.K3.FIN.BM.App.Report.BudgetExecutionReport.GetReportTempData(IRptParams filter, 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.GetData(IRptParams filter)
at Kingdee.BOS.App.Core.PlugInProxy.SysReportServicePlugInProxy.GetReportData(ReportServiceParameter parameter)
at Kingdee.BOS.App.Core.SysReportService.GetReportData(ReportServiceParameter parameter)
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.ISysReportService.GetReportData(ReportServiceParameter parameter)
at Kingdee.BOS.ServiceHelper.SysReportServiceHelper.GetReportData(ReportServiceParameter parameter)
at Kingdee.BOS.Model.Report.SysReportModel.GetData(Int32 start, Int32 rows)
at Kingdee.BOS.Web.Report.SysReportView.GetListData()