辅助核算项目余额表查询报错
财务老司机
2人赞赏了该文章
580次浏览
编辑于2018年12月15日 13:51:19
财务会计—总账—统计报表—辅助核算项目余额表查询报错。
注：方案选择‘无发生额不显示’选项，查询报错。不勾选该选项可正常查询
错误详细堆栈信息：com.kingdee.bos.BOSException: Sql1 execute exception : INSERT INTO VTZYTX9822JDK0NR21Y192KUQLM4TOMKQ4(actTypeIsTotal,FActTypefId) SELECT DISTINCT 1 actTypeIsTotal, t.FActTypefId FROM VTZYTX9822JDK0NR21Y192KUQLM4TOMKQ4 t WHERE (t.FActTypefId IS NOT NULL) AND (t.fperiod >= 201601) AND (t.fperiod <= 201612) AND EXISTS (SELECT 1 FROM (SELECT fasstitemid, itemnumber, itemname, facttypefid, faccountid FROM (SELECT fasstitemid, itemnumber, itemname, facttypefid, faccountid, count(*) cc FROM VTZYTX9822JDK0NR21Y192KUQLM4TOMKQ4 WHERE ((FDebitFor <> 0) OR (FCreditFor <> 0)) AND (fperiod >= 201601) GROUP BY fasstitemid, itemnumber, itemname, facttypefid, faccountid) WHERE (cc > 0)) tp WHERE t.fasstitemid = tp.fasstitemid AND t.faccountid = tp.faccountid)
Caused exception message is: 关键字 'WHERE' 附近有语法错误。
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:260)
at com.kingdee.eas.fi.gl.rpt.app.dao.AbstractGLRptDao.execute(AbstractGLRptDao.java:1529)
at com.kingdee.eas.fi.gl.rpt.app.dao.AbstractGLRptDao.execute(AbstractGLRptDao.java:1524)
at com.kingdee.eas.fi.gl.rpt.app.dao.AbstractGLRptDao.insertData(AbstractGLRptDao.java:984)
at com.kingdee.eas.fi.gl.rpt.app.dao.AbstractGLRptDao.insertData(AbstractGLRptDao.java:1429)
at com.kingdee.eas.fi.gl.rpt.app.dao.AbstractGLRptDao.insertSumItem(AbstractGLRptDao.java:1014)
注：方案选择‘无发生额不显示’选项，查询报错。不勾选该选项可正常查询
错误详细堆栈信息：com.kingdee.bos.BOSException: Sql1 execute exception : INSERT INTO VTZYTX9822JDK0NR21Y192KUQLM4TOMKQ4(actTypeIsTotal,FActTypefId) SELECT DISTINCT 1 actTypeIsTotal, t.FActTypefId FROM VTZYTX9822JDK0NR21Y192KUQLM4TOMKQ4 t WHERE (t.FActTypefId IS NOT NULL) AND (t.fperiod >= 201601) AND (t.fperiod <= 201612) AND EXISTS (SELECT 1 FROM (SELECT fasstitemid, itemnumber, itemname, facttypefid, faccountid FROM (SELECT fasstitemid, itemnumber, itemname, facttypefid, faccountid, count(*) cc FROM VTZYTX9822JDK0NR21Y192KUQLM4TOMKQ4 WHERE ((FDebitFor <> 0) OR (FCreditFor <> 0)) AND (fperiod >= 201601) GROUP BY fasstitemid, itemnumber, itemname, facttypefid, faccountid) WHERE (cc > 0)) tp WHERE t.fasstitemid = tp.fasstitemid AND t.faccountid = tp.faccountid)
Caused exception message is: 关键字 'WHERE' 附近有语法错误。
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:260)
at com.kingdee.eas.fi.gl.rpt.app.dao.AbstractGLRptDao.execute(AbstractGLRptDao.java:1529)
at com.kingdee.eas.fi.gl.rpt.app.dao.AbstractGLRptDao.execute(AbstractGLRptDao.java:1524)
at com.kingdee.eas.fi.gl.rpt.app.dao.AbstractGLRptDao.insertData(AbstractGLRptDao.java:984)
at com.kingdee.eas.fi.gl.rpt.app.dao.AbstractGLRptDao.insertData(AbstractGLRptDao.java:1429)
at com.kingdee.eas.fi.gl.rpt.app.dao.AbstractGLRptDao.insertSumItem(AbstractGLRptDao.java:1014)
推荐阅读