T+采购订单弃审提示：存货xxx信息已发生修改，不允许此操作！
T+-采购管理【问题现象】
采购订单弃审时提示：存货【XXX】信息已发生修改，不允许此操作！
https://o.oyonyou.com:9600/chanjet/guide/T+/37940/1_qazdo3ndj1j.webp
【问题分析】
采购订单的表体明细的计量单位和存货档案的计量单位不符，数据识别报错，导致单据单据无法弃审。
【操作步骤】：
1、进入数据库：https://www.chanjetvip.com/doc/cate-172/doc-33772.html
2、参考下列语句修改内容：
https://o.oyonyou.com:9600/chanjet/guide/T+/37940/2_xvmf4h01isi.webp
（1）、查询存货的id，计量单位的id；
select id, idunit,*from AA_Inventory where code in('YCDZYH-0592','YCDZYH-0421','YCDZYH-0591','YCDZYH-0593')
https://o.oyonyou.com:9600/chanjet/guide/T+/37940/3_10gofdrmcwy.webp
（2）、查询采购订单明细存货的ID,计量单位的ID，单据明细行的ID编号.；
select id,idunit, idinventory,*from PU_PurchaseOrder_b where idinventory in(select id from AA_Inventory where code in('YCDZYH-0592','YCDZYH-0421','YCDZYH-0591','YCDZYH-0593')
)
and idPurchaseOrderDTO in(select id from PU_PurchaseOrder where code='PO-2024-04-0092')
https://o.oyonyou.com:9600/chanjet/guide/T+/37940/4_1t4kvfonpan.webp
（3）、更新采购订单明细行ID对应的计量单位的ID（参考存货ID)修改
UPDATE dbo.PU_PurchaseOrder_b SET idunit=5 WHERE id in('27835','27837','27838')
UPDATE dbo.PU_PurchaseOrder_b SET idunit=20 WHERE id='27836'
https://o.oyonyou.com:9600/chanjet/guide/T+/37940/5_d10yewsuzj4.webp
【效果】
https://o.oyonyou.com:9600/chanjet/guide/T+/37940/6_ercxgiafnkb.webp
页:
[1]