V6.1demo版应付单审核报错，怎么处理
kuangliu
590次浏览
编辑于2017年01月10日 11:04:39
对象名 'T_CRE_CUSTARCHIVES' 无效
发生时间： 2017-01-10 11:01:43错误编号： ExecuteBatch错误信息： 对象名 'T_CRE_CUSTARCHIVES' 无效。Sql语句： INSERT INTO #TM_CRE_WRITETABLE (FSOURCEFROMID,FSRCBILLID,FCURWRITTENOFFAMOUNTFOR)SELECT FSOURCEFROMID,FSRCBILLID,sum(FCURWRITTENOFFAMOUNTFOR) AS FCURWRITTENOFFAMOUNTFORFROM T_AP_PAYMATCHLOGENTRY WHERE FID in (100008) AND FID not in ( select t1.fid from T_AP_PAYMATCHLOGENTRY t1 join t_ar_Receivebill t2 on t1.fsrcbillid = t2.fid where t1.FID in (100008) and t1.fsourcefromid= 'AR_RECEIVEBILL' and t2.fdocumentstatus <> 'C' union all select t1.fid from T_AP_PAYMATCHLOGENTRY t1 join T_AR_REFUNDBILL t2 on t1.fsrcbillid = t2.fid where t1.FID in (100008) and t1.fsourcefromid= 'AR_REFUNDBILL' and t2.fdocumentstatus <> 'C' union all select t1.fid from T_AP_PAYMATCHLOGENTRY t1 join T_AR_RECEIVABLE t2 on t1.fsrcbillid = t2.fid where t1.FID in (100008) and t1.fsourcefromid= 'AR_receivable' and t2.fdocumentstatus <> 'C' union all select t1.fid from T_AP_PAYMATCHLOGENTRY t1 join T_AR_OtherRecAble t2 on t1.fsrcbillid = t2.fid where t1.FID in (100008) and t1.fsourcefromid= 'AR_OtherRecAble' and t2.fdocumentstatus <> 'C')GROUP BY FSOURCEFROMID,FSRCBILLID
INSERT INTO #TM_CRE_SUMWRITETABLE(FORGID,FARCHIVEENTRYID,FDEPTID,FOBJECTTYPE,FOBJECTID,FCURRENCYID,FWRITTENOFFAMOUNT)SELECT FORGID,FARCHIVEENTRYID,FDEPTID,FOBJECTTYPE,FOBJECTID,FCURRENCYID,SUM(FWRITTENOFFAMOUNT) AS FWRITTENOFFAMOUNTFROM (SELECT distinct t1.FSRCBILLID,t3.FENTRYID AS FARCHIVEENTRYID,t4.FDEPTID,t4.FORGID,t4.FOBJECTTYPE,t3.FOBJECTID,t2.FCURRENCYID,-1*t1.FCURWRITTENOFFAMOUNTFOR AS FWRITTENOFFAMOUNTFROM #TM_CRE_WRITETABLE t1join T_AR_RECEIVABLEENTRY e on t1.FSRCBILLID=e.FIDjoin T_AR_RECEIVABLEENTRY_CRE t2 on e.FENTRYID = t2.FENTRYID join T_CRE_CUSTARCHIVESENTRY t3 on t2.FARCHIVEENTRYID = t3.FENTRYIDjoin T_CRE_CUSTARCHIVES t4 on t3.FID=t4.FID and t4.FOBJECTTYPE='BD_Customer'WHERE t1.FSOURCEFROMID = 'AR_receivable' AND t2.FBILLCREDITAMOUNT <> 0UNION ALLSELECT distinct t1.FSRCBILLID,t3.FENTRYID AS FARCHIVEENTRYID,t4.FDEPTID,t4.FORGID,t4.FOBJECTTYPE,t3.FOBJECTID,t2.FCURRENCYID,t1.FCURWRITTENOFFAMOUNTFOR AS FWRITTENOFFAMOUNTFROM #TM_CRE_WRITETABLE t1join T_AR_RECEIVEBILLENTRY e on t1.FSRCBILLID=e.FIDjoin T_AR_RECEIVEENTRY_CRE t2 on e.FENTRYID = t2.FENTRYID join T_CRE_CUSTARCHIVESENTRY t3 on t2.FARCHIVEENTRYID = t3.FENTRYIDjoin T_CRE_CUSTARCHIVES t4 on t3.FID=t4.FID and t4.FOBJECTTYPE='BD_Customer'WHERE t1.FSOURCEFROMID = 'AR_RECEIVEBILL' AND t2.FBILLCREDITAMOUNT <> 0UNION ALLSELECT distinct t1.FSRCBILLID,t3.FENTRYID AS FARCHIVEENTRYID,t4.FDEPTID,t4.FORGID,t4.FOBJECTTYPE,t3.FOBJECTID,t2.FCURRENCYID,-1*t1.FCURWRITTENOFFAMOUNTFOR AS FWRITTENOFFAMOUNTFROM #TM_CRE_WRITETABLE t1join T_AR_REFUNDBILLENTRY e on t1.FSRCBILLID=e.FIDjoin T_AR_REFUNDENTRY_CRE t2 on e.FENTRYID = t2.FENTRYID join T_CRE_CUSTARCHIVESENTRY t3 on t2.FARCHIVEENTRYID = t3.FENTRYIDjoin T_CRE_CUSTARCHIVES t4 on t3.FID=t4.FID and t4.FOBJECTTYPE='BD_Customer'WHERE t1.FSOURCEFROMID = 'AR_REFUNDBILL' AND t2.FBILLCREDITAMOUNT <> 0UNION ALLSELECT distinct t1.FSRCBILLID,t3.FENTRYID AS FARCHIVEENTRYID,t4.FDEPTID,t4.FORGID,t4.FOBJECTTYPE,t3.FOBJECTID,t2.FCURRENCYID,-1*t1.FCURWRITTENOFFAMOUNTFOR AS FWRITTENOFFAMOUNTFROM #TM_CRE_WRITETABLE t1join T_AR_OtherRecAbleENTRY e on t1.FSRCBILLID=e.FIDjoin T_AR_ORENTRY_CRE t2 on e.FENTRYID = t2.FENTRYID join T_CRE_CUSTARCHIVESENTRY t3 on t2.FARCHIVEENTRYID = t3.FENTRYIDjoin T_CRE_CUSTARCHIVES t4 on t3.FID=t4.FID and t4.FOBJECTTYPE='BD_Customer'WHERE t1.FSOURCEFROMID = 'AR_OtherRecAble' AND t2.FBILLCREDITAMOUNT <> 0) tGROUP BY FORGID,FARCHIVEENTRYID,FDEPTID,FOBJECTTYPE,FOBJECTID,FCURRENCYID
===================================================调用堆栈：
Server stack trace: 在 Kingdee.BOS.App.Data.Sql.SqlDatabase.ExecuteBatch(List`1 sqlArray, Int32 batchSize, Int32 commandTimeout) 在 Kingdee.BOS.App.Data.DBUtils.ExecuteBatch(Context ctx, List`1 sqlArray, Int32 batchSize) 在 Kingdee.K3.SCM.App.Credit.Core.CreditService.ActualUpdateMatchCredit(Context ctx, String objectType, List`1 LogIds, String SubsysId, Boolean IsCheck) 在 Kingdee.K3.SCM.App.Credit.Core.CreditService.UpdateMATCKECredit(Context ctx, List`1 LogIds, String SubsysId, Boolean IsCheck) 在 Kingdee.K3.FIN.App.Core.Match.Object.MatchCommonFunction.UpdateMATCKECredit(Context ctx, MatchCalParameters para, List`1 logIds, Boolean isCheck) 在 Kingdee.K3.FIN.App.Core.Match.Object.GeneMatchBill`1.Save(Context ctx) 在 Kingdee.K3.FIN.App.Core.Match.MatchProcess.Save(Context ctx, MatchCalParameters para, IOperationResult result, Dictionary`2 matchFields) 在 Kingdee.K3.FIN.App.Core.Match.MatchProcess.WriteMatchRecord(Context ctx, MatchCalParameters para) 在 Kingdee.K3.FIN.App.Core.MatchOperation.AbstractMatchOperation.SaveMatchOperation(DynamicObject[] DataEntitys) 在 Kingdee.BOS.App.Core.PlugInProxy.OperationServicePlugInProxy.FireEndOperationTransaction(EndOperationTransactionArgs e) 在 Kingdee.BOS.App.Core.AbstractOprerationService.CallOperation(DynamicObject[]& objs) 在 Kingdee.BOS.App.Core.AbstractOprerationService.CallOperatinTransaction(DynamicObject[] objs) 在 Kingdee.BOS.App.Core.AbstractOprerationService.DoExcete() 在 Kingdee.BOS.App.Core.AbstractOprerationService.Excute(Object[] ids) 在 Kingdee.BOS.App.Core.SetStatusService.SetBillStatus(Context ctx, BusinessInfo businessInfo, List`1 pkEntryIds, List`1 paras, String operationNumber, OperateOption option)
Exception rethrown at [0]: 在 Kingdee.BOS.ServiceHelper.BusinessDataServiceHelper.SetBillStatus(Context ctx, BusinessInfo businessInfo, List`1 pkEntryIds, List`1 paras, String operationNumber, OperateOption option) 在 Kingdee.BOS.Business.Bill.Operation.AbstractStatusConvert.ExecuteBillOperation(List`1 paras, OperateOption option) 在 Kingdee.BOS.Business.Bill.Operation.AbstractStatusConvert.ExecuteStatusConvert(List`1 paras) 在 Kingdee.BOS.Business.Bill.Operation.Audit.AuditIdeaPrompt() 在 Kingdee.BOS.Core.DynamicForm.AbstractDynamicFormOperation.Operation(CallBackWfAfterOperation callbackwf, IOperationResult result)
发生时间： 2017-01-10 11:01:43错误编号： ExecuteBatch错误信息： 对象名 'T_CRE_CUSTARCHIVES' 无效。Sql语句： INSERT INTO #TM_CRE_WRITETABLE (FSOURCEFROMID,FSRCBILLID,FCURWRITTENOFFAMOUNTFOR)SELECT FSOURCEFROMID,FSRCBILLID,sum(FCURWRITTENOFFAMOUNTFOR) AS FCURWRITTENOFFAMOUNTFORFROM T_AP_PAYMATCHLOGENTRY WHERE FID in (100008) AND FID not in ( select t1.fid from T_AP_PAYMATCHLOGENTRY t1 join t_ar_Receivebill t2 on t1.fsrcbillid = t2.fid where t1.FID in (100008) and t1.fsourcefromid= 'AR_RECEIVEBILL' and t2.fdocumentstatus <> 'C' union all select t1.fid from T_AP_PAYMATCHLOGENTRY t1 join T_AR_REFUNDBILL t2 on t1.fsrcbillid = t2.fid where t1.FID in (100008) and t1.fsourcefromid= 'AR_REFUNDBILL' and t2.fdocumentstatus <> 'C' union all select t1.fid from T_AP_PAYMATCHLOGENTRY t1 join T_AR_RECEIVABLE t2 on t1.fsrcbillid = t2.fid where t1.FID in (100008) and t1.fsourcefromid= 'AR_receivable' and t2.fdocumentstatus <> 'C' union all select t1.fid from T_AP_PAYMATCHLOGENTRY t1 join T_AR_OtherRecAble t2 on t1.fsrcbillid = t2.fid where t1.FID in (100008) and t1.fsourcefromid= 'AR_OtherRecAble' and t2.fdocumentstatus <> 'C')GROUP BY FSOURCEFROMID,FSRCBILLID
INSERT INTO #TM_CRE_SUMWRITETABLE(FORGID,FARCHIVEENTRYID,FDEPTID,FOBJECTTYPE,FOBJECTID,FCURRENCYID,FWRITTENOFFAMOUNT)SELECT FORGID,FARCHIVEENTRYID,FDEPTID,FOBJECTTYPE,FOBJECTID,FCURRENCYID,SUM(FWRITTENOFFAMOUNT) AS FWRITTENOFFAMOUNTFROM (SELECT distinct t1.FSRCBILLID,t3.FENTRYID AS FARCHIVEENTRYID,t4.FDEPTID,t4.FORGID,t4.FOBJECTTYPE,t3.FOBJECTID,t2.FCURRENCYID,-1*t1.FCURWRITTENOFFAMOUNTFOR AS FWRITTENOFFAMOUNTFROM #TM_CRE_WRITETABLE t1join T_AR_RECEIVABLEENTRY e on t1.FSRCBILLID=e.FIDjoin T_AR_RECEIVABLEENTRY_CRE t2 on e.FENTRYID = t2.FENTRYID join T_CRE_CUSTARCHIVESENTRY t3 on t2.FARCHIVEENTRYID = t3.FENTRYIDjoin T_CRE_CUSTARCHIVES t4 on t3.FID=t4.FID and t4.FOBJECTTYPE='BD_Customer'WHERE t1.FSOURCEFROMID = 'AR_receivable' AND t2.FBILLCREDITAMOUNT <> 0UNION ALLSELECT distinct t1.FSRCBILLID,t3.FENTRYID AS FARCHIVEENTRYID,t4.FDEPTID,t4.FORGID,t4.FOBJECTTYPE,t3.FOBJECTID,t2.FCURRENCYID,t1.FCURWRITTENOFFAMOUNTFOR AS FWRITTENOFFAMOUNTFROM #TM_CRE_WRITETABLE t1join T_AR_RECEIVEBILLENTRY e on t1.FSRCBILLID=e.FIDjoin T_AR_RECEIVEENTRY_CRE t2 on e.FENTRYID = t2.FENTRYID join T_CRE_CUSTARCHIVESENTRY t3 on t2.FARCHIVEENTRYID = t3.FENTRYIDjoin T_CRE_CUSTARCHIVES t4 on t3.FID=t4.FID and t4.FOBJECTTYPE='BD_Customer'WHERE t1.FSOURCEFROMID = 'AR_RECEIVEBILL' AND t2.FBILLCREDITAMOUNT <> 0UNION ALLSELECT distinct t1.FSRCBILLID,t3.FENTRYID AS FARCHIVEENTRYID,t4.FDEPTID,t4.FORGID,t4.FOBJECTTYPE,t3.FOBJECTID,t2.FCURRENCYID,-1*t1.FCURWRITTENOFFAMOUNTFOR AS FWRITTENOFFAMOUNTFROM #TM_CRE_WRITETABLE t1join T_AR_REFUNDBILLENTRY e on t1.FSRCBILLID=e.FIDjoin T_AR_REFUNDENTRY_CRE t2 on e.FENTRYID = t2.FENTRYID join T_CRE_CUSTARCHIVESENTRY t3 on t2.FARCHIVEENTRYID = t3.FENTRYIDjoin T_CRE_CUSTARCHIVES t4 on t3.FID=t4.FID and t4.FOBJECTTYPE='BD_Customer'WHERE t1.FSOURCEFROMID = 'AR_REFUNDBILL' AND t2.FBILLCREDITAMOUNT <> 0UNION ALLSELECT distinct t1.FSRCBILLID,t3.FENTRYID AS FARCHIVEENTRYID,t4.FDEPTID,t4.FORGID,t4.FOBJECTTYPE,t3.FOBJECTID,t2.FCURRENCYID,-1*t1.FCURWRITTENOFFAMOUNTFOR AS FWRITTENOFFAMOUNTFROM #TM_CRE_WRITETABLE t1join T_AR_OtherRecAbleENTRY e on t1.FSRCBILLID=e.FIDjoin T_AR_ORENTRY_CRE t2 on e.FENTRYID = t2.FENTRYID join T_CRE_CUSTARCHIVESENTRY t3 on t2.FARCHIVEENTRYID = t3.FENTRYIDjoin T_CRE_CUSTARCHIVES t4 on t3.FID=t4.FID and t4.FOBJECTTYPE='BD_Customer'WHERE t1.FSOURCEFROMID = 'AR_OtherRecAble' AND t2.FBILLCREDITAMOUNT <> 0) tGROUP BY FORGID,FARCHIVEENTRYID,FDEPTID,FOBJECTTYPE,FOBJECTID,FCURRENCYID
===================================================调用堆栈：
Server stack trace: 在 Kingdee.BOS.App.Data.Sql.SqlDatabase.ExecuteBatch(List`1 sqlArray, Int32 batchSize, Int32 commandTimeout) 在 Kingdee.BOS.App.Data.DBUtils.ExecuteBatch(Context ctx, List`1 sqlArray, Int32 batchSize) 在 Kingdee.K3.SCM.App.Credit.Core.CreditService.ActualUpdateMatchCredit(Context ctx, String objectType, List`1 LogIds, String SubsysId, Boolean IsCheck) 在 Kingdee.K3.SCM.App.Credit.Core.CreditService.UpdateMATCKECredit(Context ctx, List`1 LogIds, String SubsysId, Boolean IsCheck) 在 Kingdee.K3.FIN.App.Core.Match.Object.MatchCommonFunction.UpdateMATCKECredit(Context ctx, MatchCalParameters para, List`1 logIds, Boolean isCheck) 在 Kingdee.K3.FIN.App.Core.Match.Object.GeneMatchBill`1.Save(Context ctx) 在 Kingdee.K3.FIN.App.Core.Match.MatchProcess.Save(Context ctx, MatchCalParameters para, IOperationResult result, Dictionary`2 matchFields) 在 Kingdee.K3.FIN.App.Core.Match.MatchProcess.WriteMatchRecord(Context ctx, MatchCalParameters para) 在 Kingdee.K3.FIN.App.Core.MatchOperation.AbstractMatchOperation.SaveMatchOperation(DynamicObject[] DataEntitys) 在 Kingdee.BOS.App.Core.PlugInProxy.OperationServicePlugInProxy.FireEndOperationTransaction(EndOperationTransactionArgs e) 在 Kingdee.BOS.App.Core.AbstractOprerationService.CallOperation(DynamicObject[]& objs) 在 Kingdee.BOS.App.Core.AbstractOprerationService.CallOperatinTransaction(DynamicObject[] objs) 在 Kingdee.BOS.App.Core.AbstractOprerationService.DoExcete() 在 Kingdee.BOS.App.Core.AbstractOprerationService.Excute(Object[] ids) 在 Kingdee.BOS.App.Core.SetStatusService.SetBillStatus(Context ctx, BusinessInfo businessInfo, List`1 pkEntryIds, List`1 paras, String operationNumber, OperateOption option)
Exception rethrown at [0]: 在 Kingdee.BOS.ServiceHelper.BusinessDataServiceHelper.SetBillStatus(Context ctx, BusinessInfo businessInfo, List`1 pkEntryIds, List`1 paras, String operationNumber, OperateOption option) 在 Kingdee.BOS.Business.Bill.Operation.AbstractStatusConvert.ExecuteBillOperation(List`1 paras, OperateOption option) 在 Kingdee.BOS.Business.Bill.Operation.AbstractStatusConvert.ExecuteStatusConvert(List`1 paras) 在 Kingdee.BOS.Business.Bill.Operation.Audit.AuditIdeaPrompt() 在 Kingdee.BOS.Core.DynamicForm.AbstractDynamicFormOperation.Operation(CallBackWfAfterOperation callbackwf, IOperationResult result)
推荐阅读