在做科目数据录入时会出现这个问题,
金蝶云社区-aderchen
aderchen
0人赞赏了该文章 495次浏览 未经作者许可,禁止转载编辑于2015年07月02日 15:47:05

[{"operation":"GL_InitBalance.LoadData"}]
发生时间: 2015-07-02 03:49:53
错误编号: BOS_ExecuteReader
错误信息: 列名 'FISPROFIT' 无效。
列名 'FISPROFIT' 无效。
Sql语句: SELECT CASE WHEN g.FAccountType = 'BW' THEN '1' ELSE '0' END fexclude, g.FISPROFIT fprofitandloss, acct.FAcctId, acct.FNumber, acct.FIsDetail, acct.fforbidderid FROM T_BD_ACCOUNT acct INNER JOIN T_BD_ACCOUNTTYPE t ON acct.fgroupid = t.faccttypeid INNER JOIN T_BD_ACCOUNTGROUP g ON g.facctgroupid = t.facctgroupid INNER JOIN T_BD_ACCOUNTBOOK book ON book.faccttableid = acct.faccttblid WHERE ((book.fbookid = @fbookid AND (acct.fauditorid > 0)) AND (g.FAccountType = 'BW' OR g.FISPROFIT = '1'))
===================================================
调用堆栈:
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteReader(DbCommand command, IEnumerable`1 paramList, CommandBehavior cmdBehavior, Boolean bNewCn)
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteReader(DbCommand command, IEnumerable`1 paramList, CommandBehavior cmdBehavior)
at Kingdee.BOS.App.Data.DBUtils.ExecuteReader(Context ctx, String strSQL, IEnumerable`1 paramList, CommandType cmdtype, CommandBehavior cmdBehavior, Boolean bNewCn)
at Kingdee.BOS.App.Data.DBUtils.ExecuteReader(Context ctx, String strSQL, IEnumerable`1 paramList, CommandType cmdtype, CommandBehavior cmdBehavior)
at Kingdee.BOS.App.Data.DBUtils.ExecuteObject[T](Context ctx, String strSQL, IDataEntityType dt, IDictionary`2 propertyTypeMaps, CommandType cmdType, SqlParam[] paramList)
at Kingdee.BOS.App.Data.DBUtils.ExecuteDynamicObject(Context ctx, String strSQL, IDataEntityType dt, IDictionary`2 propertyTypeMaps, CommandType cmdType, SqlParam[] paramList)
at Kingdee.K3.FIN.App.Core.CommonFunction.GetAcctOfProfitOrExlcude(Context ctx, Int64 iBookId)
at Kingdee.K3.FIN.ServiceHelper.CommonServiceHelper.GetAcctOfProfitOrExlcude(Context ctx, Int64 iBookId)
at Kingdee.K3.FIN.GL.Business.PlugIn.InitBalanceEdit.GetProfitAccount(Int64 iBookID)
at Kingdee.K3.FIN.GL.Business.PlugIn.InitBalanceEdit.DoOperateAcctBook()
at Kingdee.K3.FIN.GL.Business.PlugIn.InitBalanceEdit.LoadInitBal()
at Kingdee.K3.FIN.GL.Business.PlugIn.InitBalanceEdit.BeforeBindData(EventArgs e)
at Kingdee.BOS.Core.DynamicForm.PlugIn.DynamicFormViewPlugInProxy.FireBeforeBindData(EventArgs e)
at Kingdee.BOS.Web.DynamicForm.AbstractDynamicWebFormView.UpdateView()
at Kingdee.BOS.Web.DynamicForm.DynamicWebFormView.LoadData()
at Kingdee.BOS.Web.DynamicForm.DynamicWebFormController.LoadData()