预算数据查询报错

预算数据查询点过滤后报错,详见下文
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.AbstractSysReportS
预算数据查询报错
声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。如若本站内容侵犯了原著者的合法权益,可联系本站删除。



