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

因改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博客 ” ，链接：/，如需转载，请注明出处，否则将追究法律责任。

转载于:/