发布时间:2025-12-16
特价活动:>>>> 畅云管家新购、续费7折优惠,畅捷通T+cloud、好会计、易代账、好业财、好生意云产品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'
客服电话:400-665-0028
关键字:用友财务软件,畅捷通软件,财务软件,进销存软件,U9官网,用友U8,用友T1,用友T+,用友T3,用友T6,畅捷通好会计,好生意,智+好业财,用友培训服务售后公司,畅捷通运营培训服务公司
版权所有:用友畅捷通软件 Copyright © 2026 All rights reserved.