问题现象: | 采购发票参照A供应商的入库单后,在表头修改为供应商B,参照B的入库单,造成采购发票有两家供应商的数据,应该参照之后,不能修改供应商;现客户出现这种情况,无法控制。 |
问题原因: | |
解决方案: | 您好! 请执行以下脚本控制为发票参照多条入库单,如果供应商不一致,发票不允许保存 if exists(select name from sysobjects where name=N'PU_CheckBillVendorFromRD_TRI' and xtype=N'TR') drop trigger PU_CheckBillVendorFromRD_TRI GO --发票参照入库单生单,入库单供应商必须相同 create trigger PU_CheckBillVendorFromRD_TRI on purbillvouchs for insert,update as declare @iCount int -- select @iCount=count(*) from purbillvouch b join purbillvouchs bs on b.pbvid=bs.pbvid -- join rdrecords01 rs on rs.autoid=bs.rdsid -- join rdrecord01 r on rs.id=r.id -- where r.cvouchtype=N'01' and b.cvencode<>r.cvencode -- and b.pbvid in (select pbvid from inserted where rdsid is not null) select @iCount=count(*) from purbillvouch b join purbillvouchs bs on b.pbvid=bs.pbvid join rdrecords rs on rs.autoid=bs.rdsid join rdrecord r on rs.id=r.id where r.cvouchtype=N'01' and b.cvencode<>r.cvencode and b.pbvid in (select pbvid from inserted where rdsid is not null) if @iCount>0 begin raiserror(N'发票供应商与入库单供应商不一致,不能保存!',16,1) return end GO --如有问题请及时反馈, |
相关补丁: | |
版本: | 8.90 |
模块: | 采购管理 |
产品: | 供应链 |
问题名称: | 采购发票参照不同供应商 |
最后更新: | 2011-09-05 17:32:10 |