资产检验单下推
问题描述:
资产采购订单下推资产检验单时,原本的逻辑是按照检验单的送检数量进行下推控制,能否控制以检验单的合格数量进行下推?
解决方案:
资产采购订单下推资产检验单时,原本的逻辑是按照检验单的送检数量进行下推控制,可执行以下脚本改为以合格数量进行下推控制
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
资产检验单下推
本文2024-09-22 14:23:31发表“k3wise知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3wise-74741.html