预算数据查询报错

栏目:云星空知识作者:金蝶来源:金蝶云社区发布:2024-09-16浏览:2

预算数据查询报错

预算数据查询点过滤后报错,详见下文
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.b__51()


我的qq:1573032651

预算数据查询报错

预算数据查询点过滤后报错,详见下文INSERT INTO TM_BM_BUDGETVALUE (FYEAR, FPERIOD, FPERIODTYPE, FDEPTORGID, FORGTYPEID, FBUS...
点击下载文档
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息