从7.2升级到7.7之后，审核销售出库单提示列名 'FSOURCEBILLID' 无效。

错误ID：3CB75C1812099101D7ED577754E6903C

发生时间： 2021-09-29 12:10:00

错误编号： BOS_ExecuteNonQuery

错误信息：列名 'FSOURCEBILLID' 无效。

Sql语句： MERGE INTO T_ESS_GOODS_IDENTITY GI USING(SELECT T2.FSERIALNO fnumber, SOE.FGOODSID, SOE.FMATERIALID, SOE.FSKUID, SO.FORDERCHANNEL fchannelid, SO.FSALEORG fsaleorgid, SO.FTYPEID fordertypeid, SOE.FID forderid, SOE.FENTRYID forderentryid, T2.FSERIALID, T1.FSNUNITID, T1.FID fsourcebillid, T1.FENTRYID fsourcebillentryid, 'SAL_OUTSTOCK' fsrcformid FROM T_SAL_OUTSTOCK T0 INNER JOIN T_SAL_OUTSTOCKENTRY T1 ON T1.FID = T0.FID INNER JOIN T_SAL_OUTSTOCKSERIAL T2 ON T2.FENTRYID = T1.FENTRYID INNER JOIN T_SAL_OUTSTOCKENTRY_R T3 ON T3.FENTRYID = T1.FENTRYID INNER JOIN #TM_BF_INSTENTRYALL T4 ON (T4.FTID = T3.FENTRYID AND T4.FTTABLENAME = 'T_SAL_OUTSTOCKENTRY') INNER JOIN #TM_BF_INSTENTRYALL T5 ON ((T5.FINSTANCEID = T4.FINSTANCEID AND T5.FSTABLENAME = 'T_ESS_ORDER_DETAIL') AND T5.FTTABLENAME = 'T_SAL_ORDERENTRY') INNER JOIN T_ESS_ORDER_DETAIL SOE ON SOE.FENTRYID = T5.FSID INNER JOIN T_ESS_ORDER SO ON SO.FID = SOE.FID WHERE ((T0.FID IN (SELECT FID FROM @FID_udt1) AND EXISTS (SELECT 1 FROM T_ESS_GOODS_IDENTITY T1 WHERE (T1.FNUMBER = T2.FSERIALNO AND T1.FGOODSID = SOE.FGOODSID))) AND (T0.FBILLTYPEID <> 'ea4889bc7c004230babdbe8f6ef889b7')) GROUP BY T2.FSERIALNO, SOE.FGOODSID, SOE.FMATERIALID, SOE.FSKUID, SO.FORDERCHANNEL, SO.FSALEORG, SO.FTYPEID, SOE.FID, SOE.FENTRYID, T2.FSERIALID, T1.FSNUNITID, T1.FID, T1.FENTRYID) TT ON ((GI.FGOODSID = TT.FGOODSID AND GI.FNUMBER = TT.FNUMBER)) WHEN MATCHED THEN UPDATE SET GI.FCHANNELID = TT.FCHANNELID, GI.FSTATUS = '1', GI.FORDERTYPEID = TT.FORDERTYPEID, GI.FORDERID = TT.FORDERID, GI.FORDERENTRYID = TT.FORDERENTRYID, GI.FSALEORGID = TT.FSALEORGID, GI.FSOURCEBILLID = TT.FSOURCEBILLID, GI.FSOURCEBILLENTRYID = TT.FSOURCEBILLENTRYID, GI.FSRCFORMID = TT.FSRCFORMID;

===================================================

调用堆栈：

Server stack trace:

在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)

在 Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1 paramList, Boolean needTranslate)

在 Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1 paramList)

在 Kingdee.K3.SCM.App.CP.ServicePlugIn.BBCOrder.AuditForOutStock.WriteBackBBC(Int64[] ids)

在 Kingdee.BOS.App.Core.PlugInProxy.OperationServicePlugInProxy.FireEndOperationTransaction(EndOperationTransactionArgs e)

在 Kingdee.BOS.App.Core.AbstractOprerationService.CallOperation(DynamicObject[]& objs)

产品问题审核销售出库单，提示列名 'FSOURCEBILLID' 无效。

50 产品问题 审核销售出库单，提示列名 'FSOURCEBILLID' 无效。

恭喜您！

产品问题
审核销售出库单，提示列名 'FSOURCEBILLID' 无效。

50 产品问题审核销售出库单，提示列名 'FSOURCEBILLID' 无效。