问题现象: | 系统里边销售订单低于最低售价是不允许保存的,希望能实现单据保存时给与提醒,审核时给予控制 |
问题原因: | |
解决方案: | 您好, 下面触发器在销售订单新增/保存时比较订单本币单价和存货档案的最低售价,如果低于最低售价,将表体自定义12写入'超最低售价': if exists (select * from sysobjects where id = object_id('Insert_iInvLSCost') and xtype='tr') drop trigger Insert_iInvLSCost go create trigger Insert_iInvLSCost on so_sodetails for insert,update as SET NOCOUNT ON update so_sodetails set cdefine33=(case when isnull(so_sodetails.inatunitprice,0) inner join inserted on inserted.isosid=so_sodetails.isosid inner join inventory on inventory.cinvcode=so_sodetails.cinvcode SET NOCOUNT OFF GO 如有问题,请及时与我沟通联系。 |
相关补丁: | |
版本: | U8 V10.0 |
模块: | 销售管理 |
产品: | 供应链 |
问题名称: | 最低售价 |
最后更新: | 2012-01-23 23:56:17 |