预算数据查询报错
预算数据查询点过滤后报错,详见下文
INSERT INTO TM_BM_BUDGETVALUE (FYEAR, FPERIOD, FPERIODTYPE, FDEPTORGID, FORGTYPEID, FBUSINESSTYPEID, FDATATYPEID, FGROUPID, FCURRENCYID, FBWBCURRENCYID, FENTRYORGID, FVALUE, FBASEVALUE, FISADJUST, FADJUSTNUM) SELECT BV.FYEAR, BV.FPERIOD, BV.FPERIODTYPE, BV.FDEPTORGID, BV.FORGTYPEID, BV.FBUSINESSTYPE FBUSINESSTYPEID, BV.FDATATYPE FDATATYPEID, BV.FGROUPID, BV.FCURRENCYID, 0 FBWBCURRENCYID, BV.FENTRYORGID, SUM(BV.FVALUE) FVALUE, SUM(BV.FBASEVALUE) FBASEVALUE, '0' FISADJUST, 0 FADJUSTNUM FROM T_BM_BUDGETVALUE BV INNER JOIN T_BM_BUDGETORGENTRY ORG ON BV.FENTRYORGID = ORG.FBUDGETORGUNITID INNER JOIN T_BM_BUDGETORG BGORG ON ((BGORG.FISDEFAULT = '1' AND BGORG.FISDEFALUTVERSION = '1') AND BGORG.FID = ORG.FID) WHERE ((BV.FRPTSCHEMEID = :FRPTSCHEMEID AND BV.FSCHEMEID = :FSCHEMEID) AND ((((BV.FCURRENCYID IN (1)) AND (BV.FYEARPERIOD BETWEEN :FSTARTYEARPERIOD AND :FENDYEARPERIOD)) AND BV.FPERIODTYPE = :FPERIODTYPE) AND ((BV.FDATATYPE IN (12)) AND ((BV.FENTRYORGID IN (0, 131238)) AND EXISTS (SELECT 1 FROM T_BM_SHEET B INNER JOIN T_BM_REPORT C ON C.FID = B.FID WHERE (B.FSHEETID = BV.FID AND C.FDOCUMENTSTATUS = 'C')))))) GROUP BY BV.FYEAR, BV.FPERIOD, BV.FPERIODTYPE, BV.FDEPTORGID, BV.FORGTYPEID, BV.FBUSINESSTYPE, BV.FDATATYPE, BV.FGROUPID, BV.FCURRENCYID, BV.FENTRYORGID
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.BudgetDataReport.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()
at Kingdee.BOS.Web.Report.SysReportView.<>c__DisplayClass55.
我的qq:1573032651
预算数据查询报错
本文2024-09-16 18:24:24发表“云星空知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3cloud-21934.html