Hello,
is it possible restore / uncancel sales orders that were canceled (Have status "canceled").
If yes, please guide me how to achieve it. Could not find any procedure for it.
Thanks.
*This post is locked for comments
Ran the workflow to restore the order, it worked.
it works. Thank you
Dear Chandra,
This might be time consuming specially if the SO contains many lines. Moreover, if a SO is canceled shouldn't modify it to keep track and history.
Thank you,
Go to sales header on general ribbon
Find for line quantity button
For each line click deliver remainder update button
Then put back the qty you cancelled
To restore cancel order to open order in lines, I did like this
while select forupdate slineupd where slineupd.SalesId == salesTable.SalesId
{
slineupd.RemainInventPhysical = slineupd.SalesQty;
slineupd.RemainSalesPhysical = slineupd.SalesQty;
slineupd.update();
}
select forupdate stabupd where stabupd.SalesId == SalesTable.SalesId;
if (stabupd.RecId)
stabupd.SalesStatus=SalesStatus::Backorder;
stabupd.update();
as standard No way , you need some customization and strong business analysis to achieve your requirements
Hi I added a button to cancel order and in clicked method, I added the coding as:
db1 = box::yesNo("Do you want to Cancel PO?", dialogButton::No, "Cancel Order");
if (db1 == dialogButton::Yes)
db2 = box::yesNo("This Will Cancel all the PO, no further activities is possible. Do you want to continue?", dialogButton::No, "Cancel Order Confirmation");
if(db2 == dialogButton::Yes)
ttsBegin;
while select forupdate salesLine
where salesLine.SalesId == salesTable.SalesId
salesLine.RemainInventPhysical = 0;
salesLine.RemainSalesPhysical = 0;
salesLine.update();
ttscommit;
SalesTable_ds.research();
SalesLine_ds.research();
else
info("Cancel order process stopped");
info("Process canceled");
Also I've revoke cancel button how should I revoke the order?
If the Sales order has one line, then updating quantity/price and saving the record will change the line and header status to open but you have many lines, I guess creating new SO and copying lines from cancelled order will be feasible.
Thanks,
Pranav
Hi ,
you can add just a new line , and the SO will return in status open again...
if you want to use the same line , just change the price or qty , and the status line will change to open
Thanks
Ismail
Hi Joni,
If you create a new sales order for the same customer, then do 'Copy' -> 'From all', you can copy the lines from the cancelled order on to this new sales order.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Community Member 2
Guy Terry 2 Moderator
Martin Dráb 2 Most Valuable Professional