因改ITEM屬性造成訂單銷貨後訂單LINE為SHIPPED的沒扣庫存的處理

因改ITEM屬性造成訂單銷貨後訂單LINE為SHIPPED的沒扣庫存的處理

 因改ITEM屬性造成訂單銷貨後訂單LINE為SHIPPED的沒扣庫存的處理

SHIPPING TRANSACTION中為INTERFACED了,訂單為Shipped

下面三個REQUEST也無法RUN:

Order Management Interface - SRS
Inventory Interface - SRS
Interface Trip Stop - SRS

為此,要手工CANCELLED掉,再開新LINE來銷

select * from mtl_system_items_b
where segment1='PS305127NCP'
and organization_id=1041

 

select SHIPPED_QUANTITY, --&gt0
RELEASED_STATUS,  --C
inv_interfaced_flag,   --X
pickable_flag  --N
from WSH_DELIVERY_DETAILS
WHERE DELIVERY_DETAIL_ID in (8452514,8452515)

--修改此ITEM的狀態為撿料後的狀態

UPDATE WSH_DELIVERY_DETAILS
SET SHIPPED_QUANTITY=NULL,
RELEASED_STATUS='X',
inv_interfaced_flag='X',
pickable_flag='Y'
WHERE DELIVERY_DETAIL_ID in (8452514,8452515)

commit;

update wsh_delivery_assignments
set delivery_id=null
WHERE DELIVERY_DETAIL_ID in (8452514,8452515)

commit
 
然後在出貨畫面中重新產生一個DELIVERY ID

并SHIP CONFIRM,選BACKORDER 退回沒檢料的狀態

select * from oe_order_lines_all
where line_id=10443186
union all
select * from oe_order_lines_all
where line_id in (10440556,10440555)

改訂單狀態為非SHIPPED的,如

update  oe_order_lines_all
set shipped_quantity=null,
    shipping_quantity=null,
    actual_shipment_date=null,
    shipping_quantity2=null,
    shipped_quantity2=null,
    flow_status_code='AWAITING_SHIPPING'
where line_id in (10440556,10440555)
and flow_status_code='SHIPPED'

commit

然後回到訂單LINE畫面做CANCELLED

再重新下單來銷

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/92289/viewspace-1676296/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/92289/viewspace-1676296/