K3 采购订单变更单价金额同步更新收料通知/请检单（触发器）

增加触发器

ALTER TRIGGER [dbo].[ICOrderAlter_update]
   ON  [dbo].[ICOrderAlter]
   AFTER  INSERT,UPDATE
AS 


BEGIN

if exists(select 1 from   Inserted a
inner join POOrderEntry b on a.FInterID=b.finterid  
inner join POInStockEntry c  on b.finterid=c.FOrderInterID and b.fitemid=c.FItemID and b.FEntryID=c.FEntryID
where a.FBillType=71 )

update c set    c.FPrice=b.FPrice,c.FAmount=b.FAmount,c.FAuxPrice=b.FAuxPrice
from   Inserted a
inner join POOrderEntry b on a.FInterID=b.finterid  
inner join POInStockEntry c  on b.finterid=c.FOrderInterID and b.fitemid=c.FItemID and b.FEntryID=c.FEntryID
where a.FBillType=71

实现功能

原数据

点击菜单栏下的“订单变更”

进行变更

变更记录

单价金额已同步更新