|
问题现象:期初发货单除了不会再去生成销售出库单以外,和发货单还有什么区别?为什么我做了一个触发器(当发货单上价格为空时,自动将价格改为0),期初发货单保存时报错“本单据已被修改或网络冲突”,而发货单保存时就没有问题。
触发器如下:
creaTe Trigger fahuo_inserT_xxxx
on dispaTchlisTs
afTer inserT
as
updaTe dispaTchlisTs seT iSum = 0 , iUniTPrice = 0 , iTaxUniTPrice = 0, imoney = 0 , iTax = 0 from dispaTchlisTs,inserTed
where dispaTchlisTs.DLID=inserTed.DLID and dispaTchlisTs.iSum is null and dispaTchlisTs.iUniTPrice is null and
dispaTchlisTs.iTaxUniTPrice is null and dispaTchlisTs.imoney is null and dispaTchlisTs.iTax is null
问题模块:用友T6销售管理
详细问题描述:在用友T6企业管理件的销售管理模块中碰到如下问题,期初发货单除了不会再去生成销售出库单以外,和发货单还有什么区别?为什么我做了一个触发器(当发货单上价格为空时,自动将价格改为0),期初发货单保存时报错“本单据已被修改或网络冲突”,而发货单保存时就没有问题。
触发器如下:
creaTe Trigger fahuo_inserT_xxxx
on dispaTchlisTs
afTer inserT
as
updaTe dispaTchlisTs seT iSum = 0 , iUniTPrice = 0 , iTaxUniTPrice = 0, imoney = 0 , iTax = 0 from dispaTchlisTs,inserTed
where dispaTchlisTs.DLID=inserTed.DLID and dispaTchlisTs.iSum is null and dispaTchlisTs.iUniTPrice is null and
dispaTchlisTs.iTaxUniTPrice is null and dispaTchlisTs.imoney is null and dispaTchlisTs.iTax is null
|
|