采购退货从接收退货和从库存退货区别

今天做采购接收导入的时候发现了个问题

从交货入库退货

接收：会有两步，并产生两条记录，一条接收，一条入库

退货：会有两步，并产生两条记录，一条从库存退货至接收，一条从接收退货至供应商

后台数据：退货后库存现有相应量减少

rcv_transactions_interface.parent_transaction_id 的值取接收事务处理的id，即取数如下

           SELECT rt.transaction_id,
                 rt.shipment_header_id,
                 rt.shipment_line_id
            INTO v_transaction_id, v_ship_id, v_ship_line_id
            FROM rcv_transactions rt
           WHERE rt.transaction_type = 'DELIVER'
             AND rt.po_header_id = v_po_header_id
             AND rt.po_line_id = v_po_line_id
             AND rt.po_line_location_id = v_line_location_id
             AND rt.po_distribution_id = v_po_distribution_id;

接收数据

从接收退货

接收：会有两步，并产生两条记录，一条接收，一条入库

退货：只有一步，并产生一条记录，从接收退货至供应商

后台数据：退货后库存现有量不变

rcv_transactions_interface.parent_transaction_id 的值取接收事务处理的id，即取数如下

 SELECT rt.transaction_id,
                 rt.shipment_header_id,
                 rt.shipment_line_id
            INTO v_transaction_id, v_ship_id, v_ship_line_id
            FROM rcv_transactions rt
           WHERE rt.transaction_type = 'RECEIVE'
             AND rt.po_header_id = v_po_header_id
             AND rt.po_line_id = v_po_line_id
             AND rt.po_line_location_id = v_line_location_id
             AND rt.po_distribution_id = v_po_distribution_id;

退货数据

现有量还是原来的并没有减少

后台数据情况

结论：做采购退货的时候这点需要特别注意，是否需要现有量随退货减少，而做相应处理