Skip to main content

I have a user that managed to create a replenishment order to/from the same warehouse. The order was saved, but when we try to open it we get the error message:

The order should [sic] not be retrieved at this time becasue the process of replenishment list generation is not complete.You [sic] can navigate to other modules, or wait for the process to finish

We just need to be able to delete this order

Hi Bjorn,

This replenishment order never started actually started creating the replenishment lines.  The best thing to do at this point as you want to delete the replenishment order which you can not do until you can open the order.

Please use the following script which will update the status of the order to Open:

UPDATE repl_order_hdr
  SET 
      repl_order_stat = 100
WHERE replenish_order_id = '<your replenish_order_id>'
and repl_order_stat = 110; 

After this, you should be open the order and delete it via the UI.

 

Thanks, Phil - I can confirm I was able to open and delete the order

Reply


Terms & ConditionsCookie settings