Hi All,
we are going to discuss about how to cancel a sales or Purchase order. If a Sales order or Purchase order gets a Cancelled status if it is cancelled in below way.
Here let us take example of Sales order cancellation process and same process holds for Purchase order also.
First create a new sales order and have one sales line for example.
Go to Sales order –> select sales line—> click Update line as shown in the below screenshot—> select Deliver remainder
New Update remainging quantity form is opened—> Click Cancel quantity button as shown in below screenshot.
once you perform this for a single line where no items are not delivered then automatically sales line status will be changed to Cancelled as shown in below screenshot.
Once you perform this for all lines which are not processed (means no items were delivered from all the lines) then automatically sales order header status will be changed to Cancelled as shown in below screenshot.
Hi I have tried the procedure to cancel sales order line remaining quantities, but it doesn’t change the status. Any setup is needed for this? I have tried using a new sales order, an order which is partially shipped, but it fails and doesn’t give any error. Appreciate your time to reply on this. Thanks
Hi Mohan, You can cancel Order if it is partially shipped. only you can do canceling remaining qty and not the order. If you want to cancel then reverse the partially shipped order and follow the steps in blog.
sorry, typo mistake, You cannot cancel order if it is partially shipped.
Hi Ram, Thanks for quick reply. I am not cancelling an order which is partially shipped. I am trying to cancel line items balances quantity by using the steps you’ve provided and doesn’t work. Can you advice is there is any setup to allow/disallow ‘cancel balance quantity’ feature?
Hi, For this you have to same process, select the line which you want to cancel for balances Qty. click Functions button–> select Deliver remainder –> Put ‘0’ in the Deliver remainder qty field and click OK. check the status of the line.
HOpe this helps you.
Hi Ram,
Thanks for the quick reply. As I mentioned, this line items status is not changing even after cancel for balance quantity using delivery remainder. May I know whether any setup is required to use this function? Any know issue why it is not functioning?
Thanks in advance.
Hi,
Can I know the status of the line, if it is delievered pls invoice and do cancelling.
Ram
Hi click OK or click Cancel quantity button and try it. As currently i dont have access to environment I couldnt tell you exactly. But this process address your issue.
when you cancel the qty that has not shipped where do you see this qty amount for that item move back into inventory or is there another step?
Hi Mohan,
Once you cancel the quantity the amount is deducted from Sale order or Purchase order and get back to Inventory account.
On the AX 2012 in the Maintain Action tab just click cancel after selecting the PO. it will cancel all the lines and the entire PO you wish to cancel.
HI Abhi,
Right now I dont have access to environment as I am at client place and I didnt try out your suggession. But thanks for your point.
I wanna cancel all line in once
Try to select all the lines and perform same action. I am not sure whether this option is enabled when all the lines are selected. try and see. If disabled means we need to do one by one only. or need to search for any other alternative.
Rather than cancel the sales order I want to delete it. Say it’s been entered in error. No transactions posted on it, delete the lines, but error when trying to delete the header saying ‘not posted transactions exist’. any ideas?
Looks strange, request to look into line level. try to delete line by line and then target header. if you delete in this way then you will understand as which line is stopping you in deleting. Look into saleline transactions and try to delete it. If there is Automatic reservation set for that Item also it is equal to trasaction as well. so take care here in reservation form as well.
Hi
i voided sales order and i need to make restore for my sales order (SO – 000013970). i searched by internet how i can make restore, i found one code to run in X++ by create a class to provide an option of restoring the orders
static void restoreDeletedSO(Args _args)
{
SalesTableDelete salesTableDelete;
SalesLineDelete salesLineDelete;
SalesTable salesTable;
SalesLine salesLine;
;
SalesTableDelete = SalesTableDelete::find(’SO – 000013970′, true);
ttsbegin;
switch (salesTableDelete.Cancelled)
{
case Voided::Voided :
salesTable = conpeek(salesTableDelete.SalesTable, 1);
salesTable.insert();
while select forupdate salesLineDelete where salesLineDelete.SalesId == salesTableDelete.SalesId
{
salesLine = conpeek(salesLineDelete.SalesLine, 1);
salesLine.insert();
}
salesTableDelete.delete();
break;
case Voided::linesVoided :
while select forupdate salesLineDelete where salesLineDelete.SalesId == salesTableDelete.SalesId
{
salesLine = conpeek(salesLineDelete.SalesLine, 1);
salesLine.insert();
salesLineDelete.delete();
}
salesTableDelete.delete();
break;
}
ttscommit;
}
When i make compile for my code there is error appearing syntax error for line number 1 and 3
how i can solve this issue??
Request to take AX technical help as they can say what is required by debugging it.
I cancelled items on a sales order and then when I created a return order the cancelled item still displayed on that sales order whne I pulled it in. Why did the cancelled item still show when I cancelled the item on the sales order. I was also able to pull that cancelled item in on the return order which was an error on my part but thought the item would not even show up?
I think this is a bug, even i was able to select a sales order whose items were arlready returned.
Request to raise a bug or inform this issue to Microsoft.
Hi,
Pls suggest how delete registered quantity in PO.
Thanks
HI Shiva,
select the particular PO line, go to registration form and deregister it by checking the check box again. (uppper pane line with Registered status). once you deregister it it comes to ordered status for inventory.
Now you can come out of this line and delete the line or change the quantity.
Try this one and let me know if this solved your problem
Hi there,
I have the following scenario – goods have been received and is currently in a quarantine warehouse. How do I go about returning this goods to a sender if no invoice has been created yet?
HI,
If they are not yet invoiced means we can do in this way. you have to change the qty to negative in the same line and do Packing slip or product receipt list. if this is not feasible we can add another line in same PO lines with negative and post the packing slip or product receipt list.
The other way is scap them in Quarantine wareshouse only and dont perform packing slip (this option is applicable only if packing slip is not posted)
Regards
Ram.
Pingback: Purchase Order Form Ax 2012 | Order Letters
Do you know of a way in AX2012 that you can tell WHEN a line was cancelled? We are pros at cancelling now but need to see the dates of when the cancellation occurred and I cannot seem to be able to do this? Any ideas?
HI Patti,
Sorry for late reply. you can ask Ax technical person to debug in table and check for the cancellation date. I think we get it if not we can customize it.
Regards,
Ram.
Hi, I processes the same as above and the remaining quantity is canceled, i ordered 1900 and received 1000 and i canceled the remaining 900, the LineQuantity in General tab shows Deliver remainder is 0 but the PO line is still show the quantity 1900, how to update the ordered quantity in Purchase Order line?
Please edit the line in quantity field after cancelling the reminders and update me with your findings. I hope you can do it manually.
The line quantity field is read-only, I can’t change the quantity, although if I don’t cancel the remaining quantity I unable to change the line quantity for those items which is partially received and invoices. Currently I’m using Dynamics AX R3
Hi Khaleel, Please check your security or access to that field. try as a Admin to that field. Normally is editable field. Check with other userIDs as well.
Ram
Hi, I got exactly the same issue and have Admin access but still cannot edit the field.
can you give some more details like, have you delivered some items as of now? Try to put 0 in the Inventory quanity section field and click cancel quantity and update me with your results
Reblogged this on DYNAMICS AX SOLUTIONS.
can we do partial cancellations
we can do it by clicking update line in so or po lines and click deliver reminder option and click cancel quantity buttion and close the form. This is equal to closing the PO or SO after partials.
We can do partial cancellation by doing the same process by editing the quanity in deliver reminder. or you can use close check box in Packing slip or invoice posting form in the lines.
Try this and update me.
Hi What happens when you click on the Cancel tab under Receive- Product Receipt and nothing after you select the line you want to cancel. The item remains never leaves not matter what .
What would cause this?
Hi Sorry for delay was bit busy with project.
For above query if PO is invoiced you cannot cancel or correct the line received. If it is not invoiced then still you are not able to cancel means we need to debug it techncially by techie.
nice