物料收发汇总表报错!!!!
金蝶云社区-voloer_1
voloer_1
0人赞赏了该文章 930次浏览 未经作者许可,禁止转载编辑于2017年11月13日 09:36:11

打开物料收发汇总表,提示如下:
查询出现异常。将 numeric 转换为数据类型 numeric 时出现算术溢出错误。
UPDATE #TM_STK_RPTCOMMONRPT SET FBASEJCPRICE = CASE WHEN FBASEJCQTY = 0 THEN 0 ELSE CAST((FJCAMOUNT / FBASEJCQTY) AS NUMERIC(23, 10)) END, FSTOCKJCPRICE = CASE WHEN FSTOCKJCQTY = 0 THEN 0 ELSE CAST((FJCAMOUNT / FSTOCKJCQTY) AS NUMERIC(23, 10)) END, FSECJCPRICE = CASE WHEN FSECJCQTY = 0 THEN 0 ELSE CAST((FJCAMOUNT / FSECJCQTY) AS NUMERIC(23, 10)) END

Server stack trace:
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
at Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1 paramList, Boolean needTranslate)
at Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1 paramList)
at Kingdee.K3.SCM.App.Stock.Report.StockSummaryRpt.BuilderReportSqlAndTempTable(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.GetListAndReportData(IRptParams filter)
at Kingdee.BOS.App.Core.PlugInProxy.SysReportServicePlugInProxy.GetListAndReportData(MoveReportServiceParameter parameter)
at Kingdee.BOS.App.Core.SysReportService.GetListAndReportData(MoveReportServiceParameter 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.GetListAndReportData(MoveReportServiceParameter parameter)
at Kingdee.BOS.ServiceHelper.SysReportServiceHelper.GetListAndReportData(MoveReportServiceParameter parameter)
at Kingdee.BOS.Model.Report.MoveReportModel.GetData(Int32 start, Int32 rows)
at Kingdee.BOS.Web.Report.SysReportView.GetListData()
at Kingdee.BOS.Web.Report.SysReportView.<>c__DisplayClass55.b__51()