CLOUD 6.0查询副明细分类账报错查询出现异常。列名 'FYEARPERI...
751次浏览
编辑于2016年01月31日 21:35:45
CLOUD 6.0查询副明细分类账报错查询出现异常。
查询出现异常。列名 'FYEARPERIOD' 无效。
列名 'FYEARPERIOD' 无效。
INSERT INTO TMP1617B853C81F11E5B5BB44A8424 (FACCOUNTBOOKID, FYEAR, FPERIOD, FACCOUNTID, FDETAILID, FCURRENCYID, FBEGINBALANCEFOR, FBEGINBALANCE, FDEBITFOR, FDEBIT, FCREDITFOR, FCREDIT, FYTDDEBITFOR, FYTDDEBIT, FYTDCREDITFOR, FYTDCREDIT, FENDBALANCEFOR, FENDBALANCE, FADJUSTPERIOD) SELECT FACCOUNTBOOKID, FYear, FPeriod, FAccountID, FDetailID, FCurrencyID, FBeginBalanceFor, FBeginBalance, FDebitFor, FDebit, FCreditFor, FCredit, FDebitFor fytddebitfor, FDebit fytddebit, FCreditFor fytdcreditfor, FCredit fytdcredit, (FDebitFor - FCreditFor) fendbalancefor, (FDebit - FCredit) fendbalance, 0 fadjustperiod FROM T_GL_BALANCE_120458 WHERE ((FACCOUNTBOOKID = 120458 AND (FYEARPERIOD >= 201601)) AND (FYEARPERIOD <= 201601))
Server stack trace:
在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
在 Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1 paramList, Boolean needTranslate)
在 Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL)
在 Kingdee.K3.FIN.App.Core.VoucherService.BalanceReportService.GetBalaceDataNotPost(Context ctx, VoucherPostParameters postParam, String balanceTempTable, Int32 endDateNum, Int32 currDateNum, DynamicObject accountBookObject)
在 Kingdee.K3.FIN.App.Core.VoucherService.BalanceReportService.GetBalanceData(Context ctx, VoucherPostParameters postParam)
在 Kingdee.K3.FIN.GL.App.Report.SubLedgerService.SetBalanceTable()
在 Kingdee.K3.FIN.GL.App.Report.SubLedgerService.GetList(IRptParams filter)
在 Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetListAndReportData(IRptParams filter)
在 Kingdee.BOS.App.Core.PlugInProxy.SysReportServicePlugInProxy.GetListAndReportData(MoveReportServiceParameter parameter)
在 Kingdee.BOS.App.Core.SysReportService.GetListAndReportData(MoveReportServiceParameter parameter)
Exception rethrown at [0]:
在 System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
在 System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
在 Kingdee.BOS.Contracts.ISysReportService.GetListAndReportData(MoveReportServiceParameter parameter)
在 Kingdee.BOS.ServiceHelper.SysReportServiceHelper.GetListAndReportData(MoveReportServiceParameter parameter)
在 Kingdee.BOS.Model.Report.MoveReportModel.GetData(Int32 start, Int32 rows)
在 Kingdee.BOS.Web.Report.SysReportView.GetListData()
在 Kingdee.BOS.Web.Report.SysReportView.<>c__DisplayClass3d.b__39()
查询出现异常。列名 'FYEARPERIOD' 无效。
列名 'FYEARPERIOD' 无效。
INSERT INTO TMP1617B853C81F11E5B5BB44A8424 (FACCOUNTBOOKID, FYEAR, FPERIOD, FACCOUNTID, FDETAILID, FCURRENCYID, FBEGINBALANCEFOR, FBEGINBALANCE, FDEBITFOR, FDEBIT, FCREDITFOR, FCREDIT, FYTDDEBITFOR, FYTDDEBIT, FYTDCREDITFOR, FYTDCREDIT, FENDBALANCEFOR, FENDBALANCE, FADJUSTPERIOD) SELECT FACCOUNTBOOKID, FYear, FPeriod, FAccountID, FDetailID, FCurrencyID, FBeginBalanceFor, FBeginBalance, FDebitFor, FDebit, FCreditFor, FCredit, FDebitFor fytddebitfor, FDebit fytddebit, FCreditFor fytdcreditfor, FCredit fytdcredit, (FDebitFor - FCreditFor) fendbalancefor, (FDebit - FCredit) fendbalance, 0 fadjustperiod FROM T_GL_BALANCE_120458 WHERE ((FACCOUNTBOOKID = 120458 AND (FYEARPERIOD >= 201601)) AND (FYEARPERIOD <= 201601))
Server stack trace:
在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
在 Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1 paramList, Boolean needTranslate)
在 Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL)
在 Kingdee.K3.FIN.App.Core.VoucherService.BalanceReportService.GetBalaceDataNotPost(Context ctx, VoucherPostParameters postParam, String balanceTempTable, Int32 endDateNum, Int32 currDateNum, DynamicObject accountBookObject)
在 Kingdee.K3.FIN.App.Core.VoucherService.BalanceReportService.GetBalanceData(Context ctx, VoucherPostParameters postParam)
在 Kingdee.K3.FIN.GL.App.Report.SubLedgerService.SetBalanceTable()
在 Kingdee.K3.FIN.GL.App.Report.SubLedgerService.GetList(IRptParams filter)
在 Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetListAndReportData(IRptParams filter)
在 Kingdee.BOS.App.Core.PlugInProxy.SysReportServicePlugInProxy.GetListAndReportData(MoveReportServiceParameter parameter)
在 Kingdee.BOS.App.Core.SysReportService.GetListAndReportData(MoveReportServiceParameter parameter)
Exception rethrown at [0]:
在 System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
在 System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
在 Kingdee.BOS.Contracts.ISysReportService.GetListAndReportData(MoveReportServiceParameter parameter)
在 Kingdee.BOS.ServiceHelper.SysReportServiceHelper.GetListAndReportData(MoveReportServiceParameter parameter)
在 Kingdee.BOS.Model.Report.MoveReportModel.GetData(Int32 start, Int32 rows)
在 Kingdee.BOS.Web.Report.SysReportView.GetListData()
在 Kingdee.BOS.Web.Report.SysReportView.<>c__DisplayClass3d.
推荐阅读