web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

How to restore deleted PO/SO?

(0) ShareShare
ReportReport
Posted on by 1,260

Hi,

For some reason I am not able to view the deleted SO/PO? Is there a functionality in AX 2012 that I can use to view the deleted records?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Vilmos Kintera Profile Picture
    46,149 on at

    Take a look at the table SalesTableDelete, SalesLineDelete. If you keep voided sales orders, you could see them in there - it is also accessible somewhere from the Sales module.

    Generally speaking there is no way to get deleted records back in AX.

  • Daljit Kaur Rahsi Profile Picture
    1,260 on at

    Hi Vilmos,

    one of the user deleted the order from back end on a mistake, now I have re-created the order but as this order had already run the picking process I am not able to pick the items again for the new created order. How can I pick the new order in this case now?

  • Vilmos Kintera Profile Picture
    46,149 on at

    If it was deleted in SQL Server by referring backend then that could have left you with many orphaned records in InventTrans which are not linked to the original sales order line anymore, and can have an impact on your on-hand inventory in the InventSum table as well. Please provide more details on what has happened.

  • Daljit Kaur Rahsi Profile Picture
    1,260 on at

    And order was created and the items have completed the picking from the picking list registration. Next step was to post the packing slip - but for some reason the user deleted the order from the salestable and salesline record.

    Now after knowing this I re-uploaded the order in AX and when I go to pick the items again from the picking list registration I get an error "50.00 cannot be picked because only 0.00 is/are available from the inventory".

    Now because the items were already picked there is no quantity left to pick and I cannot complete the order.

    Either way, how can I unpick the quantities of the deleted order or complete the new order without affecting the inventory and so on?

  • Daljit Kaur Rahsi Profile Picture
    1,260 on at

    Also, I saw that from inventory management > periodic > picking list registration I found the previous record data. So I am unpick the items from the shipment and from there I will try to pick the items for the new created order. Just wondering if that will help?

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans