Unified Operations & Dynamics AX Forum

Expand all | Collapse all

User accidentally deleted a Sales Order

  • 1.  User accidentally deleted a Sales Order

    TOP CONTRIBUTOR
    Posted Dec 05, 2018 04:45 PM
    Edited by Rudy Salcedo Dec 05, 2018 04:46 PM
    ​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 Dec 06, 2018 12:37 AM
    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 Dec 06, 2018 01:07 AM
    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 Dec 06, 2018 09:06 AM
    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 Dec 06, 2018 09:31 AM
      |   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

    TOP CONTRIBUTOR
    Posted Dec 06, 2018 10:03 AM
    ​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
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role