The status after the sales order is shipped is: delivered; the next step is to run the interface. No deduction for warehouse inventory

The status after the sales order is shipped is: delivered; the next step is to run the interface. No deduction for warehouse inventory

The status after the sales order is shipped is: delivered; the next step is to run the interface. No deduction for warehouse inventory

Problem Overview

After a normal sales order is shipped, the row status in shipping -- transaction processing and the next step are as follows: the connection is not applicable, but the line status after the sales order is shipped and the next step is: the shipping operation interface. However, after the operation interface is run, the current quantity in the warehouse still exists, only the processing capacity is 0.

Cause:

Metalink is a system bug. Bug No. 4460875

Solution

Change OE_INTERFACED_FLAG (N to Y) and INV_INTERFACED_FLAG (N to P) from the database of the background table wsh_delivery_details. Then run the Interface request and the order can be interfaced.

-Wsh_delivery_details

-Trip stop request

-Reference: do not take any steps in the skip workflow unless you think this step will not take any action. Make sure to check the cause first, and then retry.

Second, there should be only one flag: INV_INTERFACED_FLAG. 'n' indicates that the flag is not thrown to inventory open interface, and 'P' indicates that the flag has been thrown, if it is 'n', check whether the item is faulty. Generally, it is COGS account generate issue. after exclusion, run 'trip stop'. If it is 'P', check whether there is any pening in inventory open interface. if there is, to eliminate the problem, resubmit and go to OM run 'trip stop' and it will pass.

The 'p' in INV_INTERFACED_FLAG is an interface identifier. After an Interface request is run, P changes to Y.

OE_INTERFACED_FLAG is only an interface mark of the sales module. The label of the undelivered order line should be N, and the order line of interfaced should be Y, you can check the status of the order line in the Y and N respectively, and you may understand