专业版录入销售订单,保存提示客户BOM不能为空

栏目:kis知识作者:金蝶来源:金蝶云社区发布:2024-09-16浏览:1

专业版录入销售订单,保存提示客户BOM不能为空

如题,看图

是哪里有问题?


总部给的两条语句:

1、alter table t_ICItemCustom add [FBatchCreate] [bit] NULL

2、

ALTER VIEW [dbo].[t_ICItem] AS   

 SELECT   

 t0.FItemID,t0.FISVID,t0.FName,t0.FHelpCode,t0.FDeleted,t0.FShortNumber,t0.FNumber,t0.FModifyTime,  

 t0.FParentID,t0.FBrNo,t0.FTopID,t0.FRP,t0.FOmortize,t0.FOmortizeScale,t0.FForSale,  

 t0.FStaCost,t0.FOrderPrice,t0.FOrderMethod,t0.FPriceFixingType,t0.FSalePriceFixingType,  

 t0.FPerWastage,t0.FARAcctID,t0.FPlanPriceMethod,t0.FPlanClass,t0.FModel,t0.FItemDescription,  

 t1.FAlias,t1.FApproveNo,t1.FAuxClassID,t1.FDefaultLoc,t1.FEquipmentNum,t1.FErpClsID,  

 t1.FFullName,t1.FHighLimit,t1.FIsEquipment,t1.FIsSparePart,t1.FLowLimit,  

 t1.FOrderUnitID,t1.FPreDeadLine,t1.FProductUnitID,t1.FQtyDecimal,t1.FSaleUnitID,  

 t1.FSecCoefficient,t1.FSecUnitDecimal,t1.FSecInv,t1.FSecUnitID,t1.FSerialClassID,t1.FSource,t1.FSPID,  

 t1.FStoreUnitID,t1.FTypeID,t1.FUnitGroupID,t1.FUnitID,t1.FUseState,t2.FABCCls,t2.FAcctID,t2.FAdminAcctID,t2.FAPAcctID,t2.FBatchManager,t2.FBatchQty,t2.FBeforeExpire,  

 t2.FBookPlan,t2.FCheckCycle,t2.FCheckCycUnit,t2.FClass,t2.FCostAcctID,t2.FCostDiffRate,  

 t2.FCostProject,t2.FDaysPer,t2.FDepartment,t2.FGoodSpec,t2.FISKFPeriod,t2.FIsSale,  

 t2.FIsSnManage,t2.FIsSpecialTax,t2.FKFPeriod,t2.FLastCheckDate,t2.FNote,t2.FOIHighLimit,  

 t2.FOILowLimit,t2.FOrderRector,t2.FPlanPrice,t2.FPOHghPrcMnyType,t2.FPOHighPrice,  

 t2.FPriceDecimal,t2.FProfitRate,t2.FSaleAcctID,t2.FSalePrice,t2.FSaleTaxAcctID,  

 t2.FSOHighLimit,t2.FSOLowLimit,t2.FSOLowPrc,t2.FSOLowPrcMnyType,t2.FStockPrice,t2.FStockTime,  

 t2.FTaxRate,t2.FTrack,t2.FWWHghPrc,t2.FWWHghPrcMnyType,t2.FCBBmStandardID,  

 t3.FBatChangeEconomy,t3.FBatchAppendQty,t3.FBatFixEconomy,t3.FCUUnitID,t3.FDailyConsume,  

 t3.FDefaultRoutingID,t3.FDefaultWorkTypeID,t3.FFixLeadTime,t3.FInHighLimit,  

 t3.FInLowLimit,t3.FLeadTime,t3.FLowestBomCode,t3.FMRPCon,t3.FOrderInterVal,  

 t3.FOrderPoint,t3.FOrderTrategy,t3.FPlanner,t3.FPlanPoint,t3.FPlanTrategy,t3.FProductPrincipal,  

 t3.FPutInteger,t3.FQtyMax,t3.FQtyMin,t3.FRequirePoint,t3.FTotalTQQ,t3.FMRPOrder,t7.FBatchCreate,t4.FChartNumber,t4.FCubicMeasure,t4.FGrossWeight,t4.FHeight,t4.FIsKeyItem,t4.FLength,t4.FMaund,  

 t4.FNetWeight,t4.FSize,t4.FVersion,t4.FWidth,  

 t5.FChgFeeRate,t5.FOutMachFee,t5.FPieceRate,t5.FStandardCost,t5.FStandardManHour,  

 t5.FStdFixFeeRate,t5.FStdPayRate,  

 t6.FIdentifier,t6.FInspectionLevel,t6.FInspectionProject,  

 t6.FIsListControl,t6.FOtherChkMde,t6.FProChkMde,t6.FSOChkMde,t6.FStkChkAlrm,  

 t6.FStkChkMde,t6.FStkChkPrd,t6.FWthDrwChkMde,t6.FWWChkMde  FROM t_ICItemCore t0  

 LEFT JOIN t_ICItemBase t1 ON t0.FItemID=t1.FItemID  

 LEFT JOIN t_ICItemMaterial t2 ON t0.FItemID=t2.FItemID  

 LEFT JOIN t_ICItemPlan t3 ON t0.FItemID=t3.FItemID  

 LEFT JOIN t_ICItemDesign t4 ON t0.FItemID=t4.FItemID   

 LEFT JOIN t_ICItemStandard t5 ON t0.FItemID=t5.FItemID  

 LEFT JOIN t_ICItemQuality t6 ON t0.FItemID=t6.FItemID  

 LEFT JOIN t_ICItemCustom t7 ON t0.FItemID=t7.FItemID

 

GO



也遇到同样的问题,重新复制出来一遍就可以了
复制一下再保存就没事了
你好 ,可以详细描述下操作步骤以及专业版什么版本

专业版录入销售订单,保存提示客户BOM不能为空

如题,看图是哪里有问题?总部给的两条语句:1、alter table t_ICItemCustom add [FBatchCreate] [bit] NULL2、ALTER VIEW [dbo].[t...
点击下载文档
分享:
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息