销售出库明细表条件页签选择"价格类型"查询报错
金蝶云社区-谭磊_2
谭磊_2
0人赞赏了该文章 425次浏览 未经作者许可,禁止转载编辑于2017年11月23日 12:36:05

价格类型为 销售出库单增加字段

当它在查询对话框 条件页签 作为条件查询时 报错

报错内容:
--最后的插入sql语句
SELECT TT.*, ROW_NUMBER() OVER(ORDER BY TT.FSALEORGNAME,TT.FCUSTOMERNAME,TT.FMATERIALNUMBER ) FIDENTITYID INTO TMP4F3E9730C43911E78FDC0A94EF0 FROM (SELECT * FROM TMP4F3E9732C43911E78FDC0A94EF0 WHERE (( FText Like N'%活动价%' ) )) TT

Server stack trace:
at Kingdee.BOS.App.Data.Sql.SqlDatabase.ExecuteBatch(List`1 sqlArray, Int32 batchSize, Int32 commandTimeout)
at Kingdee.BOS.App.Data.DBUtils.ExecuteBatchWithTime(Context ctx, List`1 sqlArray, Int32 batchSize, Int32 commandTimeout)

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.IDBService.ExecuteBatchWithTime(Context ctx, List`1 sqlArray, Int32 commandTimeout)
at Kingdee.K3.SCM.App.Sal.Report.SaleOutStockDetailRpt.BuilderReportSqlAndTempTable(IRptParams filter, String tableName)
at Prj_XSCKMX.clsXSCKMX_ZB.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.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 [1]:
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__DisplayClass55.b__51()