库存账龄分析表查询时出错：
INSERT INTO #TM_STK_RPTBILLDATACOMTMP (FFORMID, FQTYADDOPTION, FBILLDATE, FBILLNO, FBILLID, FBILLSTATUS, FBILLCANCELSTATUS, FUPSTOCKFLAG, FSTOCKORGID, FMATERIALID, FLOT, FAUXPROPID, FSTOCKID, FSTOCKLOCID, FSTOCKSTATUSID, FBASEQTY, FBASEUNITID, FSECQTY, FSECUNITID, FKEEPERID, FKEEPERTYPEID, FOWNERID, FOWNERTYPEID, FBOMID, FMTONO, FPROJECTNO, FPRODUCEDATE, FEXPIRYDATE) SELECT 'PRD_PickMtrl' fformid, -1 fqtyaddoption, t0.FDATE fbilldate, t0.FBILLNO fbillno, t0.FID fbillid, t0.FDOCUMENTSTATUS fbillstatus, t0.FCANCELSTATUS fbillcancelstatus, t1.FSTOCKFLAG fupstockflag, t0.FSTOCKORGID fstockorgid, t1.FMATERIALID fmaterialid, t1.FLOT flot, t1.FAUXPROPID fauxpropid, t1.FSTOCKID fstockid, t1.FSTOCKLOCID fstocklocid, t1.FSTOCKSTATUSID fstockstatusid, t1_A.FBASESTOCKACTUALQTY fbaseqty, t1.FBASEUNITID fbaseunitid, t1.FSECACTUALQTY fsecqty, t1.FSECUNITID fsecunitid, t1_A.FKEEPERID fkeeperid, t1_A.FKEEPERTYPEID fkeepertypeid, t1_A.FOWNERID fownerid, t1_A.FOWNERTYPEID fownertypeid, t1.FBOMID fbomid, t1.FMTONO fmtono, t1.FPROJECTNO fprojectno, t1.FPRODUCEDATE fproducedate, t1.FEXPIRYDATE fexpirydate FROM T_PRD_PICKMTRL t0 LEFT OUTER JOIN T_PRD_PICKMTRLDATA t1 ON t0.FID = t1.FID LEFT OUTER JOIN T_PRD_PICKMTRLDATA_A t1_A ON t1.FENTRYID = t1_A.FENTRYID WHERE (((((((t0.FDATE >= '2016-09-01 00:00:00') AND (t0.FDATE < '2016-10-01 00:00:00')) AND t0.FSTOCKORGID = 100001) AND (t1_A.FBASESTOCKACTUALQTY > 0)) AND t0.FFORMID = 'PRD_PickMtrl') AND t0.FCANCELSTATUS = 'A') AND t0.FSTOCKORGID IN (100001))
Server stack trace:
在 Kingdee.K3.SCM.App.Stock.Report.StockBillDataRptCommon.GetStockData(String commonFilter)
在 Kingdee.K3.SCM.App.Stock.Report.InvAgeAnalyze.BuildStockInvChangedDetail(Context ctx, List`1 needOrgIds)
在 Kingdee.K3.SCM.App.Stock.Report.InvAgeAnalyze.InitInventory()
在 Kingdee.K3.SCM.App.Stock.Report.InvAgeAnalyze.GetList(IRptParams filter)
在 Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetListAndReportData(IRptParams filter)
在 Kingdee.BOS.App.Core.PlugInProxy.SysReportServicePlugInProxy.GetListAndReportData(MoveReportServiceParameter parameter)
在 Kingdee.BOS.App.Core.SysReportService.GetListAndReportData(MoveReportServiceParameter parameter)
Exception rethrown at [0]:
在 System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
在 System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
在 Kingdee.BOS.Contracts.ISysReportService.GetListAndReportData(MoveReportServiceParameter parameter)
在 Kingdee.BOS.ServiceHelper.SysReportServiceHelper.GetListAndReportData(MoveReportServiceParameter parameter)
在 Kingdee.BOS.Model.Report.MoveReportModel.GetData(Int32 start, Int32 rows)
在 Kingdee.BOS.Web.Report.SysReportView.GetListData()
在 Kingdee.BOS.Web.Report.SysReportView.<>c__DisplayClass4d.
