CLOUD7.0
销售订单中,通过收款计划控制采购申请。
现在有二个问题需要解决:
问题1、收款计划中:预收比例实收款>=应收款的90%并小于应收款时,可以下推采购申请。之前的解决方案:
修改一下,见红字处
FBaseUnitQty> FBasePurJoinQty And
not exists (select 1 from t_sal_orderPlan a inner join
(select sum(a.FRECADVANCEAMOUNT) as FRecAdvanceAmount,sum(a.FRecAmount) as FRecAmount,a.FID
from t_sal_OrderPlan a inner join t_sal_orderPlan b on a.FID=b.FID and a.FSeq<=b.FSeq
where a.FControlSend='PURCHASE' and b.FControlSend='PURCHASE' and a.FID=b.FID
group by a.FID) b on a.FID=b.FID where b.Frecadvanceamount<>b.FRecAmount and a.FId=FID)
参考贴子:
https://vip.kingdee.com/article/37963
问题2:销售订单中有二个字段: 运营价(自定义增加的) 、运营附加价(自定义字段)
当问题1中的:收款计划中:预收比例实收款>=应收款的90%并小于应收款,生成采购申请后, 当该类型的销售订单关闭状态时, 销售订单中的运营附加价,更新字段:运营附加价=运营单价+运营单价*10%
推荐阅读