kis旗舰版销售出库单单据编号能否从上游带过来?
服务热线:400-665-0027
新购有特价、金蝶老客户升级金蝶云产品可以享受5折优惠,送手机、送话费,好礼不断!
问题现象:
销售出库单单据编号能否将上游销售订单单据编号直接带过来???即销售出库单与销售订单单据编号一样,我试过取消启用销售出库单单据编号的编码方式,并且新增对应的转换规则,销售出库单单据编号直接为空,没有带过来,请问能否实现???
解决方案:
要在数据库加个触发,如下:
create trigger easy_230731_001 on icstockbill
for update,delete,insert
as
declare @finterid int
select @finterid=finterid from inserted
update t1
set t1.fbillno=t2.fsourcebillno
from icstockbill t1,icstockbillentry t2
where t1.finterid=t2.finterid and t2.fentryid='1' and t1.finterid=@finterid and t1.ftrantype='21'

