首先要到出库通知单号

查询相关出库实绩是否生成

SELECT A.*,A.rowid FROM OUTSTOCKFACTTBL A WHERE A.OUTSTOCKINDICATIONID='OI8020231210000008';--出库实绩接口
SELECT A.*,A.rowid FROM OUTSTOCKFACTDTTBL A WHERE A.OUTSTOCKINDICATIONID='OI8020231210000008';--出库实绩接口

查询相关传输报文 ，也可以使用小I加油站查询，条件为出库通知单号

以下是相关SQL

SELECT TB1.BIZTRANSACTIONID 事务编号 ,TB1.KEYWORD 数据类型 ,TB1.CREDATE 处理时间,TB1.ORDERNO 订单号 ,TB1.DATA 发送数据,TB2.DATA 返回数据 FROM
(

SELECT A.DATATYPE ,A.BIZTRANSACTIONID ,A.KEYWORD ,A.CREDATE ,A.DATA ,A.ORDERNO FROM SCM_REQUEST_RECODE A WHERE 1=1
AND DATATYPE='发送'
AND ORDERNO LIKE 'OI8020231210000008%' AND KEYWORD = 'SYS_SCM_CKSJ' AND CREDATE >= TO_DATE('2023-12-11','yyyy-mm-dd hh24:mi:ss') AND CREDATE <= TO_DATE('2023-12-14','yyyy-mm-dd hh24:mi:ss')
AND ROWNUM <=5
) TB1,
(

SELECT A.DATATYPE ,A.BIZTRANSACTIONID ,A.KEYWORD ,A.CREDATE ,A.DATA ,A.ORDERNO FROM SCM_REQUEST_RECODE A WHERE 1=1
AND DATATYPE='返回'
AND ORDERNO LIKE 'OI8020231210000008%' AND KEYWORD = 'SYS_SCM_CKSJ' AND CREDATE >= TO_DATE('2023-12-11','yyyy-mm-dd hh24:mi:ss') AND CREDATE <= TO_DATE('2023-12-14','yyyy-mm-dd hh24:mi:ss')
AND ROWNUM <=5
) TB2
WHERE TB1.BIZTRANSACTIONID= TB2.BIZTRANSACTIONID
AND TB1.KEYWORD= TB2.KEYWORD
AND TB1.ORDERNO= TB2.ORDERNO

使用POSTman 组织修改报文回传

注意修改以下几项
1.OUTDTLID
2.QUALITYFLG
3.ERPORDERID
4.WMSGOODSQTY