预算报表打开报错
版本: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()
lzqq?
打开预算分析报表报错:
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()
lzqq?
预算报表打开报错
版本:cloud 6.2 最新补丁打开预算分析报表报错:INSERT INTO #TM_BM_BUDGETBILLUSED (FFORMID, FBILLID, FBILLNO, FDOCUMEN...
点击下载文档
本文2024-09-16 18:24:13发表“云星空知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3cloud-21911.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章