资产检验单下推

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

资产检验单下推

问题描述:

资产采购订单下推资产检验单时,原本的逻辑是按照检验单的送检数量进行下推控制,能否控制以检验单的合格数量进行下推?

解决方案:

资产采购订单下推资产检验单时,原本的逻辑是按照检验单的送检数量进行下推控制,可执行以下脚本改为以合格数量进行下推控制 

Delete from ICClassLinkEntry WHERE FSourClassTypeID=1200002 AND FDestClassTypeID=1200003 AND FSourFKey ='FQty' 

GO 

INSERT INTO ICClassLinkEntry(FSourClassTypeID,FDestClassTypeID,FSourPage,FSourFKey,FDestPage,FDestFKey,FIsCheck,FIsGroup,FIsFilter,FDoAction,FAllowModified,FCheckStatCol,FHaveCheckCol,FISUserDefine,FControl,FRedNeg,FBeforeFormula,FAfterFormula,FSourTypeID,FDestTypeID) VALUES (1200002,1200003,2,'FQty',2,'FInspecQty',-1,0,0,0,1,'','',1,0,0,'','',0,0) 

GO 

INSERT INTO ICClassLinkEntry(FSourClassTypeID,FDestClassTypeID,FSourPage,FSourFKey,FDestPage,FDestFKey,FIsCheck,FIsGroup,FIsFilter,FDoAction,FAllowModified,FCheckStatCol,FHaveCheckCol,FISUserDefine,FControl,FRedNeg,FBeforeFormula,FAfterFormula,FSourTypeID,FDestTypeID) VALUES (1200002,1200003,2,'FQty',2,'FQualifiedQty',1,0,0,0,1,'','',0,0,0,'','',0,0) 

GO 

UPDATE ICClassType set FName_CHS=FName_CHS 

GO

资产检验单下推

问题描述:资产采购订单下推资产检验单时,原本的逻辑是按照检验单的送检数量进行下推控制,能否控制以检验单的合格数量进行下推?解决方案...
点击下载文档
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息