电脑桌面
添加蚂蚁七词文库到电脑桌面
已经有10万+用户把蚂蚁七词文库添加到电脑桌面，以后点击桌面图标一键打开，无需搜索，非常快捷！
上传文档
开通会员限时优惠
充值
登录  |  注册
首页文章金蝶知识文章云星空知识物料更新同步物料清单报错的解决方案

物料更新同步物料清单报错的解决方案

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

物料更新同步物料清单报错的解决方案

    物料修改后可能存在需要更新相关信息到物料清单中，在更新向导中可能有很多种报错，比如可能出现报错关键字：'计算出现错误:source:Kingdee.K3.MFG.ENG.Business.Pluglnmessage:未将对象引用设置到对象的实例。stacktrace: 在 Kingdee.K3.MFG.ENG.Business.Plugln.DynamicForm,WizardForm.MatelnfoEditsyncBomWizardPlugin.RunsimulationBom0在System,Threading.Tasks.Task,Execute()'。如下图1-1所示：

image.webp

图1-1


    如果存在上面的报错，则可能与供应链之前添加受托加工材料清单功能时覆盖了'制造字段映射模型'有关。建议按以下脚本逐步修复：

1，通过语句 SELECT FID FROM T_MFG_BILLLINK WHERE FBILLNO = 'SAL_OEMBOM_SAVE';

查询下受托加工材料清单对应的'制造字段映射模型'的FID是否为42301，如果是，则说明有冲突（如果是报上图1-1的错，则一般都是 SAL_OEMBOM_SAVE 覆盖了 ENG_BomEntryToMate，FID为42301的是ENG_BomEntryToMate 的映射模型，它和物料更新同步物料清单有关）。


2，删除受托加工材料清单的'制造字段映射模型'，SQL语句如下：

DELETE T_MFG_BILLLINKENTRY WHERE FID = (SELECT FID FROM T_MFG_BILLLINK WHERE FBILLNO='SAL_OEMBOM_SAVE');

DELETE T_MFG_BILLLINK WHERE FBILLNO='SAL_OEMBOM_SAVE';


3，添加受托加工材料清单的'制造字段映射模型'，这里FID占用42302(使用前请确保此值没有被占用，一般这个ID是和制造没有冲突的)，也可根据实体情况替换使用适当值替换42302，语句如下：

-- 受托加工材料清单 映射模型 表头

INSERT INTO T_MFG_BILLLINK(FID,FFORMID,FBILLNO,FDATE,FDOCUMENTSTATUS,FCREATORID,FCREATEDATE,FMODIFIERID,FMODIFYDATE,FAPPROVERID,FAPPROVEDATE,FCANCELER,FCANCELDATE,FCANCELSTATUS,FSRCFORMID,FDSTFORMID,FSRCCONTROLENTITY,FDSTFILTER) 

VALUES (42302,'MFG_BILLFIELDLINK',N'SAL_OEMBOM_SAVE',null,'C',110,{ts'2021-08-10  00:00:00'},133937,{ts'2021-08-10  00:00:00'},0,null,0,null,'A','SAL_OEMBOM','ENG_BomExpandBill',' ',' ') ;


-- 受托加工材料清单 映射模型 明细

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95000,42302,1,'FEntity',N'子项明细','FAuxPropID',N'辅助属性','FBomResult',N'BOM展开结果表','FAuxPropId','0',N'辅助属性') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95001,42302,2,'FEntity',N'子项明细','FBASEBOMDENOMINATOR',N'基本单位原分母','FBomResult',N'BOM展开结果表','FAccuDenominator','0',N'基本单位用量:累积分母') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95002,42302,3,'FEntity',N'子项明细','FBaseBOMNumerator',N'基本单位原分子','FBomResult',N'BOM展开结果表','FAccuNumerator','0',N'基本单位用量:累积分子') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95003,42302,4,'FEntity',N'子项明细','FBASEDENOMINATOR',N'基本单位分母','FBomResult',N'BOM展开结果表','FAccuDenominator','0',N'基本单位用量:累积分母') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95004,42302,5,'FEntity',N'子项明细','FBaseFixScrapQTY',N'基本单位固定损耗数量','FBomResult',N'BOM展开结果表','FBaseFixScrapQty','0',N'基本单位固定损耗') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95005,42302,6,'FEntity',N'子项明细','FBaseNumerator',N'基本单位分子','FBomResult',N'BOM展开结果表','FAccuNumerator','0',N'基本单位用量:累积分子') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95006,42302,7,'FEntity',N'子项明细','FBaseStdQty',N'基本单位标准用量','FBomResult',N'BOM展开结果表','FBaseQty','0',N'基本单位标准子项用量') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95007,42302,8,'FEntity',N'子项明细','FBaseUnitID1',N'子项基本单位','FBomResult',N'BOM展开结果表','FBaseUnitId2','0',N'子项基本单位') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95008,42302,9,'FEntity',N'子项明细','FBOMDenominator',N'原分母','FBomResult',N'BOM展开结果表','FBillAccuDenominator','0',N'用量:累积分母') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95009,42302,10,'FEntity',N'子项明细','FBOMEntryID',N'BOM分录内码','FBomResult',N'BOM展开结果表','FBomEntryId','0',N'子项分录号') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95010,42302,11,'FEntity',N'子项明细','FBomId2',N'BOM版本','FBomResult',N'BOM展开结果表','FBomId2','0',N'BOM') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95011,42302,12,'FEntity',N'子项明细','FBOMNumerator',N'原分子','FBomResult',N'BOM展开结果表','FBillAccuNumerator','0',N'用量:累积分子') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95012,42302,13,'FEntity',N'子项明细','FDenominator',N'分母','FBomResult',N'BOM展开结果表','FBillAccuDenominator','0',N'用量:累积分母') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95013,42302,14,'FEntity',N'子项明细','FFixScrapQty',N'固定损耗','FBomResult',N'BOM展开结果表','FFixScrapQty','0',N'固定损耗') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95014,42302,15,'FEntity',N'子项明细','FIsKeyItem',N'替代主料','FBomResult',N'BOM展开结果表','FIsSubsKeyItem','0',N'是否替代主料') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95015,42302,16,'FEntity',N'子项明细','FIsSkip',N'跳层','FBomResult',N'BOM展开结果表','FISSkip','0',N'是否跳层行') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95016,42302,17,'FEntity',N'子项明细','FIssueType',N'发料方式','FBomResult',N'BOM展开结果表','FISSUETYPE','0',N'发料方式') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95017,42302,18,'FEntity',N'子项明细','FMaterialID2',N'子项物料编码','FBomResult',N'BOM展开结果表','FMaterialId2','0',N'子项物料') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95018,42302,19,'FEntity',N'子项明细','FMaterialType',N'子项类型','FBomResult',N'BOM展开结果表','FMaterialType','0',N'子项类型') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95019,42302,20,'FEntity',N'子项明细','FNumerator',N'分子','FBomResult',N'BOM展开结果表','FBillAccuNumerator','0',N'用量:累积分子') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95020,42302,21,'FEntity',N'子项明细','FOwnerID',N'货主','FBomResult',N'BOM展开结果表','FOWNERID','0',N'货主') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95021,42302,22,'FEntity',N'子项明细','FOwnerTypeId',N'货主类型','FBomResult',N'BOM展开结果表','FOWNERTYPEID','0',N'货主类型') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95022,42302,23,'FEntity',N'子项明细','FReplaceGroup',N'项次','FBomResult',N'BOM展开结果表','FReplaceGroup','0',N'项次') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95023,42302,24,'FEntity',N'子项明细','FRowId',N'行标识','FBomResult',N'BOM展开结果表','FRowId2','0',N'行标识') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95024,42302,25,'FEntity',N'子项明细','FScrapRate',N'变动损耗率%','FBomResult',N'BOM展开结果表','FScrapRate','0',N'变动损耗') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95025,42302,26,'FEntity',N'子项明细','FStdQty',N'标准用量','FBomResult',N'BOM展开结果表','FQty','0',N'子项用量') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95026,42302,27,'FEntity',N'子项明细','FStockID',N'仓库','FBomResult',N'BOM展开结果表','FSTOCKID','0',N'默认发料仓库') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95027,42302,28,'FEntity',N'子项明细','FStockLOCID',N'仓位','FBomResult',N'BOM展开结果表','FSTOCKLOCID','0',N'默认发料仓位') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95028,42302,29,'FEntity',N'子项明细','FUnitID2',N'子项单位','FBomResult',N'BOM展开结果表','FUnitID2','0',N'子项单位') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95029,42302,30,'FEntity',N'子项明细','FErpClsID',N'物料属性','FBomResult',N'BOM展开结果表','FErpClsId','0',N'物料属性') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95030,42302,31,'FEntity',N'子项明细','FDosageType',N'用量类型','FBomResult',N'BOM展开结果表','FDosageType','0',N'用量类型') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95031,42302,32,'FEntity',N'子项明细','FBaseQty',N'基本单位子项数量','FBomResult',N'BOM展开结果表','FBaseActualQty','0',N'基本单位实际子项用量') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95032,42302,33,'FEntity',N'子项明细','FQty',N'子项数量','FBomResult',N'BOM展开结果表','FQty','0',N'子项用量') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95033,42302,34,'FEntity',N'子项明细','FSupplyOrgId',N'供应组织','FBomResult',N'BOM展开结果表','FSupplyOrgId','0',N'供应组织') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95034,42302,35,'FEntity',N'子项明细','FBOMLevel',N'BOM级次','FBomResult',N'BOM展开结果表','FBomLevel','0',N'BOM级次') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95035,42302,36,'FEntity',N'子项明细','FDetailSeq',N'排序序号','FBomResult',N'BOM展开结果表','FPathEntrySeq','0',N'BOM展开序号') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95036,42302,37,'FEntity',N'子项明细','FChildStockOrgId',N'库存组织','FBomResult',N'BOM展开结果表','FPickOrgId','0',N'发料组织') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (95037,42302,38,'FEntity',N'子项明细','FMEMO',N'备注','FBomResult',N'BOM展开结果表','FMemo','0',N'子项备注') ;


4，根据步骤1查询出来的冲突值，还原有冲突的'制造字段映射模型'，比如上面说的42301，则需要恢复ENG_BomEntryToMate 对应的映射模型，恢复脚本如下：

DELETE T_MFG_BILLLINK WHERE FID = 42301;

INSERT INTO T_MFG_BILLLINK(FID,FFORMID,FBILLNO,FDATE,FDOCUMENTSTATUS,FCREATORID,FCREATEDATE,FMODIFIERID,FMODIFYDATE,FAPPROVERID,FAPPROVEDATE,FCANCELER,FCANCELDATE,FCANCELSTATUS,

FSRCFORMID,FDSTFORMID,FSRCCONTROLENTITY,FDSTFILTER) 

VALUES (42301,'MFG_BILLFIELDLINK',N'ENG_BomEntryToMate',null,'C',100063,{ts'2021-02-23  16:43:46'},100063,{ts'2021-02-23  16:43:47'},100063,

{ts'2021-02-23  16:43:50'},0,null,'A','ENG_BOM','BD_MATERIAL','FTreeEntity',' ') ;


DELETE T_MFG_BILLLINKENTRY WHERE  FID = 42301;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (91200,42301,11,'FTreeEntity',N'子项明细','FTIMEUNIT',N'时间单位','SubHeadEntity4',N'计划','FPlanOffsetTimeType','0',N'时间单位') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (91201,42301,1,'FTreeEntity',N'子项明细','FBACKFLUSHTYPE',N'倒冲时机','SubHeadEntity5',N'生产','FBKFLTime','0',N'倒冲时机') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (91202,42301,2,'FTreeEntity',N'子项明细','FFIXSCRAPQTY',N'固定损耗','SubHeadEntity5',N'生产','FFIXLOSS','0',N'固定损耗') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (91203,42301,3,'FTreeEntity',N'子项明细','FISKEYCOMPONENT',N'是否关键件','SubHeadEntity5',N'生产','FIsKitting','0',N'是否关键件') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (91204,42301,4,'FTreeEntity',N'子项明细','FISMinIssueQty',N'领料考虑最小发料批量','SubHeadEntity5',N'生产','FISMinIssueQty','0',N'领料考虑最小发料批量') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (91205,42301,5,'FTreeEntity',N'子项明细','FISSUETYPE',N'发料方式','SubHeadEntity5',N'生产','FIssueType','0',N'发料方式') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (91206,42301,6,'FTreeEntity',N'子项明细','FOFFSETTIME',N'偏置时间','SubHeadEntity4',N'计划','FPlanOffsetTime','0',N'偏置时间') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (91207,42301,7,'FTreeEntity',N'子项明细','FOverControlMode',N'超发控制方式','SubHeadEntity5',N'生产','FOverControlMode','0',N'超发控制方式') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (91208,42301,8,'FTreeEntity',N'子项明细','FSCRAPRATE',N'变动损耗率%','SubHeadEntity5',N'生产','FLOSSPERCENT','0',N'变动损耗率(%)') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (91209,42301,9,'FTreeEntity',N'子项明细','FSTOCKID',N'默认发料仓库','SubHeadEntity5',N'生产','FPickStockId','0',N'发料仓库') ;

INSERT INTO T_MFG_BILLLINKENTRY(FENTRYID,FID,FSEQ,FSRCENTITYKEY,FSRCENTITYNAME,FSRCFIELDKEY,FSRCFIELDNAME,FDSTENTITYKEY,FDSTENTITYNAME,FDSTFIELDKEY,FMAPTYPE,FDSTFIELDNAME) VALUES (91210,42301,10,'FTreeEntity',N'子项明细','FSTOCKLOCID',N'默认发料仓位','SubHeadEntity5',N'生产','FPickBinId','0',N'发料仓位') ;


以上脚本执行后，需要清空缓存才能生效（或者直接重启IIS）


下图1-2是正常的制造字段映射模型

image.webp

图1-2


物料更新同步物料清单报错的解决方案

物料修改后可能存在需要更新相关信息到物料清单中，在更新向导中可能有很多种报错，比如可能出现报错关键字：'计算出现错误:source:Kin...
点击下载文档
标签： # 金蝶云·星空# 金蝶云·星空-供应链云# 金蝶云·星空-制造云# 金蝶云·星空实施
分享：
上一篇：快递100如何取消物流订阅推送下一篇：成本计算，检查报告提示未关账的错误，如何改成警告
本文2024-09-16 18:08:21发表“云星空知识”栏目。
本文链接：https://wenku.my7c.com/article/kingdee-k3cloud-20195.html

相关文章

最新文档
热门文章

阅读排行

热门标签
# 金蝶云·星空# 金蝶云·星空实施# 金蝶云·星空-BOS平台# EAS Cloud-知识分享# 金蝶云·星空-供应链云# EAS Cloud-财务# K/3 WISE-供应链# K/3 WISE# 金蝶云·星空-基础架构# 专业版-财务问题# 专业版-环境部署# 专业版-进销存问题# 旗舰版-财务会计# EAS Cloud-BOS工具与平台# EAS Cloud-供应链# 金蝶s-HR-组织人事# K/3 WISE-财务# 商贸版-问题反馈# EAS Cloud-基础服务# 金蝶云·星空-学习笔记
一键复制下载文档联系客服
确认删除?
取消确定
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息