"核算维度余额表"过滤条件勾选"余额为零不显示"出错.
金蝶云社区-quHongan
quHongan
0人赞赏了该文章 902次浏览 未经作者许可,禁止转载编辑于2015年09月07日 08:34:35

总账中的核算维度余额表"过滤条件勾选"余额为零不显示"出现错误提示。QQ:469126910

查询出现异常。Kingdee.BOS.SQL.Exception.ParserException: format sql error. target database is 'MS SQL Server' detail message is :
ERROR
source sql is :
delete from #TM_GL_ACCOUNTITEMBALANCE where
(isnull(FDebit,0) = 0 and isnull(FCredit,0) = 0)

delete from #TM_GL_ACCOUNTITEMBALANCE where
(isnull(FEndDebit) = 0 and isnull(FEndCredit) = 0)
or (FEndDebit = FEndCredit)

Server stack trace:
at Kingdee.BOS.SQL.TransUtil.format(String ksql, IList stmtCol, Int32 targetDbType, FormatOptions options)
at Kingdee.BOS.App.Data.Sql.SqlDatabase.ExecuteBatch(List`1 sqlArray, Int32 batchSize, Int32 commandTimeout)
at Kingdee.K3.FIN.GL.App.Report.AccountingItemsBalanceService.BuilderSql(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__DisplayClass3b.b__37()