Unified Operations & Dynamics AX Forum

Expand all | Collapse all

User accidentally deleted a Sales Order

  • 1.  User accidentally deleted a Sales Order

    GOLD CONTRIBUTOR
    Posted 11 days ago
    Edited by Rudy Salcedo 11 days ago
    ​Has anyone had to restore a sales order from backup?

    Someone accidentally deleted an SO from our PRD environment and there is an open invoice against that SO.  I'm thinking that we would somehow restore the SalesTable and SalesLine records from backup for that SO.  But are there other tables that we would also have to restore records to?  (We are on AX 2012 R2.)

    ------------------------------
    Rudy Salcedo
    Senior Programmer/Analyst
    LaForce, Inc
    Green Bay WI
    ------------------------------


  • 2.  RE: User accidentally deleted a Sales Order

    Posted 11 days ago
    Hi Rudy,

    Depending on your parameters in AR, the deleted order may still be visible is the "Voided Orders", you can find that in the Inquiries/History menu path.  You won't be able to restore, however you will be able to see what was ordered etc.

    Regards
    Phil

    ------------------------------
    Phil Dawson
    Data#3 Limited
    Toowong
    ------------------------------



  • 3.  RE: User accidentally deleted a Sales Order

    TOP CONTRIBUTOR
    Posted 11 days ago
    Hi Rudy,
    To avoid similar issues in the future you should possibly rethink and redesign your users roles and what they are allowed to do.
    Best regards,
    Ludwig

    ------------------------------
    Ludwig Reinhard
    Sycor
    Veitshoechheim
    ------------------------------



  • 4.  RE: User accidentally deleted a Sales Order

    Posted 10 days ago
    Do you enter Sales Orders via EDI or manually?

    ------------------------------
    John Bergman
    The Mennel Milling Company
    Fostoria OH
    ------------------------------



  • 5.  RE: User accidentally deleted a Sales Order

    TOP CONTRIBUTOR
    Posted 10 days ago
      |   view attached
    ​If you retain copies of SOs that are deleted in Voided Sales orders, as @Phil Dawson mentions, you have a chance, because the record fields are mapped to a container field.
    Attached is what I use (AX2009). Depending on the state of your SO lines, you may have to tinker with the line qty values and associations with InventTrans related records. As usual, model in test.

    ------------------------------
    Mark Prouty
    Programmer / Analyst
    ANGI Energy Systems
    Janesville WI
    ------------------------------

    Attachment(s)



  • 6.  RE: User accidentally deleted a Sales Order

    GOLD CONTRIBUTOR
    Posted 10 days ago
    ​Thanks everyone, to answer some of your questions...the SOs are manually entered, and we do have our AR parameters set up such that we can see deleted orders in the "Voided sales orders" menu option.

    @Mark Prouty, thanks for the code for your solution.  I'll tweak and test it in a dev or test environment to see if I can make it work for our purpose.  Thanks!

     ​

    ------------------------------
    Rudy Salcedo
    Senior Programmer/Analyst
    LaForce, Inc
    Green Bay WI
    ------------------------------