+11I 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
Best answer by Phil Seifert
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.
+23Hi 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.
+11Thanks, Phil - I can confirm I was able to open and delete the order
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.