发布时间:2025-12-16
特价活动:>>>> 用友U8、T6、T+、T3软件产品4折优惠,畅捷通T+cloud、好会计、好业财、好生意云产品6-8折优惠,另有话费赠送。
IO-2017-01-1856、IO-2017-01-1983号销售出库单已经生成了销货单了,但是销售出库 单界面不显示已销货标识,而且在销售出库单列表查询未销货单据的时候,还是能够筛选出来该单据,同样问题的单据有很多张。
问题回复:
请备份后执行以下脚本
--查询select * from ST_RDRecordwhere idvouchertype in (select id from SM_VoucherType where code in('ST1021','SYS0932')) and id in (select idRDRecordDTO from ST_RDRecord_b where abs(isnull(quantity,0))<=abs(isnull(cumulativeSaleDispatchQuantity,0)))and deliveryState <> 'C7BDF907-F9DF-41FC-8F98-E4E5C2A920B7'
--更新update ST_RDRecord set deliveryState = 'C7BDF907-F9DF-41FC-8F98-E4E5C2A920B7'where idvouchertype in (select id from SM_VoucherType where code in('ST1021','SYS0932')) and id in (select idRDRecordDTO from ST_RDRecord_b where abs(isnull(quantity,0))<=abs(isnull(cumulativeSaleDispatchQuantity,0)))and deliveryState <> 'C7BDF907-F9DF-41FC-8F98-E4E5C2A920B7'
截屏,微信识别二维码
客服QQ:5151867
(点击QQ号复制,添加好友)