因改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/

这篇关于因改ITEM屬性造成訂單銷貨後訂單LINE為SHIPPED的沒扣庫存的處理的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！