3.0升级5.0后，销售订单在选择物料时报错，具体信息如下
[{"operation":"SAL_SaleOrder.SetItemValueByIDFromClient"}]
发生时间： 2015-04-22 03:44:25
错误编号： BOS_ExecuteReader
错误信息： 列名 'FCBM' 无效。
Sql语句： SELECT T_BD_MATERIAL.FMATERIALID, T_BD_MATERIAL.FMasterId, T_BD_MATERIAL.FDOCUMENTSTATUS, T_BD_MATERIAL.FFORBIDSTATUS, T_BD_MATERIAL.FNUMBER, T_BD_MATERIAL.FCREATEORGID, T_BD_MATERIAL.FUSEORGID, T_BD_MATERIAL.FCREATORID, T_BD_MATERIAL.FMODIFIERID, T_BD_MATERIAL.FCREATEDATE, T_BD_MATERIAL.FMODIFYDATE, T_BD_MATERIAL.FMNEMONICCODE, T_BD_MATERIAL.FFORBIDDERID, T_BD_MATERIAL.FFORBIDDATE, T_BD_MATERIAL.FAPPROVEDATE, T_BD_MATERIAL.FAPPROVERID, T_BD_MATERIAL.FIMAGE, T_BD_MATERIAL.FOLDNUMBER, T_BD_MATERIAL.FMATERIALGROUP, T_BD_MATERIAL.FPLMMATERIALID, T_BD_MATERIAL.FMATERIALSRC, T_BD_MATERIAL.FCBM FROM T_BD_MATERIAL WHERE T_BD_MATERIAL.FMATERIALID = @PKValue;
SELECT T_BD_MATERIAL_L.FPkId, T_BD_MATERIAL_L.FLocaleId, T_BD_MATERIAL_L.FNAME, T_BD_MATERIAL_L.FDESCRIPTION, T_BD_MATERIAL_L.FSPECIFICATION, T_BD_MATERIAL_L.FMATERIALID FROM T_BD_MATERIAL_L INNER JOIN T_BD_MATERIAL ON T_BD_MATERIAL_L.FMATERIALID = T_BD_MATERIAL.FMATERIALID WHERE T_BD_MATERIAL.FMATERIALID = @PKValue;
SELECT t_BD_MaterialBase.FEntryId, t_BD_MaterialBase.FERPCLSID, t_BD_MaterialBase.FISINVENTORY, t_BD_MaterialBase.FISSALE, t_BD_MaterialBase.FISASSET, t_BD_MaterialBase.FISSUBCONTRACT, t_BD_MaterialBase.FISPRODUCE, t_BD_MaterialBase.FISPURCHASE, t_BD_MaterialBase.FISREALTIMEACCOUT, t_BD_MaterialBase.FBASEUNITID, t_BD_MaterialBase.FTAXTYPE, t_BD_MaterialBase.FTYPEID, t_BD_MaterialBase.FCATEGORYID, t_BD_MaterialBase.FTAXRATEID, t_BD_MaterialBase.FVOLUMEUNITID, t_BD_MaterialBase.FWEIGHTUNITID, t_BD_MaterialBase.FNETWEIGHT, t_BD_MaterialBase.FGROSSWEIGHT, t_BD_MaterialBase.FLENGTH, t_BD_MaterialBase.FHEIGHT, t_BD_MaterialBase.FWIDTH, t_BD_MaterialBase.FVOLUME, t_BD_MaterialBase.FBARCODE, t_BD_MaterialBase.FMATERIALID FROM t_BD_MaterialBase INNER JOIN T_BD_MATERIAL ON t_BD_MaterialBase.FMATERIALID = T_BD_MATERIAL.FMATERIALID WHERE T_BD_MATERIAL.FMATERIALID = @PKValue;
SELECT t_BD_MaterialStock.FEntryId, t_BD_MaterialStock.FSTOREUNITID, t_BD_MaterialStock.FAUXUNITID, t_BD_MaterialStock.FSTOCKID, t_BD_MaterialStock.FISLOCKSTOCK, t_BD_MaterialStock.FBATCHRULEID, t_BD_MaterialStock.FEXPUNIT, t_BD_MaterialStock.FSTOCKPLACEID, t_BD_MaterialStock.FONLINELIFE, t_BD_MaterialStock.FEXPPERIOD, t_BD_MaterialStock.FSTOREURNUM, t_BD_MaterialStock.FSTOREURNOM, t_BD_MaterialStock.FISBATCHMANAGE, t_BD_MaterialStock.FISKFPERIOD, t_BD_MaterialStock.FISEXPPARTOFLOT, t_BD_MaterialStock.FISCYCLECOUNTING, t_BD_MaterialStock.FISMUSTCOUNTING, t_BD_MaterialStock.FCURRENCYID, t_BD_MaterialStock.FREFCOST, t_BD_MaterialStock.FCOUNTCYCLE, t_BD_MaterialStock.FCOUNTDAY, t_BD_MaterialStock.FISSNMANAGE, t_BD_MaterialStock.FSNCODERULE, t_BD_MaterialStock.FSNUNIT, t_BD_MaterialStock.FSNMANAGETYPE, t_BD_MaterialStock.FSNCREATETIME, t_BD_MaterialStock.FSAFESTOCK, t_BD_MaterialStock.FREORDERGOOD, t_BD_MaterialStock.FMINSTOCK, t_BD_MaterialStock.FMAXSTOCK, t_BD_MaterialStock.FUNITCONVERTDIR, t_BD_MaterialStock.FISENABLEMINSTOCK, t_BD_MaterialStock.FISENABLESAFESTOCK, t_BD_MaterialStock.FISENABLEMAXSTOCK, t_BD_MaterialStock.FISENABLEREORDER, t_BD_MaterialStock.FECONREORDERQTY, t_BD_MaterialStock.FMATERIALID FROM t_BD_MaterialStock INNER JOIN T_BD_MATERIAL ON t_BD_MaterialStock.FMATERIALID = T_BD_MATERIAL.FMATERIALID WHERE T_BD_MATERIAL.FMATERIALID = @PKValue;
SELECT t_BD_MaterialSale.FEntryId, t_BD_MaterialSale.FISATPCHECK, t_BD_MaterialSale.FSALEPRICEUNITID, t_BD_MaterialSale.FSALEUNITID, t_BD_MaterialSale.FISINVOICE, t_BD_MaterialSale.FMAXQTY, t_BD_MaterialSale.FISRETURN, t_BD_MaterialSale.FMINQTY, t_BD_MaterialSale.FISRETURNCHECK, t_BD_MaterialSale.FISRETURNPART, t_BD_MaterialSale.FORDERQTY, t_BD_MaterialSale.FSALEPRICEURNOM, t_BD_MaterialSale.FSALEURNUM, t_BD_MaterialSale.FSALEPRICEURNUM, t_BD_MaterialSale.FSALEURNOM, t_BD_MaterialSale.FOUTSTOCKLMTH, t_BD_MaterialSale.FOUTSTOCKLMTL, t_BD_MaterialSale.FAGENTSALREDUCERATE, t_BD_MaterialSale.FALLOWPUBLISH, t_BD_MaterialSale.FISAFTERSALE, t_BD_MaterialSale.FISPRODUCTFILES, t_BD_MaterialSale.FISWARRANTED, t_BD_MaterialSale.FWARRANTY, t_BD_MaterialSale.FWARRANTYUNITID, t_BD_MaterialSale.FMATERIALID FROM t_BD_MaterialSale INNER JOIN T_BD_MATERIAL ON t_BD_MaterialSale.FMATERIALID = T_BD_MATERIAL.FMATERIALID WHERE T_BD_MATERIAL.FMATERIALID = @PKValue;
SELECT t_bd_MaterialPurchase.FEntryId, t_bd_MaterialPurchase.FPURCHASEUNITID, t_bd_MaterialPurchase.FPURCHASERID, t_bd_MaterialPurchase.FDEFAULTVENDORID, t_bd_MaterialPurchase.FISSOURCECONTROL, t_bd_MaterialPurchase.FISPR, t_bd_MaterialPurchase.FRECEIVEMINSCALE, t_bd_MaterialPurchase.FPURCHASEGROUPID, t_bd_MaterialPurchase.FRECEIVEMAXSCALE, t_bd_MaterialPurchase.FPURCHASEPRICEUNITID, t_bd_MaterialPurchase.FISVENDORQUALIFICATION, t_bd_MaterialPurchase.FRECEIVEADVANCEDAYS, t_bd_MaterialPurchase.FRECEIVEDELAYDAYS, t_bd_MaterialPurchase.FPURURNUM, t_bd_MaterialPurchase.FPURPRICEURNUM, t_bd_MaterialPurchase.FPURURNOM, t_bd_MaterialPurchase.FPURPRICEURNOM, t_bd_MaterialPurchase.FISQUOTA, t_bd_MaterialPurchase.FQUOTATYPE, t_bd_MaterialPurchase.FAGENTPURPLUSRATE, t_bd_MaterialPurchase.FCHARGEID, t_bd_MaterialPurchase.FMINSPLITQTY, t_bd_MaterialPurchase.FBASEMINSPLITQTY, t_bd_MaterialPurchase.FISVMIBUSINESS, t_bd_MaterialPurchase.FISRETURNMATERIAL, t_bd_MaterialPurchase.FMATERIALID FROM t_bd_MaterialPurchase INNER JOIN T_BD_MATERIAL ON t_bd_MaterialPurchase.FMATERIALID = T_BD_MATERIAL.FMATERIALID WHERE T_BD_MATERIAL.FMATERIALID = @PKValue;
SELECT t_BD_MaterialPlan.FEntryId, t_BD_MaterialPlan.FPLANERID, t_BD_MaterialPlan.FEOQ, t_BD_MaterialPlan.FPLANNINGSTRATEGY, t_BD_MaterialPlan.FORDERPOLICY, t_BD_MaterialPlan.FPLANWORKSHOP, t_BD_MaterialPlan.FFIXLEADTIMETYPE, t_BD_MaterialPlan.FFIXLEADTIME, t_BD_MaterialPlan.FVARLEADTIMETYPE, t_BD_MaterialPlan.FVARLEADTIME, t_BD_MaterialPlan.FCHECKLEADTIMETYPE, t_BD_MaterialPlan.FCHECKLEADTIME, t_BD_MaterialPlan.FORDERINTERVALTIMETYPE, t_BD_MaterialPlan.FORDERINTERVALTIME, t_BD_MaterialPlan.FPLANINTERVALSDAYS, t_BD_MaterialPlan.FPLANBATCHSPLITQTY, t_BD_MaterialPlan.FPLANTIMEZONE, t_BD_MaterialPlan.FREQUESTTIMEZONE, t_BD_MaterialPlan.FISMRPCOMREQ, t_BD_MaterialPlan.FRESERVETYPE, t_BD_MaterialPlan.FCANLEADDAYS, t_BD_MaterialPlan.FLEADEXTENDDAY, t_BD_MaterialPlan.FDELAYEXTENDDAY, t_BD_MaterialPlan.FCANDELAYDAYS, t_BD_MaterialPlan.FPLANOFFSETTIMETYPE, t_BD_MaterialPlan.FPLANOFFSETTIME, t_BD_MaterialPlan.FMINPOQTY, t_BD_MaterialPlan.FINCREASEQTY, t_BD_MaterialPlan.FMAXPOQTY, t_BD_MaterialPlan.FVARLEADTIMELOTSIZE, t_BD_MaterialPlan.FBASEVARLEADTIMELOTSIZE, t_BD_MaterialPlan.FPLANGROUPID, t_BD_MaterialPlan.FMFGPOLICYID, t_BD_MaterialPlan.FSUPPLYSOURCEID, t_BD_MaterialPlan.FTIMEFACTORID, t_BD_MaterialPlan.FQTYFACTORID, t_BD_MaterialPlan.FPLANMODE, t_BD_MaterialPlan.FALLOWPARTDELAY, t_BD_MaterialPlan.FALLOWPARTAHEAD, t_BD_MaterialPlan.FPLANSAFESTOCKQTY, t_BD_MaterialPlan.FMATERIALID FROM t_BD_MaterialPlan INNER JOIN T_BD_MATERIAL ON t_BD_MaterialPlan.FMATERIALID = T_BD_MATERIAL.FMATERIALID WHERE T_BD_MATERIAL.FMATERIALID = @PKValue;
SELECT t_BD_MaterialProduce.FEntryId, t_BD_MaterialProduce.FPICKSTOCKID, t_BD_MaterialProduce.FBOMUNITID, t_BD_MaterialProduce.FWORKSHOPID, t_BD_MaterialProduce.FISSUETYPE, t_BD_MaterialProduce.FPRODUCEUNITID, t_BD_MaterialProduce.FISKITTING, t_BD_MaterialProduce.FDEFAULTROUTING, t_BD_MaterialProduce.FISCOBY, t_BD_MaterialProduce.FPERUNITSTANDHOUR, t_BD_MaterialProduce.FBKFLTIME, t_BD_MaterialProduce.FFINISHRECEIPTOVERRATE, t_BD_MaterialProduce.FFINISHRECEIPTSHORTRATE, t_BD_MaterialProduce.FPICKBINID, t_BD_MaterialProduce.FPRDURNUM, t_BD_MaterialProduce.FPRDURNOM, t_BD_MaterialProduce.FBOMURNUM, t_BD_MaterialProduce.FBOMURNOM, t_BD_MaterialProduce.FISMAINPRD, t_BD_MaterialProduce.FISCOMPLETESET, t_BD_MaterialProduce.FOVERCONTROLMODE, t_BD_MaterialProduce.FMINISSUEQTY, t_BD_MaterialProduce.FSTDLABORPREPARETIME, t_BD_MaterialProduce.FSTDLABORPROCESSTIME, t_BD_MaterialProduce.FSTDMACHINEPREPARETIME, t_BD_MaterialProduce.FSTDMACHINEPROCESSTIME, t_BD_MaterialProduce.FCONSUMVOLATITITY, t_BD_MaterialProduce.FISPRODUCTLINE, t_BD_MaterialProduce.FPRODUCEBILLTYPE, t_BD_MaterialProduce.FORGTRUSTBILLTYPE, t_BD_MaterialProduce.FISMINISSUEQTY, t_BD_MaterialProduce.FMATERIALID FROM t_BD_MaterialProduce INNER JOIN T_BD_MATERIAL ON t_BD_MaterialProduce.FMATERIALID = T_BD_MATERIAL.FMATERIALID WHERE T_BD_MATERIAL.FMATERIALID = @PKValue;
SELECT t_BD_MaterialAuxPty.FEntryID, t_BD_MaterialAuxPty.FISENABLE, t_BD_MaterialAuxPty.FISMUSTINPUT, t_BD_MaterialAuxPty.FISAFFECTPRICE, t_BD_MaterialAuxPty.FISAFFECTPLAN, t_BD_MaterialAuxPty.FISAFFECTCOST, t_BD_MaterialAuxPty.FISCOMCONTROL, t_BD_MaterialAuxPty.FAUXPROPERTYID, t_BD_MaterialAuxPty.FVALUETYPE, t_BD_MaterialAuxPty.FVALUESET, t_BD_MaterialAuxPty.FMATERIALID FROM t_BD_MaterialAuxPty INNER JOIN T_BD_MATERIAL ON t_BD_MaterialAuxPty.FMATERIALID = T_BD_MATERIAL.FMATERIALID WHERE T_BD_MATERIAL.FMATERIALID = @PKValue;
SELECT t_BD_MaterialInvPty.FEntryID, t_BD_MaterialInvPty.FISENABLE, t_BD_MaterialInvPty.FISAFFECTPRICE, t_BD_MaterialInvPty.FISAFFECTPLAN, t_BD_MaterialInvPty.FISAFFECTCOST, t_BD_MaterialInvPty.FINVPTYID, t_BD_MaterialInvPty.FMATERIALID FROM t_BD_MaterialInvPty INNER JOIN T_BD_MATERIAL ON t_BD_MaterialInvPty.FMATERIALID = T_BD_MATERIAL.FMATERIALID WHERE T_BD_MATERIAL.FMATERIALID = @PKValue;
SELECT t_bd_MaterialSubcon.FEntryId, t_bd_MaterialSubcon.FSUBCONUNITID, t_bd_MaterialSubcon.FSUBCONPRICEUNITID, t_bd_MaterialSubcon.FSUBCONURNUM, t_bd_MaterialSubcon.FSUBCONURNOM, t_bd_MaterialSubcon.FSUBCONPRICEURNUM, t_bd_MaterialSubcon.FSUBCONPRICEURNOM, t_bd_MaterialSubcon.FSUBBILLTYPE, t_bd_MaterialSubcon.FMATERIALID FROM t_bd_MaterialSubcon INNER JOIN T_BD_MATERIAL ON t_bd_MaterialSubcon.FMATERIALID = T_BD_MATERIAL.FMATERIALID WHERE T_BD_MATERIAL.FMATERIALID = @PKValue;
SELECT T_BD_MATERIALQUALITY.FEntryId, T_BD_MATERIALQUALITY.FCHECKPRODUCT, T_BD_MATERIALQUALITY.FCHECKINCOMING, T_BD_MATERIALQUALITY.FINCSAMPSCHEMEID, T_BD_MATERIALQUALITY.FINCQCSCHEMEID, T_BD_MATERIALQUALITY.FCHECKSTOCK, T_BD_MATERIALQUALITY.FENABLECYCLISTQCSTK, T_BD_MATERIALQUALITY.FENABLECYCLISTQCSTKEW, T_BD_MATERIALQUALITY.FEWLEADDAY, T_BD_MATERIALQUALITY.FSTOCKCYCLE, T_BD_MATERIALQUALITY.FMATERIALID FROM T_BD_MATERIALQUALITY INNER JOIN T_BD_MATERIAL ON T_BD_MATERIALQUALITY.FMATERIALID = T_BD_MATERIAL.FMATERIALID WHERE T_BD_MATERIAL.FMATERIALID = @PKValue;
===================================================
调用堆栈：
Server stack trace:
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteReader(DbCommand command, IEnumerable`1 paramList, CommandBehavior cmdBehavior, Boolean bNewCn)
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteReader(DbCommand command, IEnumerable`1 paramList, CommandBehavior cmdBehavior)
at Kingdee.BOS.App.Data.DBUtils.ExecuteReader(Context ctx, String strSQL, IEnumerable`1 paramList, CommandType cmdtype, CommandBehavior cmdBehavior, Boolean bNewCn)
at Kingdee.BOS.App.Data.DBUtils.ExecuteReader(Context ctx, String strSQL, IEnumerable`1 paramList, CommandType cmdtype, Boolean bNewCn)
at Kingdee.BOS.App.Data.OLEDbDriver.ExecuteReader(SelectCallback callback, IEnumerable`1 tablesSchema, DbMetadataTable rootTable, IList`1 selectSqls, ReadWhere where, OperateOption option)
at Kingdee.BOS.Orm.Drivers.DbDriverBase.Select(SelectCallback callback, IEnumerable`1 tablesSchema, DbMetadataTable rootTable, ReadWhere where, OperateOption option)
at Kingdee.BOS.Orm.DataManager.DataManagerImplement.Read(ReadWhere where, OperateOption option)
at Kingdee.BOS.Orm.DataManager.DataManagerImplement.Read(Object oid, OperateOption option)
at Kingdee.BOS.App.Core.BusinessDataReader.LoadSingle(Object pk, BusinessInfo businessInfo, OQLFilter oFilter, Boolean loadReferenceData)
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.IViewService.LoadSingle(Context ctx, Object pk, BusinessInfo businessInfo, OQLFilter ofilter)
at Kingdee.BOS.ServiceHelper.BusinessDataServiceHelper.LoadSingle(Context ctx, Object pk, BusinessInfo businessInfo, OQLFilter ofilter)
at Kingdee.BOS.Business.Bill.Service.Tax.TaxService.GetTaxRateFromType(Context ctx, ResultFromType resultFromType, TaxRuleConditionParam param)
at Kingdee.BOS.Business.Bill.Service.Tax.TaxService.GetTaxRuleResult(TaxRuleConditionParam param, Context ctx)
at Kingdee.BOS.Business.DynamicForm.BusinessService.TaxRuleService.SetDefaultTaxRate(Int32 row, Boolean isMtlInvoke)
at Kingdee.BOS.Business.DynamicForm.BusinessService.TaxRuleService.InvokeTaxSetValue(FormBusinessServiceArgs e)
at Kingdee.BOS.Business.DynamicForm.BusinessService.TaxRuleService.DoAction(FormBusinessServiceArgs e)
at Kingdee.BOS.Core.DynamicForm.FormBusinessServiceUtil.InvokeServices(IDynamicFormView view, Object source, IEnumerable`1 services, Int32 actionType, String activeEntity, DynamicObject activeRow, Int32 rowIndex)
at Kingdee.BOS.Web.DynamicForm.BusinessServiceCaller.InvokeFormBusiness(IDynamicFormView view, Object source, List`1 formBusinessServices, Int32 actionType, String entityKey, Int32 row)
at Kingdee.BOS.Web.DynamicForm.BusinessServiceCaller.CallUpdateBusinessService(FieldAppearance fieldAppearance, Int32 row)
at Kingdee.BOS.Web.DynamicForm.DynamicWebFormView.SetItemValueByIDFromClient(String key, Object id, Int32 row)
at Kingdee.BOS.Web.DynamicForm.DynamicWebFormController.SetItemValueByIDFromClient(String key, Object id, Int32 row, JSONArray postDatas)
推荐阅读