专业版录入销售订单,保存提示客户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不能为空
本文2024-09-16 19:55:27发表“kis知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-kis-31777.html