问题现象: | 问题号201111080106,客户的版本是890的,不是10.0的,烦请在处理下。 |
问题原因: | |
解决方案: | 您好, 此问题【经查看数据/测试】现做如下分析与答复: 【解决方案】 开发重新编写了脚本 --在Data库中执行,不能发通版补丁 alter TRIGGER [dbo].[updatefoutquantity] ON [dbo].[DispatchLists] FOR Update as SET NOCOUNT ON if update(foutquantity) or update(foutnum) begin if exists(select top 1 dispatchlists.idlsid from dispatchlists inner join inserted on dispatchlists.idlsid=inserted.idlsid where abs(isnull(dispatchlists.fOutQuantity,0))-abs(ISNULL(dispatchlists.iretquantity ,0)) --在Data库中执行,不能发通版补丁 alter TRIGGER [dbo].[updatefoutquantity] ON [dbo].[DispatchLists] FOR Update as SET NOCOUNT ON if update(foutquantity) or update(foutnum) begin if exists(select top 1 dispatchlists.idlsid from dispatchlists inner join inserted on dispatchlists.idlsid=inserted.idlsid where abs(isnull(dispatchlists.fOutQuantity,0))-abs(ISNULL(dispatchlists.iretquantity ,0)) RAISERROR ('出库数量不能小于累计开票数量', 16, -- Severity. 1 -- State. ); update so_sodetails set foutquantity= isnull(so_sodetails.foutquantity,0)-isnull(b.foutquantity,0)+isnull(a.foutquantity,0), so_sodetails.foutnum = isnull(so_sodetails.foutnum,0) -isnull(b.foutnum,0) +isnull(a.foutnum,0) from so_sodetails inner join (select isosid,sum(isnull(inserted.foutquantity,0)) as foutquantity,sum(isnull(inserted.foutnum,0)) as foutnum from inserted group by isosid) a on so_sodetails.isosid=a.isosid inner join (select isosid,sum(isnull(deleted.foutquantity,0)) as foutquantity,sum(isnull(deleted.foutnum,0)) as foutnum from deleted group by isosid) b on so_sodetails.isosid=b.isosid SET NOCOUNT OFF end go |
相关补丁: | |
版本: | 8.90 |
模块: | 销售管理 |
产品: | 供应链 |
问题名称: | 【双百项目】问题号201111080106 |
最后更新: | 2011-12-05 23:41:05 |